Debian Codegraph @

mysql-test/suite/storage_engine/update_low_prio.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 (11,'foobar'),(12,'b');
4 SET LOW_PRIORITY_UPDATES = 0;
5 SET lock_wait_timeout = 4;
6 connect con1,localhost,root,,;
7 SET lock_wait_timeout = 2;
8 SELECT a+SLEEP(1) FROM t1;
9 connection default;
10 UPDATE t1 SET a=a+10;
11 connect con2,localhost,root,,;
12 SET lock_wait_timeout = 3;
13 SELECT a+SLEEP(1) FROM t1;
14 a+SLEEP(1)
15 21
16 22
17 connection con1;
18 a+SLEEP(1)
19 11
20 12
21 connection default;
22 SELECT a,b FROM t1;
23 a b
24 21 foobar
25 22 b
26 connection con1;
27 SELECT a+SLEEP(1) FROM t1;
28 connection default;
29 UPDATE LOW_PRIORITY t1 SET a=a+20;
30 connection con2;
31 SELECT a+SLEEP(1) FROM t1;
32 a+SLEEP(1)
33 21
34 22
35 connection con1;
36 a+SLEEP(1)
37 21
38 22
39 connection default;
40 SELECT a,b FROM t1;
41 a b
42 41 foobar
43 42 b
44 SET LOW_PRIORITY_UPDATES = 1;
45 connection con1;
46 SELECT a+SLEEP(1) FROM t1;
47 connection default;
48 UPDATE t1 SET a=a+30;
49 connection con2;
50 SELECT a+SLEEP(1) FROM t1;
51 a+SLEEP(1)
52 41
53 42
54 connection con1;
55 a+SLEEP(1)
56 41
57 42
58 connection default;
59 SELECT a,b FROM t1;
60 a b
61 71 foobar
62 72 b
63 disconnect con1;
64 disconnect con2;
65 connection default;
66 DROP TABLE t1;