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

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Closed (View Workflow)
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: 1.2.2, 1.2.3
    • Fix Version/s: 1.2.6
    • Component/s: DDLProc
    • Labels:
      None
    • Sprint:
      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

            Activity

              People

              Assignee:
              bharath.bokka Bharath Bokka
              Reporter:
              Richard Richard Stracke
              Votes:
              0 Vote for this issue
              Watchers:
              4 Start watching this issue

                Dates

                Created:
                Updated:
                Resolved: