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

Table naming does not allow for spaces

    XMLWordPrintable

Details

    Description

      MariaDB [innotest1]> CREATE TABLE t20 (c1 varchar(20)) ENGINE = innodb;
      Query OK, 0 rows affected (0.01 sec)

      MariaDB [innotest1]> drop table t20;
      Query OK, 0 rows affected (0.01 sec)

      MariaDB [innotest1]>
      MariaDB [innotest1]> – Backtic in table name in innodb and no spaces in name
      MariaDB [innotest1]> CREATE TABLE `t20` (c1 varchar(20)) ENGINE = innodb;
      Query OK, 0 rows affected (0.00 sec)

      MariaDB [innotest1]>
      MariaDB [innotest1]> – Backtic in table name in innodb and 1 spaces after the name
      MariaDB [innotest1]> CREATE TABLE `t21 ` (c1 varchar(20)) ENGINE = innodb;
      ERROR 1103 (42000): Incorrect table name 't21 '
      MariaDB [innotest1]>
      MariaDB [innotest1]> – Backtic in table name in innodb and 1 space in middle of name
      MariaDB [innotest1]> CREATE TABLE `t2 2` (c1 varchar(20)) ENGINE = innodb;
      Query OK, 0 rows affected (0.01 sec)
      MariaDB [innotest1]>
      MariaDB [innotest1]> – Backtic in table name in innodb and 1 space in front of name and middle and space at end
      MariaDB [innotest1]> CREATE TABLE ` t2 3 ` (c1 varchar(20)) ENGINE = innodb;
      ERROR 1103 (42000): Incorrect table name ' t2 3 '
      MariaDB [innotest1]>
      MariaDB [innotest1]> – No Backtic in table name in innodb and 1 space in middle of name
      MariaDB [innotest1]> CREATE TABLE t2 4 (c1 varchar(20)) ENGINE = innodb;
      ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '4 (c1 varchar(20)) ENGINE = innodb' at line 1

      – ---------------------------------------------------

      MariaDB [innotest1]> – No backtic in table name in columnstore
      MariaDB [innotest1]> CREATE TABLE t30 (c1 varchar(20)) ENGINE = columnstore;
      Query OK, 0 rows affected (0.29 sec)
      MariaDB [innotest1]>
      MariaDB [innotest1]>
      MariaDB [innotest1]> drop table t30;
      Query OK, 0 rows affected (0.17 sec)
      MariaDB [innotest1]>
      MariaDB [innotest1]>
      MariaDB [innotest1]> – Backtic in table name in columnstore and no spaces in name
      MariaDB [innotest1]> CREATE TABLE `t30` (c1 varchar(20)) ENGINE = columnstore;
      Query OK, 0 rows affected (0.14 sec)

      MariaDB [innotest1]>
      MariaDB [innotest1]> – Backtic in table name in columnstore and 1 spaces after the name
      MariaDB [innotest1]> CREATE TABLE `t31 ` (c1 varchar(20)) ENGINE = columnstore;
      ERROR 1103 (42000): Incorrect table name 't31 '
      MariaDB [innotest1]>
      MariaDB [innotest1]>
      MariaDB [innotest1]> – Backtic in table name in columnstore and 1 space in middle of name
      MariaDB [innotest1]> CREATE TABLE `t3 2` (c1 varchar(20)) ENGINE = columnstore;
      ERROR 1178 (42000): The storage engine for the table doesn't support The syntax or the data type(s) is not supported by Columnstore. Please check the Columnstore syntax guide for supported syntax or data types.
      MariaDB [innotest1]>
      MariaDB [innotest1]> – Backtic in table name in columnstore and 1 space in front of name and middle and space at end
      MariaDB [innotest1]> CREATE TABLE ` t3 3 ` (c1 varchar(20)) ENGINE = columnstore;
      ERROR 1103 (42000): Incorrect table name ' t3 3 '
      MariaDB [innotest1]>
      MariaDB [innotest1]>
      MariaDB [innotest1]> – No Backtic in table name in columnstore and 1 space in middle of name
      MariaDB [innotest1]> CREATE TABLE t2 4 (c1 varchar(20)) ENGINE = columnstore;
      ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '4 (c1 varchar(20)) ENGINE = columnstore' at line 1

      – In conclusion for innodb
      – 1 backtics and space at end of table name does not work
      – 2 backtics and space in the middle of table does work
      – 3 backtics and space in front or in the middle or at the end does not work

      – In conclusion for columnstore
      – 1 backtics and space at end of table name does not work
      – 2 backtics and space in the middle of table does NOT work (this is different vs innodb which allowed this)
      – 3 backtics and space in front or in the middle or at the end does not work

      Attachments

        Activity

          People

            dleeyh Daniel Lee (Inactive)
            rogereisentrager-oldjiradupe Roger Eisentrager (Inactive)
            Votes:
            0 Vote for this issue
            Watchers:
            3 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved:

              Git Integration

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