1
SET @session_start_value = @@session.sql_low_priority_updates;
2
SELECT @session_start_value;
5
SET @global_start_value = @@global.sql_low_priority_updates;
6
SELECT @global_start_value;
9
'#--------------------FN_DYNVARS_159_01------------------------#'
10
SET @@session.sql_low_priority_updates = 1;
11
SET @@session.sql_low_priority_updates = DEFAULT;
12
SELECT @@session.sql_low_priority_updates;
13
@@session.sql_low_priority_updates
15
SET @@global.sql_low_priority_updates = 1;
16
SET @@global.sql_low_priority_updates = DEFAULT;
17
ERROR 42000: Variable 'sql_low_priority_updates' doesn't have a default value
18
'Bug: DEFAULT value is only associated with session'
19
'#---------------------FN_DYNVARS_159_02-------------------------#'
20
SET sql_low_priority_updates = 1;
21
SELECT @@sql_low_priority_updates;
22
@@sql_low_priority_updates
24
SELECT session.sql_low_priority_updates;
25
ERROR 42S02: Unknown table 'session' in field list
26
SELECT local.sql_low_priority_updates;
27
ERROR 42S02: Unknown table 'local' in field list
28
SELECT global.sql_low_priority_updates;
29
ERROR 42S02: Unknown table 'global' in field list
30
SET session sql_low_priority_updates = 0;
31
SELECT @@session.sql_low_priority_updates;
32
@@session.sql_low_priority_updates
34
SET global sql_low_priority_updates = 0;
35
SELECT @@global.sql_low_priority_updates;
36
@@global.sql_low_priority_updates
38
'#--------------------FN_DYNVARS_159_03------------------------#'
39
SET @@session.sql_low_priority_updates = 0;
40
SELECT @@session.sql_low_priority_updates;
41
@@session.sql_low_priority_updates
43
SET @@session.sql_low_priority_updates = 1;
44
SELECT @@session.sql_low_priority_updates;
45
@@session.sql_low_priority_updates
47
SET @@global.sql_low_priority_updates = 0;
48
SELECT @@global.sql_low_priority_updates;
49
@@global.sql_low_priority_updates
51
SET @@global.sql_low_priority_updates = 1;
52
SELECT @@global.sql_low_priority_updates;
53
@@global.sql_low_priority_updates
55
'#--------------------FN_DYNVARS_159_04-------------------------#'
56
SET @@session.sql_low_priority_updates = -1;
57
ERROR 42000: Variable 'sql_low_priority_updates' can't be set to the value of '-1'
58
SET @@session.sql_low_priority_updates = 1.6;
59
ERROR 42000: Variable 'sql_low_priority_updates' can't be set to the value of '2'
60
SET @@session.sql_low_priority_updates = "T";
61
ERROR 42000: Variable 'sql_low_priority_updates' can't be set to the value of 'T'
62
SET @@session.sql_low_priority_updates = "Y";
63
ERROR 42000: Variable 'sql_low_priority_updates' can't be set to the value of 'Y'
64
SET @@session.sql_low_priority_updates = TR�E;
65
ERROR 42000: Variable 'sql_low_priority_updates' can't be set to the value of 'TRÜE'
66
SET @@session.sql_low_priority_updates = �N;
67
ERROR 42000: Variable 'sql_low_priority_updates' can't be set to the value of 'ÕN'
68
SET @@session.sql_low_priority_updates = OF;
69
SELECT @@session.sql_low_priority_updates;
70
@@session.sql_low_priority_updates
72
'Bug# 34828: OF is taken as OFF and a value of 0 is set.'
73
SET @@session.sql_low_priority_updates = �FF;
74
ERROR 42000: Variable 'sql_low_priority_updates' can't be set to the value of 'ÓFF'
75
SET @@global.sql_low_priority_updates = -1;
76
ERROR 42000: Variable 'sql_low_priority_updates' can't be set to the value of '-1'
77
SET @@global.sql_low_priority_updates = 2;
78
ERROR 42000: Variable 'sql_low_priority_updates' can't be set to the value of '2'
79
SET @@global.sql_low_priority_updates = "T";
80
ERROR 42000: Variable 'sql_low_priority_updates' can't be set to the value of 'T'
81
SET @@global.sql_low_priority_updates = "Y";
82
ERROR 42000: Variable 'sql_low_priority_updates' can't be set to the value of 'Y'
83
SET @@global.sql_low_priority_updates = TR�E;
84
ERROR 42000: Variable 'sql_low_priority_updates' can't be set to the value of 'TRÜE'
85
SET @@global.sql_low_priority_updates = �N;
86
ERROR 42000: Variable 'sql_low_priority_updates' can't be set to the value of 'ÕN'
87
SET @@global.sql_low_priority_updates = OF;
88
SELECT @@global.sql_low_priority_updates;
89
@@global.sql_low_priority_updates
91
'Bug# 34828: OF is taken as OFF and a value of 0 is set.'
92
SET @@global.sql_low_priority_updates = �FF;
93
ERROR 42000: Variable 'sql_low_priority_updates' can't be set to the value of 'ÓFF'
94
'#-------------------FN_DYNVARS_159_05----------------------------#'
95
SET @@global.sql_low_priority_updates = 0;
96
SET @@session.sql_low_priority_updates = 1;
97
SELECT @@global.sql_low_priority_updates AS res_is_0;
100
SET @@global.sql_low_priority_updates = 0;
101
SELECT @@session.sql_low_priority_updates AS res_is_1;
104
'#----------------------FN_DYNVARS_159_06------------------------#'
105
SELECT @@global.sql_low_priority_updates = VARIABLE_VALUE
106
FROM INFORMATION_SCHEMA.GLOBAL_VARIABLES
107
WHERE VARIABLE_NAME='sql_low_priority_updates';
108
@@global.sql_low_priority_updates = VARIABLE_VALUE
110
SELECT @@global.sql_low_priority_updates;
111
@@global.sql_low_priority_updates
113
SELECT VARIABLE_VALUE
114
FROM INFORMATION_SCHEMA.GLOBAL_VARIABLES
115
WHERE VARIABLE_NAME='sql_low_priority_updates';
118
'#----------------------FN_DYNVARS_159_07------------------------#'
119
SELECT @@session.sql_low_priority_updates = VARIABLE_VALUE
120
FROM INFORMATION_SCHEMA.SESSION_VARIABLES
121
WHERE VARIABLE_NAME='sql_low_priority_updates';
122
@@session.sql_low_priority_updates = VARIABLE_VALUE
124
SELECT @@session.sql_low_priority_updates;
125
@@session.sql_low_priority_updates
127
SELECT VARIABLE_VALUE
128
FROM INFORMATION_SCHEMA.SESSION_VARIABLES
129
WHERE VARIABLE_NAME='sql_low_priority_updates';
132
'#---------------------FN_DYNVARS_159_08-------------------------#'
133
SET @@session.sql_low_priority_updates = OFF;
134
SELECT @@session.sql_low_priority_updates;
135
@@session.sql_low_priority_updates
137
SET @@session.sql_low_priority_updates = ON;
138
SELECT @@session.sql_low_priority_updates;
139
@@session.sql_low_priority_updates
141
SET @@global.sql_low_priority_updates = OFF;
142
SELECT @@global.sql_low_priority_updates;
143
@@global.sql_low_priority_updates
145
SET @@global.sql_low_priority_updates = ON;
146
SELECT @@global.sql_low_priority_updates;
147
@@global.sql_low_priority_updates
149
'#---------------------FN_DYNVARS_159_09----------------------#'
150
SET @@session.sql_low_priority_updates = TRUE;
151
SELECT @@session.sql_low_priority_updates;
152
@@session.sql_low_priority_updates
154
SET @@session.sql_low_priority_updates = FALSE;
155
SELECT @@session.sql_low_priority_updates;
156
@@session.sql_low_priority_updates
158
SET @@global.sql_low_priority_updates = TRUE;
159
SELECT @@global.sql_low_priority_updates;
160
@@global.sql_low_priority_updates
162
SET @@global.sql_low_priority_updates = FALSE;
163
SELECT @@global.sql_low_priority_updates;
164
@@global.sql_low_priority_updates
166
SET @@session.sql_low_priority_updates = @session_start_value;
167
SELECT @@session.sql_low_priority_updates;
168
@@session.sql_low_priority_updates
170
SET @@global.sql_low_priority_updates = @global_start_value;
171
SELECT @@global.sql_low_priority_updates;
172
@@global.sql_low_priority_updates