1
SET @start_global_value = @@global.low_priority_updates;
2
SELECT @start_global_value;
5
SET @start_session_value = @@session.low_priority_updates;
6
SELECT @start_session_value;
9
'#--------------------FN_DYNVARS_069_01-------------------------#'
10
SET @@global.low_priority_updates = ON;
11
SET @@global.low_priority_updates = DEFAULT;
12
SELECT @@global.low_priority_updates;
13
@@global.low_priority_updates
15
SET @@session.low_priority_updates = ON;
16
SET @@session.low_priority_updates = DEFAULT;
17
SELECT @@session.low_priority_updates;
18
@@session.low_priority_updates
20
'#--------------------FN_DYNVARS_069_02-------------------------#'
21
SET @@global.low_priority_updates = DEFAULT;
22
SELECT @@global.low_priority_updates = 'FALSE';
23
@@global.low_priority_updates = 'FALSE'
26
Warning 1292 Truncated incorrect DOUBLE value: 'FALSE'
27
SET @@session.low_priority_updates = DEFAULT;
28
SELECT @@session.low_priority_updates = 'FALSE';
29
@@session.low_priority_updates = 'FALSE'
32
Warning 1292 Truncated incorrect DOUBLE value: 'FALSE'
33
'#--------------------FN_DYNVARS_069_03-------------------------#'
34
SET @@global.low_priority_updates = ON;
35
SELECT @@global.low_priority_updates;
36
@@global.low_priority_updates
38
SET @@global.low_priority_updates = OFF;
39
SELECT @@global.low_priority_updates;
40
@@global.low_priority_updates
42
SET @@global.low_priority_updates = 0;
43
SELECT @@global.low_priority_updates;
44
@@global.low_priority_updates
46
SET @@global.low_priority_updates = 1;
47
SELECT @@global.low_priority_updates;
48
@@global.low_priority_updates
50
SET @@global.low_priority_updates = TRUE;
51
SELECT @@global.low_priority_updates;
52
@@global.low_priority_updates
54
SET @@global.low_priority_updates = FALSE;
55
SELECT @@global.low_priority_updates;
56
@@global.low_priority_updates
58
'#--------------------FN_DYNVARS_069_04-------------------------#'
59
SET @@session.low_priority_updates = ON;
60
SELECT @@session.low_priority_updates;
61
@@session.low_priority_updates
63
SET @@session.low_priority_updates = OFF;
64
SELECT @@session.low_priority_updates;
65
@@session.low_priority_updates
67
SET @@session.low_priority_updates = 0;
68
SELECT @@session.low_priority_updates;
69
@@session.low_priority_updates
71
SET @@session.low_priority_updates = 1;
72
SELECT @@session.low_priority_updates;
73
@@session.low_priority_updates
75
SET @@session.low_priority_updates = TRUE;
76
SELECT @@session.low_priority_updates;
77
@@session.low_priority_updates
79
SET @@session.low_priority_updates = FALSE;
80
SELECT @@session.low_priority_updates;
81
@@session.low_priority_updates
83
'#------------------FN_DYNVARS_069_05-----------------------#'
84
SET @@global.low_priority_updates = 'ONN';
85
ERROR 42000: Variable 'low_priority_updates' can't be set to the value of 'ONN'
86
SET @@global.low_priority_updates = "OFFF";
87
ERROR 42000: Variable 'low_priority_updates' can't be set to the value of 'OFFF'
88
SET @@global.low_priority_updates = TTRUE;
89
ERROR 42000: Variable 'low_priority_updates' can't be set to the value of 'TTRUE'
90
SET @@global.low_priority_updates = FELSE;
91
ERROR 42000: Variable 'low_priority_updates' can't be set to the value of 'FELSE'
92
SET @@global.low_priority_updates = -1024;
93
ERROR 42000: Variable 'low_priority_updates' can't be set to the value of '-1024'
94
SET @@global.low_priority_updates = 65536;
95
ERROR 42000: Variable 'low_priority_updates' can't be set to the value of '65536'
96
SET @@global.low_priority_updates = 65530.34;
97
ERROR 42000: Variable 'low_priority_updates' can't be set to the value of '65530'
98
SET @@global.low_priority_updates = test;
99
ERROR 42000: Variable 'low_priority_updates' can't be set to the value of 'test'
100
SET @@session.low_priority_updates = ONN;
101
ERROR 42000: Variable 'low_priority_updates' can't be set to the value of 'ONN'
102
SET @@session.low_priority_updates = ONF;
103
ERROR 42000: Variable 'low_priority_updates' can't be set to the value of 'ONF'
104
SET @@session.low_priority_updates = OF;
105
SELECT @@session.low_priority_updates;
106
@@session.low_priority_updates
108
'Bug# 34828: OF is also working as OFF and no error is coming';
109
SET @@session.low_priority_updates = 'OFN';
110
ERROR 42000: Variable 'low_priority_updates' can't be set to the value of 'OFN'
111
SET @@session.low_priority_updates = -2;
112
ERROR 42000: Variable 'low_priority_updates' can't be set to the value of '-2'
113
SET @@session.low_priority_updates = 65530.34.;
114
ERROR 42000: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '.' at line 1
115
SET @@session.low_priority_updates = 65550;
116
ERROR 42000: Variable 'low_priority_updates' can't be set to the value of '65550'
117
'Bug # 34837: Errors are not coming on assigning invalid values to variable';
118
SET @@session.low_priority_updates = test;
119
ERROR 42000: Variable 'low_priority_updates' can't be set to the value of 'test'
120
'#------------------FN_DYNVARS_069_06-----------------------#'
121
SELECT @@global.low_priority_updates = VARIABLE_VALUE
122
FROM INFORMATION_SCHEMA.GLOBAL_VARIABLES
123
WHERE VARIABLE_NAME='low_priority_updates';
124
@@global.low_priority_updates = VARIABLE_VALUE
126
'#------------------FN_DYNVARS_069_07-----------------------#'
127
SELECT @@session.low_priority_updates = VARIABLE_VALUE
128
FROM INFORMATION_SCHEMA.SESSION_VARIABLES
129
WHERE VARIABLE_NAME='low_priority_updates';
130
@@session.low_priority_updates = VARIABLE_VALUE
132
'#---------------------FN_DYNVARS_069_08----------------------#'
133
SET @@low_priority_updates = FALSE;
134
SET @@global.low_priority_updates = TRUE;
135
SELECT @@low_priority_updates = @@global.low_priority_updates;
136
@@low_priority_updates = @@global.low_priority_updates
138
'#---------------------FN_DYNVARS_069_09----------------------#'
139
SET @@low_priority_updates = ON;
140
SELECT @@low_priority_updates = @@local.low_priority_updates;
141
@@low_priority_updates = @@local.low_priority_updates
143
SELECT @@local.low_priority_updates = @@session.low_priority_updates;
144
@@local.low_priority_updates = @@session.low_priority_updates
146
'#---------------------FN_DYNVARS_069_10----------------------#'
147
SET low_priority_updates = 1;
148
SELECT @@low_priority_updates;
149
@@low_priority_updates
151
SELECT local.low_priority_updates;
152
ERROR 42S02: Unknown table 'local' in field list
153
SELECT session.low_priority_updates;
154
ERROR 42S02: Unknown table 'session' in field list
155
SELECT low_priority_updates = @@session.low_priority_updates;
156
ERROR 42S22: Unknown column 'low_priority_updates' in 'field list'
157
SET @@global.low_priority_updates = @start_global_value;
158
SELECT @@global.low_priority_updates;
159
@@global.low_priority_updates
161
SET @@session.low_priority_updates = @start_session_value;
162
SELECT @@session.low_priority_updates;
163
@@session.low_priority_updates