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

          Activity

            People

            Assignee:
            toddstoffel Todd Stoffel
            Reporter:
            muhammad.irfan Muhammad Irfan
            Votes:
            0 Vote for this issue
            Watchers:
            3 Start watching this issue

              Dates

              Created:
              Updated: