Uploaded image for project: 'MariaDB Server'
  1. MariaDB Server
  2. MDEV-24237

Spider Engine and Table Auto Increment Problem

    XMLWordPrintable

Details

    Description

      I found the following inconsistent with spider engine.

      Let's say we create a Data Table on Server 1 with an auto increment column (ID) and set it up with a value bigger than 1. For example 1000

      On Server 2 we create the Spider Table of the Server 1 Table.

      On Server 1 with the empty table if you add a a new row the ID will begin with 1000.

      On Server 2 with the Spider Table on an empty table with the auto increment 1000 if you add a row the auto increment will start with 1.

      If you add a row first on Server 1 on the Data Table that take the value 1000 and then go to Server 2 on Spider Table and add another row it will go correctly from auto increment 1001 and beyond.

      Please look at the attached screen record.

      Thank you.

      Attachments

        Activity

          People

            ycp Yuchen Pei
            MikeGiann Michael
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

            Dates

              Created:
              Updated:

              Git Integration

                Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.