Debian Codegraph @

mysql-test/suite/storage_engine/trx/select_for_update.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' FOR UPDATE;
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 ERROR HY000: Lock wait timeout exceeded; try restarting transaction
18 UPDATE t1 SET b='c' WHERE b='a';
19 ERROR HY000: Lock wait timeout exceeded; try restarting transaction
20 connection con1;
21 COMMIT;
22 SELECT a,b FROM t1;
23 a b
24 1 a
25 2 b
26 3 a
27 disconnect con1;
28 connection default;
29 UPDATE t1 SET b='c' WHERE b='a';
30 SELECT a,b FROM t1;
31 a b
32 1 c
33 2 b
34 3 c
35 DROP TABLE t1;