3
** Connecting con0 using root **
4
** Connecting con1 using 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
'#--------------------FN_DYNVARS_160_01-------------------------#'
11
SET SESSION low_priority_updates = ON;
13
SET SESSION low_priority_updates = ON;
14
** Connection default **
15
SET SESSION low_priority_updates = ON;
16
INSERT INTO t1 VALUES('1');
17
INSERT INTO t1 VALUES('2');
18
INSERT INTO t1 VALUES('3');
19
INSERT INTO t1 VALUES('4');
20
INSERT INTO t1 VALUES('5');
21
INSERT INTO t1 VALUES('6');
24
** Asynchronous Execution **
25
UPDATE t1 SET a = CONCAT(a,"-updated");|
27
** Asynchronous Execution **
31
** Connection default **
35
** Asynchronous Result **
43
Expected values of a without -updated;
44
** Connection default **
46
'#--------------------FN_DYNVARS_160_02-------------------------#'
48
SET SESSION low_priority_updates = OFF;
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');
61
** Asynchronous Execution **
62
UPDATE t1 SET a = CONCAT(a,"-updated");|
64
** Asynchronous Execution **
68
** Connection default **
72
** Asynchronous Result **
80
Expected values of a with -updated;
81
** Connection default**
83
'#--------------------FN_DYNVARS_160_03-------------------------#'
84
** Connecting con_int1 using root **
85
** Connection con_int1 **
86
SELECT @@SESSION.low_priority_updates;
87
@@SESSION.low_priority_updates
90
SET SESSION low_priority_updates = FALSE;
91
** Connecting con_int2 using root **
92
** Connection con_int2 **
93
SELECT @@SESSION.low_priority_updates;
94
@@SESSION.low_priority_updates
97
SET SESSION low_priority_updates = TRUE;
98
** Connection con_int1 **
99
SELECT @@SESSION.low_priority_updates;
100
@@SESSION.low_priority_updates
103
** Connection con_int2 **
104
SELECT @@SESSION.low_priority_updates;
105
@@SESSION.low_priority_updates
108
** Connection default **
109
Disconnecting Connections con_int1, con_int2
110
** Connection default **
111
Disconnecting Connections con0, con1
113
SET @@GLOBAL.low_priority_updates = @global_low_priority_updates;
114
SET @@SESSION.low_priority_updates = @session_low_priority_updates;