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

ALTER TABLE doesn't support AFTER

    XMLWordPrintable

    Details

    • Type: New Feature
    • Status: Confirmed (View Workflow)
    • Priority: Minor
    • Resolution: Unresolved
    • Affects Version/s: 1.0.8, 1.1.3
    • Fix Version/s: Icebox
    • Component/s: None

      Description

      If someone attempts to execute a command like the following:

      ALTER TABLE tab ADD COLUMN `col2` INT AFTER `col1`;
      

      Then they will see errors like the following:

      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.
      

      At least at the time that this JIRA issue is being created, I don't see this limitation mentioned here:

      https://mariadb.com/kb/en/mariadb/ddl-statements-that-differ-for-columnstore/

      And I do see that "AFTER" is shown as a part of the grammar of "ALTER TABLE" here:

      https://mariadb.com/kb/en/mariadb/columnstore-alter-table/

        Attachments

          Activity

            People

            Assignee:
            ben.thompson Ben Thompson
            Reporter:
            GeoffMontee Geoff Montee
            Votes:
            0 Vote for this issue
            Watchers:
            4 Start watching this issue

              Dates

              Created:
              Updated: