Debian Codegraph @

mysql-test/suite/sys_vars/r/sql_low_priority_updates_func.result

raw
1 ** Setup **
2
3 connect con0,localhost,root,,;
4 connect con1,localhost,root,,;
5 connection default;
6 SET @global_low_priority_updates = @@GLOBAL.low_priority_updates;
7 SET @session_low_priority_updates = @@SESSION.low_priority_updates;
8 CREATE TABLE t1 (a varchar(100));
9 create view v1 as select * from t1;
10 '#--------------------FN_DYNVARS_160_01-------------------------#'
11 connection con0;
12 SET SESSION low_priority_updates = ON;
13 connection con1;
14 SET SESSION low_priority_updates = ON;
15 connection default;
16 SET SESSION low_priority_updates = ON;
17 INSERT INTO t1 VALUES('1');
18 INSERT INTO t1 VALUES('2');
19 INSERT INTO t1 VALUES('3');
20 INSERT INTO t1 VALUES('4');
21 INSERT INTO t1 VALUES('5');
22 INSERT INTO t1 VALUES('6');
23 LOCK TABLE v1 WRITE CONCURRENT;
24 connection con1;
25 ** Asynchronous Execution **
26 UPDATE t1 SET a = CONCAT(a,"-updated");|
27 connection con0;
28 ** Asynchronous Execution **
29 LOCK TABLE t1 READ;
30 SELECT * FROM t1;
31 UNLOCK TABLES;|
32 connection default;
33 UNLOCK TABLES;
34 connection con0;
35 ** Asynchronous Result **
36 a
37 1
38 2
39 3
40 4
41 5
42 6
43 Expected values of a without -updated;
44 connection default;
45 DELETE FROM t1;
46 '#--------------------FN_DYNVARS_160_02-------------------------#'
47 connection con0;
48 SET SESSION low_priority_updates = OFF;
49 connection con1;
50 SET SESSION low_priority_updates = OFF;
51 connection default;
52 SET SESSION low_priority_updates = OFF;
53 INSERT INTO t1 VALUES('1');
54 INSERT INTO t1 VALUES('2');
55 INSERT INTO t1 VALUES('3');
56 INSERT INTO t1 VALUES('4');
57 INSERT INTO t1 VALUES('5');
58 INSERT INTO t1 VALUES('6');
59 LOCK TABLE v1 READ;
60 connection con1;
61 ** Asynchronous Execution **
62 UPDATE t1 SET a = CONCAT(a,"-updated");|
63 connection con0;
64 ** Asynchronous Execution **
65 LOCK TABLE t1 READ;
66 SELECT * FROM t1;
67 UNLOCK TABLES;|
68 connection default;
69 UNLOCK TABLES;
70 connection con0;
71 ** Asynchronous Result **
72 a
73 1-updated
74 2-updated
75 3-updated
76 4-updated
77 5-updated
78 6-updated
79 Expected values of a with -updated;
80 connection default;
81 DELETE FROM t1;
82 '#--------------------FN_DYNVARS_160_03-------------------------#'
83 connect con_int1,localhost,root,,;
84 connection con_int1;
85 SELECT @@SESSION.low_priority_updates;
86 @@SESSION.low_priority_updates
87 0
88 1 / TRUE Expected
89 SET SESSION low_priority_updates = FALSE;
90 connect con_int2,localhost,root,,;
91 connection con_int2;
92 SELECT @@SESSION.low_priority_updates;
93 @@SESSION.low_priority_updates
94 0
95 1 / TRUE Expected
96 SET SESSION low_priority_updates = TRUE;
97 connection con_int1;
98 SELECT @@SESSION.low_priority_updates;
99 @@SESSION.low_priority_updates
100 0
101 0 / FALSE Expected
102 connection con_int2;
103 SELECT @@SESSION.low_priority_updates;
104 @@SESSION.low_priority_updates
105 1
106 1 / TRUE Expected
107 connection default;
108 disconnect con_int1;
109 disconnect con_int2;
110 connection default;
111 disconnect con0;
112 disconnect con1;
113 drop view v1;
114 DROP TABLE t1;
115 SET @@GLOBAL.low_priority_updates = @global_low_priority_updates;
116 SET @@SESSION.low_priority_updates = @session_low_priority_updates;