diff options
Diffstat (limited to 'mysql-test/suite/galera_sr/t/galera_sr_table_contents.test')
-rw-r--r-- | mysql-test/suite/galera_sr/t/galera_sr_table_contents.test | 49 |
1 files changed, 0 insertions, 49 deletions
diff --git a/mysql-test/suite/galera_sr/t/galera_sr_table_contents.test b/mysql-test/suite/galera_sr/t/galera_sr_table_contents.test deleted file mode 100644 index 92d29fe4ca2..00000000000 --- a/mysql-test/suite/galera_sr/t/galera_sr_table_contents.test +++ /dev/null @@ -1,49 +0,0 @@ -# -# This test dumps the contents of the SR table under various circumstances -# - ---source include/galera_cluster.inc - -CREATE TABLE t1 (f1 INTEGER PRIMARY KEY) ENGINE=InnoDB; -INSERT INTO t1 VALUES (1),(2),(3); - -CREATE TABLE t2 (f1 INTEGER PRIMARY KEY) ENGINE=InnoDB; -INSERT INTO t2 VALUES (1),(2),(3); - -SET SESSION wsrep_trx_fragment_size = 1; -SET AUTOCOMMIT=OFF; -START TRANSACTION; - ---echo ---echo Start of Simple Insert -INSERT INTO t1 VALUES (4); ---source suite/galera/include/galera_dump_sr_table.inc ---echo End of Simple Insert ---echo -ROLLBACK; - ---echo Start of Multi-row Update -UPDATE t1 SET f1 = f1 + 10; ---source suite/galera/include/galera_dump_sr_table.inc ---echo End of Multi-row Update ---echo -ROLLBACK; - ---echo Start of Multi-table Update -UPDATE t1, t2 SET t1.f1 = t1.f1 + 100, t2.f1 = t2.f1 + 100; ---source suite/galera/include/galera_dump_sr_table.inc ---echo End of Multi-table Update ---echo -ROLLBACK; - ---echo Start of Savepoint -INSERT INTO t1 VALUES (1000); -SAVEPOINT X; -INSERT INTO t1 VALUES (2000); -ROLLBACK TO SAVEPOINT X; ---source suite/galera/include/galera_dump_sr_table.inc ---echo End of Savepoint ---echo -ROLLBACK; - -DROP TABLE t1, t2; |