1
SET @start_global_value = @@global.updatable_views_with_limit;
2
SELECT @start_global_value;
5
SET @start_session_value = @@session.updatable_views_with_limit;
6
SELECT @start_session_value;
9
'#--------------------FN_DYNVARS_005_01-------------------------#'
10
SET @@global.updatable_views_with_limit = 'NO';
11
SET @@global.updatable_views_with_limit = DEFAULT;
12
SELECT @@global.updatable_views_with_limit;
13
@@global.updatable_views_with_limit
15
SET @@session.updatable_views_with_limit = 'NO';
16
SET @@session.updatable_views_with_limit = DEFAULT;
17
SELECT @@session.updatable_views_with_limit;
18
@@session.updatable_views_with_limit
20
'#--------------------FN_DYNVARS_005_02-------------------------#'
21
SET @@global.updatable_views_with_limit = DEFAULT;
22
SELECT @@global.updatable_views_with_limit = 'Yes';
23
@@global.updatable_views_with_limit = 'Yes'
25
SET @@session.updatable_views_with_limit = DEFAULT;
26
SELECT @@session.updatable_views_with_limit ='Yes';
27
@@session.updatable_views_with_limit ='Yes'
29
'#--------------------FN_DYNVARS_005_03-------------------------#'
30
SET @@global.updatable_views_with_limit = NO;
31
SELECT @@global.updatable_views_with_limit;
32
@@global.updatable_views_with_limit
34
SET @@global.updatable_views_with_limit = 'NO';
35
SELECT @@global.updatable_views_with_limit;
36
@@global.updatable_views_with_limit
38
SET @@global.updatable_views_with_limit = YES;
39
SELECT @@global.updatable_views_with_limit;
40
@@global.updatable_views_with_limit
42
SET @@global.updatable_views_with_limit = 'YES';
43
SELECT @@global.updatable_views_with_limit;
44
@@global.updatable_views_with_limit
46
SET @@global.updatable_views_with_limit = "NO";
47
SELECT @@global.updatable_views_with_limit;
48
@@global.updatable_views_with_limit
50
SET @@global.updatable_views_with_limit = "YES";
51
SELECT @@global.updatable_views_with_limit;
52
@@global.updatable_views_with_limit
54
SET @@global.updatable_views_with_limit = 1;
55
SELECT @@global.updatable_views_with_limit;
56
@@global.updatable_views_with_limit
58
SET @@global.updatable_views_with_limit = 0;
59
SELECT @@global.updatable_views_with_limit;
60
@@global.updatable_views_with_limit
62
SET @@global.updatable_views_with_limit = TRUE;
63
SELECT @@global.updatable_views_with_limit;
64
@@global.updatable_views_with_limit
66
SET @@global.updatable_views_with_limit = False;
67
SELECT @@global.updatable_views_with_limit;
68
@@global.updatable_views_with_limit
70
'#--------------------FN_DYNVARS_005_04-------------------------#'
71
SET @@session.updatable_views_with_limit = NO;
72
SELECT @@session.updatable_views_with_limit;
73
@@session.updatable_views_with_limit
75
SET @@session.updatable_views_with_limit = 'NO';
76
SELECT @@session.updatable_views_with_limit;
77
@@session.updatable_views_with_limit
79
SET @@session.updatable_views_with_limit = YES;
80
SELECT @@session.updatable_views_with_limit;
81
@@session.updatable_views_with_limit
83
SET @@session.updatable_views_with_limit = 'YES';
84
SELECT @@session.updatable_views_with_limit;
85
@@session.updatable_views_with_limit
87
SET @@session.updatable_views_with_limit = "YES";
88
SELECT @@session.updatable_views_with_limit;
89
@@session.updatable_views_with_limit
91
SET @@session.updatable_views_with_limit = "NO";
92
SELECT @@session.updatable_views_with_limit;
93
@@session.updatable_views_with_limit
95
SET @@session.updatable_views_with_limit =1;
96
SELECT @@session.updatable_views_with_limit;
97
@@session.updatable_views_with_limit
99
SET @@session.updatable_views_with_limit = 0;
100
SELECT @@session.updatable_views_with_limit;
101
@@session.updatable_views_with_limit
103
SET @@session.updatable_views_with_limit = True;
104
SELECT @@session.updatable_views_with_limit;
105
@@session.updatable_views_with_limit
107
SET @@session.updatable_views_with_limit = False;
108
SELECT @@session.updatable_views_with_limit;
109
@@session.updatable_views_with_limit
111
'#------------------FN_DYNVARS_005_05-----------------------#'
112
SET @@global.updatable_views_with_limit = "TRUE";
113
ERROR 42000: Variable 'updatable_views_with_limit' can't be set to the value of 'TRUE'
114
SET @@global.updatable_views_with_limit = -1024;
115
ERROR 42000: Variable 'updatable_views_with_limit' can't be set to the value of '-1024'
116
SET @@global.updatable_views_with_limit = 2345;
117
ERROR 42000: Variable 'updatable_views_with_limit' can't be set to the value of '2345'
118
SET @@global.updatable_views_with_limit = "FALSE";
119
ERROR 42000: Variable 'updatable_views_with_limit' can't be set to the value of 'FALSE'
120
SET @@global.updatable_views_with_limit = 65530.34;
121
ERROR 42000: Variable 'updatable_views_with_limit' can't be set to the value of '65530'
122
SET @@global.updatable_views_with_limit ="Testing";
123
ERROR 42000: Variable 'updatable_views_with_limit' can't be set to the value of 'Testing'
124
SET @@session.updatable_views_with_limit = "ON";
125
ERROR 42000: Variable 'updatable_views_with_limit' can't be set to the value of 'ON'
126
SET @@session.updatable_views_with_limit = "OFF";
127
ERROR 42000: Variable 'updatable_views_with_limit' can't be set to the value of 'OFF'
128
SET @@session.updatable_views_with_limit = "True";
129
ERROR 42000: Variable 'updatable_views_with_limit' can't be set to the value of 'True'
130
SET @@session.updatable_views_with_limit = "False";
131
ERROR 42000: Variable 'updatable_views_with_limit' can't be set to the value of 'False'
132
SET @@session.updatable_views_with_limit = "Test";
133
ERROR 42000: Variable 'updatable_views_with_limit' can't be set to the value of 'Test'
134
SET @@session.updatable_views_with_limit = 'test';
135
ERROR 42000: Variable 'updatable_views_with_limit' can't be set to the value of 'test'
136
SET @@session.updatable_views_with_limit = 123456789031;
137
ERROR 42000: Variable 'updatable_views_with_limit' can't be set to the value of '123456789031'
138
'#------------------FN_DYNVARS_005_06-----------------------#'
139
SELECT @@global.updatable_views_with_limit = VARIABLE_VALUE
140
FROM INFORMATION_SCHEMA.GLOBAL_VARIABLES
141
WHERE VARIABLE_NAME='updatable_views_with_limit';
142
@@global.updatable_views_with_limit = VARIABLE_VALUE
144
'#------------------FN_DYNVARS_005_07-----------------------#'
145
SELECT @@session.updatable_views_with_limit = VARIABLE_VALUE
146
FROM INFORMATION_SCHEMA.SESSION_VARIABLES
147
WHERE VARIABLE_NAME='updatable_views_with_limit';
148
@@session.updatable_views_with_limit = VARIABLE_VALUE
150
'#---------------------FN_DYNVARS_001_08----------------------#'
151
SET @@global.updatable_views_with_limit = NO;
152
SET @@session.updatable_views_with_limit = YES;
153
SELECT @@updatable_views_with_limit = @@global.updatable_views_with_limit;
154
@@updatable_views_with_limit = @@global.updatable_views_with_limit
156
'#---------------------FN_DYNVARS_001_09----------------------#'
157
SET @@updatable_views_with_limit = YES;
158
SELECT @@updatable_views_with_limit = @@local.updatable_views_with_limit;
159
@@updatable_views_with_limit = @@local.updatable_views_with_limit
161
SELECT @@local.updatable_views_with_limit = @@session.updatable_views_with_limit;
162
@@local.updatable_views_with_limit = @@session.updatable_views_with_limit
164
'#---------------------FN_DYNVARS_001_10----------------------#'
165
SET updatable_views_with_limit = 1027;
166
ERROR 42000: Variable 'updatable_views_with_limit' can't be set to the value of '1027'
167
SELECT @@updatable_views_with_limit;
168
@@updatable_views_with_limit
170
SELECT local.updatable_views_with_limit;
171
ERROR 42S02: Unknown table 'local' in field list
172
SELECT session.updatable_views_with_limit;
173
ERROR 42S02: Unknown table 'session' in field list
174
SELECT updatable_views_with_limit = @@session.updatable_views_with_limit;
175
ERROR 42S22: Unknown column 'updatable_views_with_limit' in 'field list'
176
SET @@global.updatable_views_with_limit = @start_global_value;
177
SELECT @@global.updatable_views_with_limit;
178
@@global.updatable_views_with_limit
180
SET @@session.updatable_views_with_limit = @start_session_value;
181
SELECT @@session.updatable_views_with_limit;
182
@@session.updatable_views_with_limit