Backup/restore does not work well even on a basic PBXT table with auto-increment

Bug #430596 reported by Paul McCullagh
6
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

Revision history for this message
Paul McCullagh (paul-mccullagh) wrote :

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");

Changed in pbxt:
assignee: nobody → Paul McCullagh (paul-mccullagh)
importance: Undecided → High
status: New → Confirmed
Revision history for this message
Paul McCullagh (paul-mccullagh) wrote :

Fixed under RN272, version 1.0.09d.

Changed in pbxt:
status: Confirmed → Fix Committed
To post a comment you must log in.
This report contains Public information  
Everyone can see this information.

Other bug subscribers