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

Can not add a column anywhere other than the end of the table

    XMLWordPrintable

Details

    • Bug
    • Status: Closed (View Workflow)
    • Minor
    • Resolution: Fixed
    • 1.1.2
    • Icebox
    • Documentation
    • None

    Description

      Documentation on ALTER TABLE syntax includes FIRST and AFTER:
      https://mariadb.com/kb/en/library/columnstore-alter-table
      However, my test queries:

      ALTER TABLE test.t1 ADD COLUMN testSmallInt SMALLINT FIRST;
      		 
      ALTER TABLE test.t1 ADD COLUMN testInt INT AFTER a;

      fail with

      Error Code: 1178. 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.

      It appears that MariaDB ColumnStore is unable to add a column anywhere other than the end of the table (i.e. same limitation as InfiniDB has).

      Could the documentation be updated accordingly?

      Attachments

        Activity

          People

            LinuxJedi Andrew Hutchings (Inactive)
            sasha Sasha V
            Votes:
            0 Vote for this issue
            Watchers:
            2 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.