Debian Codegraph @

mysql-test/suite/sys_vars/r/min_examined_row_limit_basic_64.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 SET @@global.min_examined_row_limit = 18446744073709551615;
55 SELECT @@global.min_examined_row_limit;
56 @@global.min_examined_row_limit
57 18446744073709551615
58 '#--------------------FN_DYNVARS_089_04-------------------------#'
59 SET @@session.min_examined_row_limit = 0;
60 SELECT @@session.min_examined_row_limit;
61 @@session.min_examined_row_limit
62 0
63 SET @@session.min_examined_row_limit = 1;
64 SELECT @@session.min_examined_row_limit;
65 @@session.min_examined_row_limit
66 1
67 SET @@session.min_examined_row_limit = 50050;
68 SELECT @@session.min_examined_row_limit;
69 @@session.min_examined_row_limit
70 50050
71 SET @@session.min_examined_row_limit = 65535;
72 SELECT @@session.min_examined_row_limit;
73 @@session.min_examined_row_limit
74 65535
75 SET @@session.min_examined_row_limit = 4294967295;
76 SELECT @@session.min_examined_row_limit;
77 @@session.min_examined_row_limit
78 4294967295
79 SET @@session.min_examined_row_limit = 4294967294;
80 SELECT @@session.min_examined_row_limit;
81 @@session.min_examined_row_limit
82 4294967294
83 SET @@session.min_examined_row_limit = 18446744073709551615;
84 SELECT @@session.min_examined_row_limit;
85 @@session.min_examined_row_limit
86 18446744073709551615
87 '#------------------FN_DYNVARS_089_05-----------------------#'
88 SET @@global.min_examined_row_limit = -1024;
89 Warnings:
90 Warning 1292 Truncated incorrect min_examined_row_limit value: '-1024'
91 SELECT @@global.min_examined_row_limit;
92 @@global.min_examined_row_limit
93 0
94 SET @@global.min_examined_row_limit = 65530.34;
95 ERROR 42000: Incorrect argument type to variable 'min_examined_row_limit'
96 SELECT @@global.min_examined_row_limit;
97 @@global.min_examined_row_limit
98 0
99 SET @@global.min_examined_row_limit = test;
100 ERROR 42000: Incorrect argument type to variable 'min_examined_row_limit'
101 SELECT @@global.min_examined_row_limit;
102 @@global.min_examined_row_limit
103 0
104 SET @@global.min_examined_row_limit = 18446744073709551616;
105 ERROR 42000: Incorrect argument type to variable 'min_examined_row_limit'
106 SELECT @@global.min_examined_row_limit;
107 @@global.min_examined_row_limit
108 0
109 SET @@session.min_examined_row_limit = -1;
110 Warnings:
111 Warning 1292 Truncated incorrect min_examined_row_limit value: '-1'
112 SELECT @@session.min_examined_row_limit;
113 @@session.min_examined_row_limit
114 0
115 SET @@session.min_examined_row_limit = 65530.34;
116 ERROR 42000: Incorrect argument type to variable 'min_examined_row_limit'
117 SET @@session.min_examined_row_limit = test;
118 ERROR 42000: Incorrect argument type to variable 'min_examined_row_limit'
119 SELECT @@session.min_examined_row_limit;
120 @@session.min_examined_row_limit
121 0
122 SET @@session.min_examined_row_limit = 18446744073709551616;
123 ERROR 42000: Incorrect argument type to variable 'min_examined_row_limit'
124 SELECT @@session.min_examined_row_limit;
125 @@session.min_examined_row_limit
126 0
127 '#------------------FN_DYNVARS_089_06-----------------------#'
128 SELECT @@global.min_examined_row_limit = VARIABLE_VALUE
129 FROM performance_schema.global_variables
130 WHERE VARIABLE_NAME='min_examined_row_limit';
131 @@global.min_examined_row_limit = VARIABLE_VALUE
132 1
133 '#------------------FN_DYNVARS_089_07-----------------------#'
134 SELECT @@session.min_examined_row_limit = VARIABLE_VALUE
135 FROM performance_schema.session_variables
136 WHERE VARIABLE_NAME='min_examined_row_limit';
137 @@session.min_examined_row_limit = VARIABLE_VALUE
138 1
139 '#------------------FN_DYNVARS_089_08-----------------------#'
140 SET @@global.min_examined_row_limit = TRUE;
141 SELECT @@global.min_examined_row_limit;
142 @@global.min_examined_row_limit
143 1
144 SET @@global.min_examined_row_limit = FALSE;
145 SELECT @@global.min_examined_row_limit;
146 @@global.min_examined_row_limit
147 0
148 '#---------------------FN_DYNVARS_089_09----------------------#'
149 SET @@global.min_examined_row_limit = 10;
150 SELECT @@min_examined_row_limit = @@global.min_examined_row_limit;
151 @@min_examined_row_limit = @@global.min_examined_row_limit
152 0
153 '#---------------------FN_DYNVARS_089_10----------------------#'
154 SET @@min_examined_row_limit = 100;
155 SELECT @@min_examined_row_limit = @@local.min_examined_row_limit;
156 @@min_examined_row_limit = @@local.min_examined_row_limit
157 1
158 SELECT @@local.min_examined_row_limit = @@session.min_examined_row_limit;
159 @@local.min_examined_row_limit = @@session.min_examined_row_limit
160 1
161 '#---------------------FN_DYNVARS_089_11----------------------#'
162 SET min_examined_row_limit = 1;
163 SELECT @@min_examined_row_limit;
164 @@min_examined_row_limit
165 1
166 SELECT local.min_examined_row_limit;
167 ERROR 42S02: Unknown table 'local' in field list
168 SELECT session.min_examined_row_limit;
169 ERROR 42S02: Unknown table 'session' in field list
170 SELECT min_examined_row_limit = @@session.min_examined_row_limit;
171 ERROR 42S22: Unknown column 'min_examined_row_limit' in 'field list'
172 '#---------------------FN_DYNVARS_089_12----------------------#'
173 CREATE USER foo, bar;
174 GRANT SESSION_VARIABLES_ADMIN ON *.* TO bar;
175 SELECT @@session.min_examined_row_limit;
176 @@session.min_examined_row_limit
177 10
178 SET @@session.min_examined_row_limit = 1;
179 ERROR 42000: Access denied; you need (at least one of) the SYSTEM_VARIABLES_ADMIN or SESSION_VARIABLES_ADMIN privilege(s) for this operation
180 SELECT @@session.min_examined_row_limit;
181 @@session.min_examined_row_limit
182 10
183 SET @@session.min_examined_row_limit = 1;
184 SELECT @@session.min_examined_row_limit;
185 @@session.min_examined_row_limit
186 1
187 DROP USER foo, bar;
188 SET @@global.min_examined_row_limit = @start_global_value;
189 SELECT @@global.min_examined_row_limit;
190 @@global.min_examined_row_limit
191 0
192 SET @@session.min_examined_row_limit = @start_session_value;
193 SELECT @@session.min_examined_row_limit;
194 @@session.min_examined_row_limit
195 0