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

CLONE - ALTER TABLE doesn't support AFTER

    XMLWordPrintable

Details

    • New Feature
    • Status: Closed (View Workflow)
    • Major
    • Resolution: Duplicate
    • 1.0.8, 1.1.3
    • 23.10.0
    • DDLProc
    • 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

        Issue Links

          duplicates

          New Feature - A new feature of the product, which has yet to be developed. MCOL-694 ALTER TABLE doesn't support AFTER

          • Major - Major loss of function.
          • Closed
          relates to

          New Feature - A new feature of the product, which has yet to be developed. MCOL-2125 BEFORE/AFTER keyword to add column in middle of table

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

          Activity

            People

              maxmether Max Mether
              manish9292 Manish Choudhary
              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.