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

callastinsertid after alter table doesn't show correct autoincrement value

    XMLWordPrintable

Details

    • Bug
    • Status: Closed (View Workflow)
    • Blocker
    • Resolution: Fixed
    • 23.10.1
    • 23.10.0
    • ?
    • None
    • 2023-10, 2023-11

    Description

      Part of regr test005 failing:

      create table foo (col1 int) engine=columnstore;
      insert into foo values ( 1 ), ( 2 ), ( 3 ), ( 4 ), ( 5 );
      Alter table foo add column newcol bigint comment 'autoincrement';
      select callastinsertid('foo');

      should give result = 5 but now gives 0

      Similar problem if column is not added but changed from non-autoincrement to autoincrement.

      Test:
      https://github.com/mariadb-corporation/mariadb-columnstore-regression-test/blob/MCOL-5558-KP-regr-fix-test005-test013/mysql/queries/working_dml/misc/autoincrement.negative.sql
      lines 31-43

      Is broken since 06 Sep 2023 in develop.

      Attachments

        Activity

          People

            tntnatbry Gagan Goel (Inactive)
            kirill.perov@mariadb.com Kirill Perov
            Kirill Perov Kirill Perov
            Votes:
            0 Vote for this issue
            Watchers:
            3 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.