Debian Codegraph @

mysql-test/suite/sys_vars/r/updatable_views_with_limit_basic.result

raw
1 SET @start_global_value = @@global.updatable_views_with_limit;
2 SELECT @start_global_value;
3 @start_global_value
4 YES
5 SET @start_session_value = @@session.updatable_views_with_limit;
6 SELECT @start_session_value;
7 @start_session_value
8 YES
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
14 YES
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
19 YES
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'
24 1
25 SET @@session.updatable_views_with_limit = DEFAULT;
26 SELECT @@session.updatable_views_with_limit ='Yes';
27 @@session.updatable_views_with_limit ='Yes'
28 1
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
33 NO
34 SET @@global.updatable_views_with_limit = 'NO';
35 SELECT @@global.updatable_views_with_limit;
36 @@global.updatable_views_with_limit
37 NO
38 SET @@global.updatable_views_with_limit = YES;
39 SELECT @@global.updatable_views_with_limit;
40 @@global.updatable_views_with_limit
41 YES
42 SET @@global.updatable_views_with_limit = 'YES';
43 SELECT @@global.updatable_views_with_limit;
44 @@global.updatable_views_with_limit
45 YES
46 SET @@global.updatable_views_with_limit = "NO";
47 SELECT @@global.updatable_views_with_limit;
48 @@global.updatable_views_with_limit
49 NO
50 SET @@global.updatable_views_with_limit = "YES";
51 SELECT @@global.updatable_views_with_limit;
52 @@global.updatable_views_with_limit
53 YES
54 SET @@global.updatable_views_with_limit = 1;
55 SELECT @@global.updatable_views_with_limit;
56 @@global.updatable_views_with_limit
57 YES
58 SET @@global.updatable_views_with_limit = 0;
59 SELECT @@global.updatable_views_with_limit;
60 @@global.updatable_views_with_limit
61 NO
62 SET @@global.updatable_views_with_limit = TRUE;
63 SELECT @@global.updatable_views_with_limit;
64 @@global.updatable_views_with_limit
65 YES
66 SET @@global.updatable_views_with_limit = False;
67 SELECT @@global.updatable_views_with_limit;
68 @@global.updatable_views_with_limit
69 NO
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
74 NO
75 SET @@session.updatable_views_with_limit = 'NO';
76 SELECT @@session.updatable_views_with_limit;
77 @@session.updatable_views_with_limit
78 NO
79 SET @@session.updatable_views_with_limit = YES;
80 SELECT @@session.updatable_views_with_limit;
81 @@session.updatable_views_with_limit
82 YES
83 SET @@session.updatable_views_with_limit = 'YES';
84 SELECT @@session.updatable_views_with_limit;
85 @@session.updatable_views_with_limit
86 YES
87 SET @@session.updatable_views_with_limit = "YES";
88 SELECT @@session.updatable_views_with_limit;
89 @@session.updatable_views_with_limit
90 YES
91 SET @@session.updatable_views_with_limit = "NO";
92 SELECT @@session.updatable_views_with_limit;
93 @@session.updatable_views_with_limit
94 NO
95 SET @@session.updatable_views_with_limit =1;
96 SELECT @@session.updatable_views_with_limit;
97 @@session.updatable_views_with_limit
98 YES
99 SET @@session.updatable_views_with_limit = 0;
100 SELECT @@session.updatable_views_with_limit;
101 @@session.updatable_views_with_limit
102 NO
103 SET @@session.updatable_views_with_limit = True;
104 SELECT @@session.updatable_views_with_limit;
105 @@session.updatable_views_with_limit
106 YES
107 SET @@session.updatable_views_with_limit = False;
108 SELECT @@session.updatable_views_with_limit;
109 @@session.updatable_views_with_limit
110 NO
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: Incorrect argument type to variable 'updatable_views_with_limit'
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 performance_schema.global_variables
141 WHERE VARIABLE_NAME='updatable_views_with_limit';
142 @@global.updatable_views_with_limit = VARIABLE_VALUE
143 1
144 '#------------------FN_DYNVARS_005_07-----------------------#'
145 SELECT @@session.updatable_views_with_limit = VARIABLE_VALUE
146 FROM performance_schema.session_variables
147 WHERE VARIABLE_NAME='updatable_views_with_limit';
148 @@session.updatable_views_with_limit = VARIABLE_VALUE
149 1
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
155 0
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
160 1
161 SELECT @@local.updatable_views_with_limit = @@session.updatable_views_with_limit;
162 @@local.updatable_views_with_limit = @@session.updatable_views_with_limit
163 1
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
169 YES
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
179 YES
180 SET @@session.updatable_views_with_limit = @start_session_value;
181 SELECT @@session.updatable_views_with_limit;
182 @@session.updatable_views_with_limit
183 YES