The Ultimate Guide to High Availability with MariaDB
This is a read-only copy of the MariaDB Knowledgebase generated on 2024-11-15. For the latest, interactive version please visit https://mariadb.com/kb/.

Object Name : Naming Rule ?

Hello. I have some questions regarding to MariaDB ColumnStore object naming rules. I'm a bit puzzled when I came up to issue a CREATE TABLE statement...

I have read the following page, but my question is not mentioned ; - https://mariadb.com/kb/en/mariadb/columnstore-naming-conventions/

1) For non-ASCII characters (but in UTF-8 defined) , such as Japanese or special controll character CR/LF , can it be used in object names (tables and columns for example) ? (Assuming to quote it surrounding by ` )

2) Seems like including hyphen in column name caused an error upon CREATE TABLE statement. Such as a column named `col-1` `col-2` ; - ERROR 328856920 - The storage engine for the table doesn't support The syntax or the data type(s) is not supported by Columnstore. Is this an expected behavior ? Any other characters that are not allowed ?

3) Confirmed that the statement works on both normal (I mean non ColumnStore) MariaDB and MySQL but fails on MariaDB ColumnStore mode.

Thank you in advance.

Answer Answered by David Thompson in this comment.

Currently, you should limit yourself to alphanumeric and underscore only, i.e. "A-Z a-z 0-9 _". I have corrected https://mariadb.com/kb/en/mariadb/columnstore-naming-conventions/ and filed an enhancement for this:https://jira.mariadb.org/browse/MCOL-716

Content reproduced on this site is the property of its respective owners, and this content is not reviewed in advance by MariaDB. The views, information and opinions expressed by this content do not necessarily represent those of MariaDB or any other party.