[MDEV-24237] Spider Engine and Table Auto Increment Problem Created: 2020-11-17  Updated: 2023-05-23

Status: Open
Project: MariaDB Server
Component/s: Storage Engine - Spider
Affects Version/s: 10.4.17
Fix Version/s: 10.4

Type: Bug Priority: Major
Reporter: Michael Assignee: Yuchen Pei
Resolution: Unresolved Votes: 0
Labels: None
Environment:

Centos 7


Attachments: File Spider Problem.mp4    

 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.


Generated at Thu Feb 08 09:28:27 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.