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

[Paul McCullagh]

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.

[Paul McCullagh (paul-mccullagh)]

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

[Paul McCullagh (paul-mccullagh)]

Fixed under RN272, version 1.0.09d.