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

"Action" (and maybe other reserved words) cannot be used as column names

    XMLWordPrintable

Details

    • Bug
    • Status: Closed (View Workflow)
    • Trivial
    • Resolution: Duplicate
    • 1.0.11
    • Icebox
    • DDLProc
    • None
    • Debian Jessie 8.x 64bits

    Description

      Hello,

      I am trying to create a simple table, where one column name is "action".
      Columnstore doesn't allow me to create it, with or without back quotes.

      MariaDB [test]> create table t1 (`action` int) engine=innodb;
      Query OK, 0 rows affected (0.02 sec)
       
      MariaDB [test]> create table t2 (`action` int) 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 [test]> create table t2 (`othername` int) engine=columnstore;
      Query OK, 0 rows affected (0.14 sec)
      

      Is this a known limitation ?
      Thanks for checking!
      Joffrey

      Attachments

        Issue Links

          Activity

            People

              LinuxJedi Andrew Hutchings (Inactive)
              joffrey92 Joffrey MICHAIE
              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.