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

          relates to

          Bug - A problem which impairs or prevents the functions of the product. MCOL-2219 create table failed with space + non "A-Z a-z 0-9 _" in column/table name

          • Major - Major loss of function.
          • Closed

          Activity

            Ascending order - Click to sort in descending order
            rogereisentrager-oldjiradupe Roger Eisentrager (Inactive) created issue -
            rogereisentrager-oldjiradupe Roger Eisentrager (Inactive) added a comment -

            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.
            dthompson David Thompson (Inactive) made changes -
            Field Original Value New Value
            Fix Version/s 1.1.7 [ 23136 ]
            dthompson David Thompson (Inactive) made changes -
            Assignee Andrew Hutchings [ linuxjedi ]
            dthompson David Thompson (Inactive) made changes -
            Assignee Andrew Hutchings [ linuxjedi ] Roman [ drrtuy ]
            dthompson David Thompson (Inactive) made changes -
            Sprint 2018-16 [ 269 ]
            drrtuy Roman made changes -
            Status Open [ 1 ] In Progress [ 3 ]
            drrtuy Roman added a comment -

            Please review the change.

            drrtuy Roman added a comment - Please review the change.
            drrtuy Roman made changes -
            Assignee Roman [ drrtuy ] David Hall [ david.hall ]
            Status In Progress [ 3 ] In Review [ 10002 ]
            drrtuy Roman added a comment -

            Squashed the commits in this PR.

            drrtuy Roman added a comment - Squashed the commits in this PR .
            David.Hall David Hall (Inactive) made changes -
            Status In Review [ 10002 ] In Testing [ 10301 ]
            David.Hall David Hall (Inactive) made changes -
            Assignee David Hall [ david.hall ] Daniel Lee [ dleeyh ]
            LinuxJedi Andrew Hutchings (Inactive) made changes -
            Sprint 2018-16 [ 269 ] 2018-16, 2018-17 [ 269, 276 ]
            LinuxJedi Andrew Hutchings (Inactive) made changes -
            Sprint 2018-16, 2018-17 [ 269, 276 ] 2018-16, 2018-17, 2018-18 [ 269, 276, 278 ]
            LinuxJedi Andrew Hutchings (Inactive) made changes -
            Sprint 2018-16, 2018-17, 2018-18 [ 269, 276, 278 ] 2018-16, 2018-17, 2018-18, 2018-19 [ 269, 276, 278, 283 ]
            LinuxJedi Andrew Hutchings (Inactive) made changes -
            Sprint 2018-16, 2018-17, 2018-18, 2018-19 [ 269, 276, 278, 283 ] 2018-16, 2018-17, 2018-18, 2018-19, 2018-20 [ 269, 276, 278, 283, 288 ]
            LinuxJedi Andrew Hutchings (Inactive) made changes -
            Sprint 2018-16, 2018-17, 2018-18, 2018-19, 2018-20 [ 269, 276, 278, 283, 288 ] 2018-16, 2018-17, 2018-18, 2018-19, 2018-20, 2018-21 [ 269, 276, 278, 283, 288, 295 ]
            dleeyh Daniel Lee (Inactive) added a comment -

            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.
            dleeyh Daniel Lee (Inactive) made changes -
            issue.field.resolutiondate 2018-12-19 20:52:55.0 2018-12-19 20:52:55.44
            dleeyh Daniel Lee (Inactive) made changes -
            Resolution Fixed [ 1 ]
            Status In Testing [ 10301 ] Closed [ 6 ]
            Richard Richard Stracke made changes -

            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.