[MCOL-4110] ColumnStore cannot handle case sensitive database and table name Created: 2020-06-25 Updated: 2023-10-25 Resolved: 2023-10-25 |
|
| Status: | Closed |
| Project: | MariaDB ColumnStore |
| Component/s: | cpimport, DDLProc, DMLProc |
| Affects Version/s: | 1.5.2 |
| Fix Version/s: | Icebox |
| Type: | Bug | Priority: | Minor |
| Reporter: | Daniel Lee (Inactive) | Assignee: | Unassigned |
| Resolution: | Won't Fix | Votes: | 0 |
| Labels: | None | ||
| Description |
|
Build tested: 1.5.2-1 (community edition b33685) By designed, ColumnStore engine stores database and table object names in its system catalog using lower case strings. In these release, database and table names are case sensitive. The user can create in the same database: table1 (innodb) But user cannot create table1 (columnstore) In fact databaseName.tableName combination is not case sensitive in ColumnStore MariaDB [(none)]> create database d1; MariaDB [d1]> use d1 MariaDB [d1]> create table t1( c1 int) engine=columnstore; MariaDB [d1]> show tables;
--------------
-------------- MariaDB [d1]> create database D1; MariaDB [d1]> use D1 MariaDB [D1]> show tables; MariaDB [D1]> create table t1( c1 int) engine=columnstore; Also, cpimport is not case sensitive. |
| Comments |
| Comment by Daniel Lee (Inactive) [ 2021-01-14 ] |
|
Build tested: 5.5.1-1 The same still exist for ColumnStore tables. InnoDB tables are ok. It does not make a difference when setting lower_case_table_names=1 in the server.cnf file. |