Debian Codegraph @

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

raw
1 SET @start_global_value = @@global.min_examined_row_limit;
2 SELECT @start_global_value;
3 @start_global_value
4 0
5 SET @start_session_value = @@session.min_examined_row_limit;
6 SELECT @start_session_value;
7 @start_session_value
8 0
9 '#--------------------FN_DYNVARS_089_01-------------------------#'
10 SET @@global.min_examined_row_limit = 100;
11 SET @@global.min_examined_row_limit = DEFAULT;
12 SELECT @@global.min_examined_row_limit;
13 @@global.min_examined_row_limit
14 0
15 SET @@session.min_examined_row_limit = 200;
16 SET @@session.min_examined_row_limit = DEFAULT;
17 SELECT @@session.min_examined_row_limit;
18 @@session.min_examined_row_limit
19 0
20 '#--------------------FN_DYNVARS_089_02-------------------------#'
21 SET @@global.min_examined_row_limit = DEFAULT;
22 SELECT @@global.min_examined_row_limit = 0;
23 @@global.min_examined_row_limit = 0
24 1
25 SET @@session.min_examined_row_limit = DEFAULT;
26 SELECT @@session.min_examined_row_limit = 0;
27 @@session.min_examined_row_limit = 0
28 1
29 '#--------------------FN_DYNVARS_089_03-------------------------#'
30 SET @@global.min_examined_row_limit = 0;
31 SELECT @@global.min_examined_row_limit;
32 @@global.min_examined_row_limit
33 0
34 SET @@global.min_examined_row_limit = 1;
35 SELECT @@global.min_examined_row_limit;
36 @@global.min_examined_row_limit
37 1
38 SET @@global.min_examined_row_limit = 60020;
39 SELECT @@global.min_examined_row_limit;
40 @@global.min_examined_row_limit
41 60020
42 SET @@global.min_examined_row_limit = 65535;
43 SELECT @@global.min_examined_row_limit;
44 @@global.min_examined_row_limit
45 65535
46 SET @@global.min_examined_row_limit = 4294967295;
47 SELECT @@global.min_examined_row_limit;
48 @@global.min_examined_row_limit
49 4294967295
50 SET @@global.min_examined_row_limit = 4294967294;
51 SELECT @@global.min_examined_row_limit;
52 @@global.min_examined_row_limit
53 4294967294
54 '#--------------------FN_DYNVARS_089_04-------------------------#'
55 SET @@session.min_examined_row_limit = 0;
56 SELECT @@session.min_examined_row_limit;
57 @@session.min_examined_row_limit
58 0
59 SET @@session.min_examined_row_limit = 1;
60 SELECT @@session.min_examined_row_limit;
61 @@session.min_examined_row_limit
62 1
63 SET @@session.min_examined_row_limit = 50050;
64 SELECT @@session.min_examined_row_limit;
65 @@session.min_examined_row_limit
66 50050
67 SET @@session.min_examined_row_limit = 65535;
68 SELECT @@session.min_examined_row_limit;
69 @@session.min_examined_row_limit
70 65535
71 SET @@session.min_examined_row_limit = 4294967295;
72 SELECT @@session.min_examined_row_limit;
73 @@session.min_examined_row_limit
74 4294967295
75 SET @@session.min_examined_row_limit = 4294967294;
76 SELECT @@session.min_examined_row_limit;
77 @@session.min_examined_row_limit
78 4294967294
79 '#------------------FN_DYNVARS_089_05-----------------------#'
80 SET @@global.min_examined_row_limit = -1024;
81 Warnings:
82 Warning 1292 Truncated incorrect min_examined_row_limit value: '-1024'
83 SELECT @@global.min_examined_row_limit;
84 @@global.min_examined_row_limit
85 0
86 SET @@global.min_examined_row_limit = 65530.34;
87 ERROR 42000: Incorrect argument type to variable 'min_examined_row_limit'
88 SELECT @@global.min_examined_row_limit;
89 @@global.min_examined_row_limit
90 0
91 SET @@global.min_examined_row_limit = test;
92 ERROR 42000: Incorrect argument type to variable 'min_examined_row_limit'
93 SELECT @@global.min_examined_row_limit;
94 @@global.min_examined_row_limit
95 0
96 SET @@global.min_examined_row_limit = 4294967296;
97 Warnings:
98 Warning 1292 Truncated incorrect min_examined_row_limit value: '4294967296'
99 SELECT @@global.min_examined_row_limit;
100 @@global.min_examined_row_limit
101 4294967295
102 SET @@global.min_examined_row_limit = 42949672950;
103 Warnings:
104 Warning 1292 Truncated incorrect min_examined_row_limit value: '42949672950'
105 SELECT @@global.min_examined_row_limit;
106 @@global.min_examined_row_limit
107 4294967295
108 SET @@session.min_examined_row_limit = -1;
109 Warnings:
110 Warning 1292 Truncated incorrect min_examined_row_limit value: '-1'
111 SELECT @@session.min_examined_row_limit;
112 @@session.min_examined_row_limit
113 0
114 SET @@session.min_examined_row_limit = 65530.34;
115 ERROR 42000: Incorrect argument type to variable 'min_examined_row_limit'
116 SET @@session.min_examined_row_limit = test;
117 ERROR 42000: Incorrect argument type to variable 'min_examined_row_limit'
118 SELECT @@session.min_examined_row_limit;
119 @@session.min_examined_row_limit
120 0
121 SET @@session.min_examined_row_limit = 4294967296;
122 Warnings:
123 Warning 1292 Truncated incorrect min_examined_row_limit value: '4294967296'
124 SELECT @@session.min_examined_row_limit;
125 @@session.min_examined_row_limit
126 4294967295
127 SET @@session.min_examined_row_limit = 42949672950;
128 Warnings:
129 Warning 1292 Truncated incorrect min_examined_row_limit value: '42949672950'
130 SELECT @@session.min_examined_row_limit;
131 @@session.min_examined_row_limit
132 4294967295
133 '#------------------FN_DYNVARS_089_06-----------------------#'
134 SELECT @@global.min_examined_row_limit = VARIABLE_VALUE
135 FROM performance_schema.global_variables
136 WHERE VARIABLE_NAME='min_examined_row_limit';
137 @@global.min_examined_row_limit = VARIABLE_VALUE
138 1
139 '#------------------FN_DYNVARS_089_07-----------------------#'
140 SELECT @@session.min_examined_row_limit = VARIABLE_VALUE
141 FROM performance_schema.session_variables
142 WHERE VARIABLE_NAME='min_examined_row_limit';
143 @@session.min_examined_row_limit = VARIABLE_VALUE
144 1
145 '#------------------FN_DYNVARS_089_08-----------------------#'
146 SET @@global.min_examined_row_limit = TRUE;
147 SELECT @@global.min_examined_row_limit;
148 @@global.min_examined_row_limit
149 1
150 SET @@global.min_examined_row_limit = FALSE;
151 SELECT @@global.min_examined_row_limit;
152 @@global.min_examined_row_limit
153 0
154 '#---------------------FN_DYNVARS_089_09----------------------#'
155 SET @@global.min_examined_row_limit = 10;
156 SELECT @@min_examined_row_limit = @@global.min_examined_row_limit;
157 @@min_examined_row_limit = @@global.min_examined_row_limit
158 0
159 '#---------------------FN_DYNVARS_089_10----------------------#'
160 SET @@min_examined_row_limit = 100;
161 SELECT @@min_examined_row_limit = @@local.min_examined_row_limit;
162 @@min_examined_row_limit = @@local.min_examined_row_limit
163 1
164 SELECT @@local.min_examined_row_limit = @@session.min_examined_row_limit;
165 @@local.min_examined_row_limit = @@session.min_examined_row_limit
166 1
167 '#---------------------FN_DYNVARS_089_11----------------------#'
168 SET min_examined_row_limit = 1;
169 SELECT @@min_examined_row_limit;
170 @@min_examined_row_limit
171 1
172 SELECT local.min_examined_row_limit;
173 ERROR 42S02: Unknown table 'local' in field list
174 SELECT session.min_examined_row_limit;
175 ERROR 42S02: Unknown table 'session' in field list
176 SELECT min_examined_row_limit = @@session.min_examined_row_limit;
177 ERROR 42S22: Unknown column 'min_examined_row_limit' in 'field list'
178 '#---------------------FN_DYNVARS_089_12----------------------#'
179 CREATE USER foo, bar;
180 GRANT SESSION_VARIABLES_ADMIN ON *.* TO bar;
181 SELECT @@session.min_examined_row_limit;
182 @@session.min_examined_row_limit
183 10
184 SET @@session.min_examined_row_limit = 1;
185 ERROR 42000: Access denied; you need (at least one of) the SYSTEM_VARIABLES_ADMIN or SESSION_VARIABLES_ADMIN privilege(s) for this operation
186 SELECT @@session.min_examined_row_limit;
187 @@session.min_examined_row_limit
188 10
189 SET @@session.min_examined_row_limit = 1;
190 SELECT @@session.min_examined_row_limit;
191 @@session.min_examined_row_limit
192 1
193 DROP USER foo, bar;
194 SET @@global.min_examined_row_limit = @start_global_value;
195 SELECT @@global.min_examined_row_limit;
196 @@global.min_examined_row_limit
197 0
198 SET @@session.min_examined_row_limit = @start_session_value;
199 SELECT @@session.min_examined_row_limit;
200 @@session.min_examined_row_limit
201 0