Uploaded image for project: 'MariaDB ColumnStore'
  1. MariaDB ColumnStore
  2. MCOL-4110

ColumnStore cannot handle case sensitive database and table name

    XMLWordPrintable

    Details

      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.

        Attachments

          Activity

            People

            Assignee:
            Unassigned Unassigned
            Reporter:
            dleeyh Daniel Lee
            Votes:
            0 Vote for this issue
            Watchers:
            1 Start watching this issue

              Dates

              Created:
              Updated:

                Git Integration

                Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.