[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: |
|
| 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. |