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

ALTER TABLE ADD COLUMN returns internal error

    XMLWordPrintable

Details

    • Bug
    • Status: Closed (View Workflow)
    • Major
    • Resolution: Cannot Reproduce
    • 5.6.1
    • 6.2.1
    • MDB Plugin
    • None
    • 2021-9, 2021-10, 2021-11, 2021-12, 2021-13, 2021-14

    Description

      ALTER TABLE ADD COLUMN returns internal error for DDL given in the first comment.
      It is important to tell that ALTER TABLE ADD COLUMN adds the column.
      debug.log contains an error that points to the fact that MDB uses offline ALTER proto under the hood first creating tmp table, replacing the original table and removing the obsolete table later. However MCS alters the table adding column in-place so MCS doesn't follow the protocol MDB expects. The error produced presumably produced by the DROP TABLE statement for the temp table created previously.

      Attachments

        Activity

          People

            Unassigned Unassigned
            drrtuy Roman
            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.