Backup/restore does not work well even on a basic PBXT table with auto-increment
Bug #430596 reported by
Paul McCullagh
This bug affects 1 person
Affects | Status | Importance | Assigned to | Milestone | |
---|---|---|---|---|---|
PBXT |
Fix Committed
|
High
|
Paul McCullagh |
Bug Description
Bckup/restore does not work well even on a basic PBXT table with auto-increment: after restore the auto-increment value is reset, and insert into the table causes 'duplicate key' errors.
Related branches
To post a comment you must log in.
This bug can be repeated as follows:
DROP TABLE IF EXISTS t1;
CREATE TABLE t1 (c1 int primary key auto_increment, c2 varchar(200)) auto_increment = 1000 ENGINE=pbxt;
insert t1 (c2) values ("abc"), ("def"), ("ghi");
backup database test to 'test.bak';
drop database test;
restore from 'test.bak';
insert t1 (c2) values ("XYZ");