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

Unsupported auto_increment error is coming from Innodb engine

    XMLWordPrintable

Details

    • Bug
    • Status: Closed (View Workflow)
    • Minor
    • Resolution: Fixed
    • None
    • Icebox
    • DDLProc
    • None
    • Server version: 10.5.4-MariaDB MariaDB Server
      Columnstore: 1.5.2-1

    Description

      Columnstore doesn't support CREATE TABLE with auto_increment. But when someone executes it the error msg seems to come from Innodb engine.

      CREATE TABLE t1 (a INT auto_increment) ENGINE=Columnstore;
      ERROR 1075 (42000): Incorrect table definition; there can be only one auto column and it must be defined as a key

      Appropriate error msg should come from Columnstore engine.

      Attachments

        Activity

          People

            Unassigned Unassigned
            susil.behera susil.behera
            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.