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

can't reset autoincrement values

    XMLWordPrintable

    Details

    • Sprint:
      2016-25, 2017-01, 2017-2

      Description

      Hi,

      How to adjust autoincrement to max value+1 after data load from csv ?

      MariaDB [asdb]> alter table tablename COMMENT 'autoincrement=id;autoincrement=5492786873';
      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.

      MariaDB [asdb]> alter table tablename COMMENT 'autoincrement=id,5492786873';
      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.

      Thanks
      Suresh Rajagopal

        Attachments

          Issue Links

            Activity

              People

              Assignee:
              dthompson David Thompson (Inactive)
              Reporter:
              dthompson David Thompson (Inactive)
              Votes:
              0 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.