summaryrefslogtreecommitdiff
path: root/mysql-test/suite/galera/r/galera_drop_multi.result
diff options
context:
space:
mode:
authorPhilip Stoev <philip.stoev@galeracluster.com>2015-05-08 03:21:50 -0700
committerNirbhay Choubey <nirbhay@mariadb.com>2015-09-09 21:36:03 -0400
commitf9805e4c984d251fec76f39bcd6a675e6cf5e6df (patch)
tree67cbb5c3a671258de14500183d751413e46796e6 /mysql-test/suite/galera/r/galera_drop_multi.result
parentef7b08978b9300d456217ae55b623ff9c5b30744 (diff)
downloadmariadb-git-f9805e4c984d251fec76f39bcd6a675e6cf5e6df.tar.gz
Galera MTR Tests: tests for WAN restart, xtrabackup options and others.
Diffstat (limited to 'mysql-test/suite/galera/r/galera_drop_multi.result')
-rw-r--r--mysql-test/suite/galera/r/galera_drop_multi.result20
1 files changed, 20 insertions, 0 deletions
diff --git a/mysql-test/suite/galera/r/galera_drop_multi.result b/mysql-test/suite/galera/r/galera_drop_multi.result
new file mode 100644
index 00000000000..d82ae3bec1a
--- /dev/null
+++ b/mysql-test/suite/galera/r/galera_drop_multi.result
@@ -0,0 +1,20 @@
+CREATE TABLE t1 (f1 INTEGER) ENGINE=MyISAM;
+CREATE TEMPORARY TABLE t2 (f1 INTEGER) ENGINE=MyISAM;
+CREATE TABLE t3 (f1 INTEGER) ENGINE=InnoDB;
+CREATE TEMPORARY TABLE t4 (f1 INTEGER) ENGINE=InnoDB;
+CREATE TABLE t5 (f1 INTEGER);
+SET AUTOCOMMIT=OFF;
+START TRANSACTION;
+DROP TABLE t1, t2, t3, t4;
+INSERT INTO t5 VALUES (1);
+COMMIT;
+SHOW CREATE TABLE t1;
+ERROR 42S02: Table 'test.t1' doesn't exist
+SHOW CREATE TABLE t2;
+ERROR 42S02: Table 'test.t2' doesn't exist
+SHOW CREATE TABLE t3;
+ERROR 42S02: Table 'test.t3' doesn't exist
+SHOW CREATE TABLE t4;
+ERROR 42S02: Table 'test.t4' doesn't exist
+CALL mtr.add_suppression("Slave SQL: Error 'Unknown table 'test.t2,test.t4'' on query\. Default database: 'test'\. Query: 'DROP TABLE t1, t2, t3, t4', Error_code: 1051");
+DROP TABLE t5;