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

BEFORE/AFTER keyword to add column in middle of table

    XMLWordPrintable

Details

    Description

      I noticed we don't have BEFORE/AFTER keyword for columnstore table to add column at specific position. It would be nice if we have this option in columnstore table like in InnoDB engine.
      That's how it works in InnoDB.

      MariaDB [abc]> CREATE TABLE innodb_test ( A int, C int) ENGINE=InnoDB;
      Query OK, 0 rows affected (0.02 sec)

      MariaDB [abc]> ALTER TABLE innodb_test ADD COLUMN B INT AFTER A;
      Query OK, 0 rows affected (0.02 sec)
      Records: 0 Duplicates: 0 Warnings: 0

      MariaDB [abc]> show create table innodb_test\G
      Table: cs_test
      Create Table: CREATE TABLE `cs_test` (
      `A` int(11) DEFAULT NULL,
      `B` int(11) DEFAULT NULL,
      `C` int(11) DEFAULT NULL
      ) ENGINE=InnoDB DEFAULT CHARSET=utf8

      while the same error out in CS engine.

      ALTER TABLE cs_test ADD COLUMN B INT AFTER A;
      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.

      Attachments

        Issue Links

          Activity

            People

              toddstoffel Todd Stoffel (Inactive)
              muhammad.irfan Muhammad Irfan
              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.