diff options
Diffstat (limited to 'storage/rocksdb/mysql-test/rocksdb/t/rollback_savepoint.test')
-rw-r--r-- | storage/rocksdb/mysql-test/rocksdb/t/rollback_savepoint.test | 31 |
1 files changed, 31 insertions, 0 deletions
diff --git a/storage/rocksdb/mysql-test/rocksdb/t/rollback_savepoint.test b/storage/rocksdb/mysql-test/rocksdb/t/rollback_savepoint.test new file mode 100644 index 00000000000..8543ce81de4 --- /dev/null +++ b/storage/rocksdb/mysql-test/rocksdb/t/rollback_savepoint.test @@ -0,0 +1,31 @@ +--disable_warnings +DROP TABLE IF EXISTS t1, t2; +--enable_warnings + +CREATE TABLE t1 (a INT, b CHAR(8), pk INT AUTO_INCREMENT PRIMARY KEY) ENGINE=rocksdb; +INSERT INTO t1 (a,b) VALUES (1,'a'),(2,'b'),(3,'a'); +CREATE TABLE t2 LIKE t1; +INSERT INTO t2 SELECT * FROM t1; + +--connect (con1,localhost,root,,) +--connect (con2,localhost,root,,) + +--connection con1 +START TRANSACTION WITH CONSISTENT SNAPSHOT; +SAVEPOINT a; +SELECT * FROM t1 ORDER BY pk; +ROLLBACK TO SAVEPOINT a; +SAVEPOINT a; +SELECT * FROM t2 ORDER BY pk; +ROLLBACK TO SAVEPOINT a; + +# should not be blocked +--connection con2 +ALTER TABLE t1 RENAME TO t3; + +--connection default +DROP TABLE t2, t3; + +--disconnect con1 +--disconnect con2 + |