diff options
Diffstat (limited to 'storage/rocksdb/mysql-test/rocksdb/r/select_for_update.result')
-rw-r--r-- | storage/rocksdb/mysql-test/rocksdb/r/select_for_update.result | 35 |
1 files changed, 35 insertions, 0 deletions
diff --git a/storage/rocksdb/mysql-test/rocksdb/r/select_for_update.result b/storage/rocksdb/mysql-test/rocksdb/r/select_for_update.result new file mode 100644 index 00000000000..2890941a1b9 --- /dev/null +++ b/storage/rocksdb/mysql-test/rocksdb/r/select_for_update.result @@ -0,0 +1,35 @@ +DROP TABLE IF EXISTS t1; +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'); +connect con1,localhost,root,,; +BEGIN; +SELECT a,b FROM t1 WHERE b='a' FOR UPDATE; +a b +1 a +3 a +connection default; +SET lock_wait_timeout = 1; +SELECT a,b FROM t1 WHERE b='a'; +a b +1 a +3 a +SELECT a,b FROM t1 WHERE b='a' LOCK IN SHARE MODE; +ERROR HY000: Lock wait timeout exceeded; try restarting transaction +UPDATE t1 SET b='c' WHERE b='a'; +ERROR HY000: Lock wait timeout exceeded; try restarting transaction +connection con1; +COMMIT; +SELECT a,b FROM t1; +a b +1 a +2 b +3 a +disconnect con1; +connection default; +UPDATE t1 SET b='c' WHERE b='a'; +SELECT a,b FROM t1; +a b +1 c +2 b +3 c +DROP TABLE t1; |