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

ADD COLUMN AFTER throws syntax error

    XMLWordPrintable

Details

    • Bug
    • Status: Open (View Workflow)
    • Major
    • Resolution: Unresolved
    • None
    • Icebox
    • None
    • None
    • Server version: 10.5.6
      MCS version: 1.5.4-1

    Description

      ADD COLUMN AFTER throws syntax error.

      MariaDB [test]> CREATE TABLE t1 (c1 INT, c2 CHAR(1)) ENGINE=Columnstore;
      Query OK, 0 rows affected (0.145 sec)

      MariaDB [test]> ALTER TABLE t1 ADD COLUMN c12 CHAR(1) AFTER c1;
      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.

      This is supported by Innodb.

      Attachments

        Issue Links

          Activity

            People

              Unassigned Unassigned
              susil.behera Susil Behera
              Votes:
              0 Vote for this issue
              Watchers:
              1 Start watching this issue

              Dates

                Created:
                Updated:

                Git Integration

                  Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.