diff options
author | Daniel Baumann <daniel.baumann@progress-linux.org> | 2024-05-04 18:00:34 +0000 |
---|---|---|
committer | Daniel Baumann <daniel.baumann@progress-linux.org> | 2024-05-04 18:00:34 +0000 |
commit | 3f619478f796eddbba6e39502fe941b285dd97b1 (patch) | |
tree | e2c7b5777f728320e5b5542b6213fd3591ba51e2 /mysql-test/suite/mariabackup/rename_during_backup.result | |
parent | Initial commit. (diff) | |
download | mariadb-upstream.tar.xz mariadb-upstream.zip |
Adding upstream version 1:10.11.6.upstream/1%10.11.6upstream
Signed-off-by: Daniel Baumann <daniel.baumann@progress-linux.org>
Diffstat (limited to 'mysql-test/suite/mariabackup/rename_during_backup.result')
-rw-r--r-- | mysql-test/suite/mariabackup/rename_during_backup.result | 63 |
1 files changed, 63 insertions, 0 deletions
diff --git a/mysql-test/suite/mariabackup/rename_during_backup.result b/mysql-test/suite/mariabackup/rename_during_backup.result new file mode 100644 index 00000000..e071b6b2 --- /dev/null +++ b/mysql-test/suite/mariabackup/rename_during_backup.result @@ -0,0 +1,63 @@ +CREATE TABLE t1(i int) ENGINE INNODB; +INSERT into t1 values(1); +CREATE TABLE t2(i int) ENGINE INNODB; +INSERT INTO t2 values(2); +CREATE TABLE t3(i int) ENGINE INNODB; +CREATE TABLE t4(i int) ENGINE INNODB; +CREATE TABLE t5(i int) ENGINE INNODB; +INSERT INTO t5 VALUES(5); +CREATE TABLE a(a int) ENGINE INNODB; +INSERT INTO a values(1); +CREATE TABLE b(b CHAR(1)) ENGINE INNODB; +INSERT INTO b VALUES('b'); +CREATE TABLE a1(a1 int) ENGINE INNODB; +INSERT INTO a1 VALUES(1); +CREATE TABLE b1(b1 CHAR(2)) ENGINE INNODB; +INSERT INTO b1 VALUES('b1'); +set global innodb_log_checkpoint_now = 1; +# xtrabackup prepare +# shutdown server +# remove datadir +# xtrabackup move back +# restart +CREATE TABLE t1(i int); +DROP TABLE t1; +SELECT * from t1_renamed; +i +1 +DROP TABLE t1_renamed; +CREATE TABLE t2(i int); +DROP TABLE t2; +SELECT * from t2_renamed; +i +2 +DROP TABLE t2_renamed; +SELECT * from t3; +i +3 +DROP TABLE t3; +SELECT * from t4; +i +DROP TABLE t4; +CREATE TABLE tmp(i int); +DROP TABLE tmp; +SELECT * FROM a; +b +b +SELECT * FROM b; +a +1 +SELECT * FROM a1; +b1 +b1 +SELECT * FROM b1; +a1 +1 +DROP TABLE a,b,a1,b1; +SELECT * from t5; +i +DROP TABLE t5; +SELECT * from t6; +i +5 +DROP TABLE t6; |