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

Unable to have spaces in column names in ddl

Details

    • Bug
    • Status: Closed (View Workflow)
    • Critical
    • Resolution: Fixed
    • 1.1.3-2, 1.1.5
    • 1.1.7
    • None
    • None
    • all
    • 2018-16, 2018-17, 2018-18, 2018-19, 2018-20, 2018-21

    Description

      MariaDB [innotest1]> CREATE TABLE t10 (`c300_500_18 REF NOx` varchar(20)) ENGINE = innodb;
      Query OK, 0 rows affected (0.01 sec)
      MariaDB [innotest1]> drop table t10;
      Query OK, 0 rows affected (0.00 sec)
      MariaDB [innotest1]> CREATE TABLE t10 (`c300_500_18 REF NOx` 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.

      Attachments

        Issue Links

          Activity

            I will be testing if this is same issue for table names too.

            rogereisentrager-oldjiradupe Roger Eisentrager (Inactive) added a comment - I will be testing if this is same issue for table names too.
            drrtuy Roman added a comment -

            Please review the change.

            drrtuy Roman added a comment - Please review the change.
            drrtuy Roman added a comment -

            Squashed the commits in this PR.

            drrtuy Roman added a comment - Squashed the commits in this PR .

            Build verified: 1.1.7-1

            Verified spaces in both table and column names.

            dleeyh Daniel Lee (Inactive) added a comment - Build verified: 1.1.7-1 Verified spaces in both table and column names.

            People

              dleeyh Daniel Lee (Inactive)
              rogereisentrager-oldjiradupe Roger Eisentrager (Inactive)
              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.