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

CS does not support reserved words as column names

    XMLWordPrintable

Details

    • Bug
    • Status: Closed (View Workflow)
    • Major
    • Resolution: Fixed
    • None
    • 1.2.0
    • None
    • None

    Description

      create table kvstore(
      `key` varchar(1024),
      `value` varchar(1024)
      ) 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.

      The whole point of having backticks is so that reserved words can be used. This is very broken! Modifying an application to change column names (or table names) is not trivial.

      Also, the error message is completely wrong and misleading. I have complex tables with many columns and I ended up doing a binary search to figure out which column was affected. These error messages should be much more helpful, not to mention they should be grammatically correct.

      Attachments

        Issue Links

          duplicates

          Bug - A problem which impairs or prevents the functions of the product. MCOL-950 Can't use key words as field or table name with quote(`)

          • Major - Major loss of function.
          • Closed
          is duplicated by

          Bug - A problem which impairs or prevents the functions of the product. MCOL-1006 "Action" (and maybe other reserved words) cannot be used as column names

          • Trivial - Cosmetic problem like misspelt words or misaligned text.
          • Closed

          Bug - A problem which impairs or prevents the functions of the product. MCOL-1022 Reserved keywords can't create table

          • Major - Major loss of function.
          • Closed
          is part of

          Bug - A problem which impairs or prevents the functions of the product. MCOL-1384 Couldn't use reserved words in idents even with quotes(backport from develop)

          • Minor - Minor loss of function, or other problem where easy workaround is present.
          • Closed
          relates to

          Bug - A problem which impairs or prevents the functions of the product. MCOL-161 CREATE TABLE does not report what columns have invalid data types

          • Minor - Minor loss of function, or other problem where easy workaround is present.
          • Closed

          New Feature - A new feature of the product, which has yet to be developed. MCOL-569 CS does not support reserved words as table names

          • Major - Major loss of function.
          • Closed

          Activity

            People

              dleeyh Daniel Lee (Inactive)
              jswanhart Justin Swanhart (Inactive)
              Votes:
              1 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.