ColumnStore cannot handle case sensitive database and table name

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;
--------------

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

--------------
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.