Debian Codegraph @

mysql-test/suite/storage_engine/delete_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 (1,'f'),(2,'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 SLEEP(1) FROM t1;
9 connection default;
10 DELETE FROM t1;
11 connect con2,localhost,root,,;
12 SET lock_wait_timeout = 3;
13 SELECT SLEEP(1) FROM t1;
14 SLEEP(1)
15 connection con1;
16 SLEEP(1)
17 0
18 0
19 connection default;
20 SELECT a,b FROM t1;
21 a b
22 INSERT INTO t1 (a,b) VALUES (1,'a'),(2,'b');
23 connection con1;
24 SELECT SLEEP(1) FROM t1;
25 connection default;
26 DELETE LOW_PRIORITY FROM t1;
27 connection con2;
28 SELECT SLEEP(1) FROM t1;
29 SLEEP(1)
30 0
31 0
32 connection con1;
33 SLEEP(1)
34 0
35 0
36 connection default;
37 SELECT a,b FROM t1;
38 a b
39 INSERT INTO t1 (a,b) VALUES (1,'a'),(2,'b');
40 SET LOW_PRIORITY_UPDATES = 1;
41 connection con1;
42 SELECT SLEEP(1) FROM t1;
43 connection default;
44 DELETE FROM t1;
45 connection con2;
46 SELECT SLEEP(1) FROM t1;
47 SLEEP(1)
48 0
49 0
50 connection con1;
51 SLEEP(1)
52 0
53 0
54 connection default;
55 SELECT a,b FROM t1;
56 a b
57 disconnect con1;
58 disconnect con2;
59 DROP TABLE t1;