# Test for archive backup partition bug.

--source include/not_embedded.inc

let $bdir=`select @@backupdir`;

# Find expected backup driver for the current storage engine.

--echo #
--echo # Creating databases
--echo #
CREATE DATABASE backup_part;

CREATE TABLE backup_part.t1 (
  t1_autoinc INTEGER NOT NULL AUTO_INCREMENT,
  t1_uuid CHAR(36),
  PRIMARY KEY (t1_autoinc)) ENGINE=ARCHIVE;

INSERT INTO backup_part.t1(t1_uuid) VALUES ('aaa'),('bbb'),('ccc'),('ddd'); 

--echo # Show content
SELECT * FROM backup_part.t1 ORDER BY t1_autoinc;

--echo #
--echo # Perform backup
--replace_column 1 #
let $bup_id= `BACKUP DATABASE backup_part TO 'partition.bak'`;

--echo #
--echo # Restore and show content
--echo #  

--replace_column 1 #
RESTORE FROM 'partition.bak' OVERWRITE;
--echo
SELECT * FROM backup_part.t1 ORDER BY t1_autoinc;

--echo #
--echo # Cleanup
--echo #  

DROP DATABASE backup_part;

--remove_file $bdir/partition.bak