ColumnStore Naming Conventions
This lists the different naming conventions enforced by the column store, compared to the normal MariaDB naming conventions.
- User names: 64 characters (MariaDB has 80)
- Table and column names are restricted to alphanumeric and underscore only, i.e "A-Z a-z 0-9 _".
- The first character of all table and column names should be an ASCII letter (a-z A-Z).
- ColumnStore reserves certain words that MariaDB does not, such as SELECT, CHAR and TABLE, so even wrapped in backticks these cannot be used.
Reserved words
In addition to MariaDB Server reserved words, ColumnStore has additional reserved words that cannot be used as table names, column names or user defined variables, functions or stored procedure names.
| Keyword |
|---|
| ACTION |
| ADD |
| ALTER |
| AUTO_INCREMENT |
| BIGINT |
| BIT |
| CASCADE |
| CHANGE |
| CHARACTER |
| CHARSET |
| CHECK |
| CLOB |
| COLUMN |
| COLUMNS |
| COMMENT |
| CONSTRAINT |
| CONSTRAINTS |
| CREATE |
| CURRENT_USER |
| DATETIME |
| DEC |
| DECIMAL |
| DEFERRED |
| DEFAULT |
| DEFERRABLE |
| DOUBLE |
| DROP |
| ENGINE |
| EXISTS |
| FOREIGN |
| FULL |
| IDB_BLOB |
| IDB_CHAR |
| IDB_DELETE |
| IDB_FLOAT |
| IDB_INT |
| IF |
| IMMEDIATE |
| INDEX |
| INITIALLY |
| INTEGER |
| KEY |
| MATCH |
| MAX_ROWS |
| MIN_ROWS |
| MODIFY |
| NO |
| NOT |
| NULL_TOK |
| NUMBER |
| NUMERIC |
| ON |
| PARTIAL |
| PRECISION |
| PRIMARY |
| REAL |
| REFERENCES |
| RENAME |
| RESTRICT |
| SESSION_USER |
| SET |
| SMALLINT |
| SYSTEM_USER |
| TABLE |
| TIME |
| TINYINT |
| TO |
| TRUNCATE |
| UNIQUE |
| UNSIGNED |
| UPDATE |
| USER |
| VARBINARY |
| VARCHAR |
| VARYING |
| WITH |
| ZONE |
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.
© 2021 MariaDB
Licensed under the Creative Commons Attribution 3.0 Unported License and the GNU Free Documentation License.
https://mariadb.com/kb/en/columnstore-naming-conventions/