[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)
TABLE1 (columnstore)

But user cannot create

table1 (columnstore)
TABLE1 (columnstore)

In fact databaseName.tableName combination is not case sensitive in ColumnStore

MariaDB [(none)]> create database d1;
Query OK, 1 row affected (0.001 sec)

MariaDB [d1]> use d1
Database changed

MariaDB [d1]> create table t1( c1 int) engine=columnstore;
Query OK, 0 rows affected (0.784 sec)

MariaDB [d1]> show tables;
--------------

Tables_in_d1

--------------

t1

--------------
1 row in set (0.000 sec)

MariaDB [d1]> create database D1;
Query OK, 1 row affected (0.001 sec)

MariaDB [d1]> use D1
Database changed

MariaDB [D1]> show tables;
Empty set (0.001 sec)

MariaDB [D1]> create table t1( c1 int) engine=columnstore;
ERROR 1815 (HY000): Internal error: CAL0009: Internal create table error for d1.t1 : table already exists (your schema is probably out-of-sync)
MariaDB [D1]> create table T1( c1 int) engine=columnstore;
ERROR 1815 (HY000): Internal error: CAL0009: Internal create table error for d1.T1 : table already exists (your schema is probably out-of-sync)
MariaDB [D1]> show tables;
Empty set (0.001 sec)

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.

Generated at Thu Feb 08 02:47:52 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.