Debian Codegraph @

mysql-test/suite/storage_engine/insert_low_prio.result

raw
1 DROP TABLE IF EXISTS t1;
2 SET @low_prio_updates = @@global.low_priority_updates;
3 SET @concur_insert = @@global.concurrent_insert;
4 SET GLOBAL concurrent_insert = NEVER;
5 CREATE TABLE t1 (a <INT_COLUMN>, b <CHAR_COLUMN>) ENGINE=<STORAGE_ENGINE> <CUSTOM_TABLE_OPTIONS>;
6 INSERT INTO t1 (a,b) VALUES (1,'f'),(2,'b');
7 connect con0,localhost,root,,;
8 SET lock_wait_timeout = 4;
9 connect con1,localhost,root,,;
10 SET lock_wait_timeout = 4;
11 connect con2,localhost,root,,;
12 SET lock_wait_timeout = 4;
13 connection con1;
14 SELECT SLEEP(1) FROM t1;
15 connection con0;
16 INSERT LOW_PRIORITY INTO t1 (a,b) VALUES (3,'z');
17 connection con2;
18 # Should return only 2 rows
19 SELECT SLEEP(1) FROM t1;
20 SLEEP(1)
21 0
22 0
23 connection con1;
24 SLEEP(1)
25 0
26 0
27 connection con0;
28 SELECT a,b FROM t1;
29 a b
30 1 f
31 2 b
32 3 z
33 disconnect con0;
34 disconnect con1;
35 disconnect con2;
36 connection default;
37 SET GLOBAL low_priority_updates = @low_prio_updates;
38 SET GLOBAL concurrent_insert = @concur_insert;
39 DROP TABLE t1;