1SET @session_start_value = @@session.sql_low_priority_updates;
2SELECT @session_start_value;
3@session_start_value
40
5SET @global_start_value = @@global.sql_low_priority_updates;
6SELECT @global_start_value;
7@global_start_value
80
9'#--------------------FN_DYNVARS_159_01------------------------#'
10SET @@session.sql_low_priority_updates = 1;
11SET @@session.sql_low_priority_updates = DEFAULT;
12SELECT @@session.sql_low_priority_updates;
13@@session.sql_low_priority_updates
140
15SET @@global.sql_low_priority_updates = 1;
16SET @@global.sql_low_priority_updates = DEFAULT;
17'#---------------------FN_DYNVARS_159_02-------------------------#'
18SET sql_low_priority_updates = 1;
19SELECT @@sql_low_priority_updates;
20@@sql_low_priority_updates
211
22SELECT session.sql_low_priority_updates;
23ERROR 42S02: Unknown table 'session' in field list
24SELECT local.sql_low_priority_updates;
25ERROR 42S02: Unknown table 'local' in field list
26SELECT global.sql_low_priority_updates;
27ERROR 42S02: Unknown table 'global' in field list
28SET session sql_low_priority_updates = 0;
29SELECT @@session.sql_low_priority_updates;
30@@session.sql_low_priority_updates
310
32SET global sql_low_priority_updates = 0;
33SELECT @@global.sql_low_priority_updates;
34@@global.sql_low_priority_updates
350
36'#--------------------FN_DYNVARS_159_03------------------------#'
37SET @@session.sql_low_priority_updates = 0;
38SELECT @@session.sql_low_priority_updates;
39@@session.sql_low_priority_updates
400
41SET @@session.sql_low_priority_updates = 1;
42SELECT @@session.sql_low_priority_updates;
43@@session.sql_low_priority_updates
441
45SET @@global.sql_low_priority_updates = 0;
46SELECT @@global.sql_low_priority_updates;
47@@global.sql_low_priority_updates
480
49SET @@global.sql_low_priority_updates = 1;
50SELECT @@global.sql_low_priority_updates;
51@@global.sql_low_priority_updates
521
53'#--------------------FN_DYNVARS_159_04-------------------------#'
54SET @@session.sql_low_priority_updates = -1;
55ERROR 42000: Variable 'sql_low_priority_updates' can't be set to the value of '-1'
56SET @@session.sql_low_priority_updates = 1.6;
57ERROR 42000: Incorrect argument type to variable 'sql_low_priority_updates'
58SET @@session.sql_low_priority_updates = "T";
59ERROR 42000: Variable 'sql_low_priority_updates' can't be set to the value of 'T'
60SET @@session.sql_low_priority_updates = "Y";
61ERROR 42000: Variable 'sql_low_priority_updates' can't be set to the value of 'Y'
62SET @@session.sql_low_priority_updates = TR�E;
63ERROR 42000: Variable 'sql_low_priority_updates' can't be set to the value of 'TR�E'
64SET @@session.sql_low_priority_updates = �N;
65ERROR 42000: Variable 'sql_low_priority_updates' can't be set to the value of '�N'
66SET @@session.sql_low_priority_updates = OF;
67ERROR 42000: Variable 'sql_low_priority_updates' can't be set to the value of 'OF'
68SET @@session.sql_low_priority_updates = �FF;
69ERROR 42000: Variable 'sql_low_priority_updates' can't be set to the value of '�FF'
70SET @@global.sql_low_priority_updates = -1;
71ERROR 42000: Variable 'sql_low_priority_updates' can't be set to the value of '-1'
72SET @@global.sql_low_priority_updates = 2;
73ERROR 42000: Variable 'sql_low_priority_updates' can't be set to the value of '2'
74SET @@global.sql_low_priority_updates = "T";
75ERROR 42000: Variable 'sql_low_priority_updates' can't be set to the value of 'T'
76SET @@global.sql_low_priority_updates = "Y";
77ERROR 42000: Variable 'sql_low_priority_updates' can't be set to the value of 'Y'
78SET @@global.sql_low_priority_updates = TR�E;
79ERROR 42000: Variable 'sql_low_priority_updates' can't be set to the value of 'TR�E'
80SET @@global.sql_low_priority_updates = �N;
81ERROR 42000: Variable 'sql_low_priority_updates' can't be set to the value of '�N'
82SET @@global.sql_low_priority_updates = OF;
83ERROR 42000: Variable 'sql_low_priority_updates' can't be set to the value of 'OF'
84SET @@global.sql_low_priority_updates = �FF;
85ERROR 42000: Variable 'sql_low_priority_updates' can't be set to the value of '�FF'
86'#-------------------FN_DYNVARS_159_05----------------------------#'
87SET @@global.sql_low_priority_updates = 0;
88SET @@session.sql_low_priority_updates = 1;
89SELECT @@global.sql_low_priority_updates AS res_is_0;
90res_is_0
910
92SET @@global.sql_low_priority_updates = 0;
93SELECT @@session.sql_low_priority_updates AS res_is_1;
94res_is_1
951
96'#----------------------FN_DYNVARS_159_06------------------------#'
97SELECT IF(@@global.sql_low_priority_updates, "ON", "OFF") = VARIABLE_VALUE
98FROM INFORMATION_SCHEMA.GLOBAL_VARIABLES
99WHERE VARIABLE_NAME='sql_low_priority_updates';
100IF(@@global.sql_low_priority_updates, "ON", "OFF") = VARIABLE_VALUE
1011
102SELECT @@global.sql_low_priority_updates;
103@@global.sql_low_priority_updates
1040
105SELECT VARIABLE_VALUE
106FROM INFORMATION_SCHEMA.GLOBAL_VARIABLES
107WHERE VARIABLE_NAME='sql_low_priority_updates';
108VARIABLE_VALUE
109OFF
110'#----------------------FN_DYNVARS_159_07------------------------#'
111SELECT IF(@@session.sql_low_priority_updates, "ON", "OFF") = VARIABLE_VALUE
112FROM INFORMATION_SCHEMA.SESSION_VARIABLES
113WHERE VARIABLE_NAME='sql_low_priority_updates';
114IF(@@session.sql_low_priority_updates, "ON", "OFF") = VARIABLE_VALUE
1151
116SELECT @@session.sql_low_priority_updates;
117@@session.sql_low_priority_updates
1181
119SELECT VARIABLE_VALUE
120FROM INFORMATION_SCHEMA.SESSION_VARIABLES
121WHERE VARIABLE_NAME='sql_low_priority_updates';
122VARIABLE_VALUE
123ON
124'#---------------------FN_DYNVARS_159_08-------------------------#'
125SET @@session.sql_low_priority_updates = OFF;
126SELECT @@session.sql_low_priority_updates;
127@@session.sql_low_priority_updates
1280
129SET @@session.sql_low_priority_updates = ON;
130SELECT @@session.sql_low_priority_updates;
131@@session.sql_low_priority_updates
1321
133SET @@global.sql_low_priority_updates = OFF;
134SELECT @@global.sql_low_priority_updates;
135@@global.sql_low_priority_updates
1360
137SET @@global.sql_low_priority_updates = ON;
138SELECT @@global.sql_low_priority_updates;
139@@global.sql_low_priority_updates
1401
141'#---------------------FN_DYNVARS_159_09----------------------#'
142SET @@session.sql_low_priority_updates = TRUE;
143SELECT @@session.sql_low_priority_updates;
144@@session.sql_low_priority_updates
1451
146SET @@session.sql_low_priority_updates = FALSE;
147SELECT @@session.sql_low_priority_updates;
148@@session.sql_low_priority_updates
1490
150SET @@global.sql_low_priority_updates = TRUE;
151SELECT @@global.sql_low_priority_updates;
152@@global.sql_low_priority_updates
1531
154SET @@global.sql_low_priority_updates = FALSE;
155SELECT @@global.sql_low_priority_updates;
156@@global.sql_low_priority_updates
1570
158SET @@session.sql_low_priority_updates = @session_start_value;
159SELECT @@session.sql_low_priority_updates;
160@@session.sql_low_priority_updates
1610
162SET @@global.sql_low_priority_updates = @global_start_value;
163SELECT @@global.sql_low_priority_updates;
164@@global.sql_low_priority_updates
1650
166