Debian Codegraph @

mysql-test/suite/storage_engine/trx/select_lock_in_share_mode.result

raw
1 DROP TABLE IF EXISTS t1;
2 CREATE TABLE t1 (a <INT_COLUMN>, b <CHAR_COLUMN>) ENGINE=<STORAGE_ENGINE> <CUSTOM_TABLE_OPTIONS>;
3 INSERT INTO t1 (a,b) VALUES (1,'a'),(2,'b'),(3,'a');
4 connect con1,localhost,root,,;
5 BEGIN;
6 SELECT a,b FROM t1 WHERE b='a' LOCK IN SHARE MODE;
7 a b
8 1 a
9 3 a
10 connection default;
11 SET lock_wait_timeout = 1;
12 SELECT a,b FROM t1 WHERE b='a';
13 a b
14 1 a
15 3 a
16 SELECT a,b FROM t1 WHERE b='a' LOCK IN SHARE MODE;
17 a b
18 1 a
19 3 a
20 UPDATE t1 SET b='c' WHERE b='a';
21 ERROR HY000: Lock wait timeout exceeded; try restarting transaction
22 connection con1;
23 COMMIT;
24 SELECT a,b FROM t1;
25 a b
26 1 a
27 2 b
28 3 a
29 disconnect con1;
30 connection default;
31 UPDATE t1 SET b='c' WHERE b='a';
32 SELECT a,b FROM t1;
33 a b
34 1 c
35 2 b
36 3 c
37 DROP TABLE t1;