Debian Codegraph @

mysql-test/suite/innodb/r/high_prio_trx_5.result

raw
1 CREATE TABLE t1 (c1 INT NOT NULL PRIMARY KEY, c2 INT NOT NULL, c3 INT NOT NULL) ENGINE=InnoDB;
2 INSERT INTO t1 VALUES (0, 0, 0);
3
4 # On connection 1
5 START TRANSACTION READ ONLY;
6 SELECT c1, c2 FROM t1 WHERE c1=0 LOCK IN SHARE MODE;
7 c1 c2
8 0 0
9
10 # On connection 2
11 START TRANSACTION;
12 UPDATE t1 SET c1=2 WHERE c1=0 AND c2=0;
13
14 # On connection 3
15 include/start_transaction_high_prio.inc
16 START TRANSACTION /* HIGH PRIORITY */;
17 SET @con2_id = <con2_id>;
18 SET DEBUG_SYNC='rec_lock_add_to_waitq SIGNAL signal1 WAIT_FOR waiting1';
19 UPDATE t1 SET c1=3 WHERE c1=0;;
20
21 # On connection 1
22 SET DEBUG_SYNC='now WAIT_FOR signal1';
23 SET DEBUG_SYNC='now SIGNAL waiting1';
24 COMMIT;
25
26 # On connection 3
27 COMMIT;
28
29 # On connection 2
30 COMMIT;
31 include/assert.inc ['There is a 3.0.0 in t1']
32 include/assert.inc ['There is no 0.0.0 in t1']
33 include/assert.inc ['There is no 2 in t1.c1']
34 DROP TABLE t1;