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

create table failed with space + non "A-Z a-z 0-9 _" in column/table name

Details

    • Bug
    • Status: Closed (View Workflow)
    • Major
    • Resolution: Fixed
    • 1.2.3, 1.2.2
    • 1.2.6
    • DDLProc
    • None
    • 2019-06

    Description

      If paraenthesis and space are in the column name,
      the table creation failed.

      Error message:

      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.

      If work with parenthesis alone, also with space alone but not with both.

      so

      create table t1 ( `t)` int) engine=columnstore;

      and

       create table t2 ( `t space` int) engine=columnstore;

      works,

      but not 

       create table t3 ( `t (space` int) engine=columnstore;

      Attachments

        Issue Links

          relates to

          Bug - A problem which impairs or prevents the functions of the product. MCOL-1658 support space names in columnstore table column names

          • Major - Major loss of function.
          • Closed

          Bug - A problem which impairs or prevents the functions of the product. MCOL-1659 Unable to have spaces in column names in ddl

          • Critical - Crashes, loss of data, severe memory leak.
          • Closed

          Activity

            Ascending order - Click to sort in descending order
            Richard Richard Stracke added a comment -

            It seems the rule is space + a char which is not "A-Z a-z 0-9 _"

            Richard Richard Stracke added a comment - It seems the rule is space + a char which is not "A-Z a-z 0-9 _"
            LinuxJedi Andrew Hutchings (Inactive) added a comment -

            PR in engine and regression suite

            LinuxJedi Andrew Hutchings (Inactive) added a comment - PR in engine and regression suite
            bharath.bokka Bharath Bokka (Inactive) added a comment -

            Verified on,
            Build: 1.2.6-1

            create table with space + non "A-Z a-z 0-9 _" in column/table works fine.

            Ex:
            MariaDB [test]> create table t5(`col $` int, `col %` varchar(10), `col ^` char(6), `col &` text(45), `col *` decimal(6,2));
            Query OK, 0 rows affected (0.014 sec)

            MariaDB [test]> create table t6(`col (` bigint, `col )` float(6,2), `col -` boolean, `col +` numeric(5));
            Query OK, 0 rows affected (0.015 sec)

            MariaDB [test]> create table t8(`col =` timestamp, `col ?` real(6,2), `col >` blob, `col <` time, `col ' " : ; ] [ }

            { \ |` longtext); Query OK, 0 rows affected (0.018 sec) MariaDB [test]> create table `t ;$pace`(`col }

            ` mediumint);
            Query OK, 0 rows affected (0.006 sec)

            bharath.bokka Bharath Bokka (Inactive) added a comment - Verified on, Build: 1.2.6-1 create table with space + non "A-Z a-z 0-9 _" in column/table works fine. Ex: MariaDB [test] > create table t5(`col $` int, `col %` varchar(10), `col ^` char(6), `col &` text(45), `col *` decimal(6,2)); Query OK, 0 rows affected (0.014 sec) MariaDB [test] > create table t6(`col (` bigint, `col )` float(6,2), `col -` boolean, `col +` numeric(5)); Query OK, 0 rows affected (0.015 sec) MariaDB [test] > create table t8(`col =` timestamp, `col ?` real(6,2), `col >` blob, `col <` time, `col ' " : ; ] [ } { \ |` longtext); Query OK, 0 rows affected (0.018 sec) MariaDB [test]> create table `t ;$pace`(`col } ` mediumint); Query OK, 0 rows affected (0.006 sec)

            People

              bharath.bokka Bharath Bokka (Inactive)
              Richard Richard Stracke
              Votes:
              0 Vote for this issue
              Watchers:
              4 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.