summaryrefslogtreecommitdiff
path: root/mysql-test/suite/galera_sr/t/galera_sr_table_contents.test
diff options
context:
space:
mode:
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.test49
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;