1** Setup **
2
3** Connecting con0 using root **
4** Connecting con1 using root **
5** Connection default **
6SET @global_low_priority_updates = @@GLOBAL.low_priority_updates;
7SET @session_low_priority_updates = @@SESSION.low_priority_updates;
8CREATE TABLE t1 (a varchar(100));
9create view v1 as select * from t1;
10'#--------------------FN_DYNVARS_160_01-------------------------#'
11** Connection con0 **
12SET SESSION low_priority_updates = ON;
13** Connection con1 **
14SET SESSION low_priority_updates = ON;
15** Connection default **
16SET SESSION low_priority_updates = ON;
17INSERT INTO t1 VALUES('1');
18INSERT INTO t1 VALUES('2');
19INSERT INTO t1 VALUES('3');
20INSERT INTO t1 VALUES('4');
21INSERT INTO t1 VALUES('5');
22INSERT INTO t1 VALUES('6');
23LOCK TABLE v1 WRITE;
24** Connection con1 **
25** Asynchronous Execution **
26UPDATE t1 SET a = CONCAT(a,"-updated");|
27** Connection con0 **
28** Asynchronous Execution **
29LOCK TABLE t1 READ;
30SELECT * FROM t1;
31UNLOCK TABLES;|
32** Connection default **
33UNLOCK TABLES;
34** Connection con0 **
35** Asynchronous Result **
36a
371
382
393
404
415
426
43Expected values of a without -updated;
44** Connection default **
45DELETE FROM t1;
46'#--------------------FN_DYNVARS_160_02-------------------------#'
47** Connection con0 **
48SET SESSION low_priority_updates = OFF;
49** Connection con1 **
50SET SESSION low_priority_updates = OFF;
51** Connection default**
52SET SESSION low_priority_updates = OFF;
53INSERT INTO t1 VALUES('1');
54INSERT INTO t1 VALUES('2');
55INSERT INTO t1 VALUES('3');
56INSERT INTO t1 VALUES('4');
57INSERT INTO t1 VALUES('5');
58INSERT INTO t1 VALUES('6');
59LOCK TABLE v1 WRITE;
60** Connection con1 **
61** Asynchronous Execution **
62UPDATE t1 SET a = CONCAT(a,"-updated");|
63** Connection con0 **
64** Asynchronous Execution **
65LOCK TABLE t1 READ;
66SELECT * FROM t1;
67UNLOCK TABLES;|
68** Connection default **
69UNLOCK TABLES;
70** Connection con0 **
71** Asynchronous Result **
72a
731-updated
742-updated
753-updated
764-updated
775-updated
786-updated
79Expected values of a with -updated;
80** Connection default**
81DELETE FROM t1;
82'#--------------------FN_DYNVARS_160_03-------------------------#'
83** Connecting con_int1 using root **
84** Connection con_int1 **
85SELECT @@SESSION.low_priority_updates;
86@@SESSION.low_priority_updates
870
881 / TRUE Expected
89SET SESSION low_priority_updates = FALSE;
90** Connecting con_int2 using root **
91** Connection con_int2 **
92SELECT @@SESSION.low_priority_updates;
93@@SESSION.low_priority_updates
940
951 / TRUE Expected
96SET SESSION low_priority_updates = TRUE;
97** Connection con_int1 **
98SELECT @@SESSION.low_priority_updates;
99@@SESSION.low_priority_updates
1000
1010 / FALSE Expected
102** Connection con_int2 **
103SELECT @@SESSION.low_priority_updates;
104@@SESSION.low_priority_updates
1051
1061 / TRUE Expected
107** Connection default  **
108Disconnecting Connections con_int1, con_int2
109** Connection default **
110Disconnecting Connections con0, con1
111drop view v1;
112DROP TABLE t1;
113SET @@GLOBAL.low_priority_updates = @global_low_priority_updates;
114SET @@SESSION.low_priority_updates = @session_low_priority_updates;
115