Debian Codegraph @

mysql-test/suite/sys_vars/r/min_examined_row_limit_basic.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 = 429496726;
81 SELECT @@global.min_examined_row_limit;
82 @@global.min_examined_row_limit
83 429496726
84 SET @@global.min_examined_row_limit = -1024;
85 Warnings:
86 Warning 1292 Truncated incorrect min_examined_row_limit value: '-1024'
87 SELECT @@global.min_examined_row_limit;
88 @@global.min_examined_row_limit
89 0
90 SET @@global.min_examined_row_limit = 429496729500;
91 Warnings:
92 Warning 1292 Truncated incorrect min_examined_row_limit value: '429496729500'
93 SELECT @@global.min_examined_row_limit;
94 @@global.min_examined_row_limit
95 4294967295
96 SET @@global.min_examined_row_limit = 65530.34;
97 ERROR 42000: Incorrect argument type to variable 'min_examined_row_limit'
98 SELECT @@global.min_examined_row_limit;
99 @@global.min_examined_row_limit
100 4294967295
101 SET @@global.min_examined_row_limit = test;
102 ERROR 42000: Incorrect argument type to variable 'min_examined_row_limit'
103 SELECT @@global.min_examined_row_limit;
104 @@global.min_examined_row_limit
105 4294967295
106 SET @@session.min_examined_row_limit = 4294967296;
107 Warnings:
108 Warning 1292 Truncated incorrect min_examined_row_limit value: '4294967296'
109 SELECT @@session.min_examined_row_limit;
110 @@session.min_examined_row_limit
111 4294967295
112 SET @@session.min_examined_row_limit = -1;
113 Warnings:
114 Warning 1292 Truncated incorrect min_examined_row_limit value: '-1'
115 SELECT @@session.min_examined_row_limit;
116 @@session.min_examined_row_limit
117 0
118 SET @@session.min_examined_row_limit = 65530.34;
119 ERROR 42000: Incorrect argument type to variable 'min_examined_row_limit'
120 SET @@session.min_examined_row_limit = 4294967295021;
121 Warnings:
122 Warning 1292 Truncated incorrect min_examined_row_limit value: '4294967295021'
123 SELECT @@session.min_examined_row_limit;
124 @@session.min_examined_row_limit
125 4294967295
126 SET @@session.min_examined_row_limit = test;
127 ERROR 42000: Incorrect argument type to variable 'min_examined_row_limit'
128 SELECT @@session.min_examined_row_limit;
129 @@session.min_examined_row_limit
130 4294967295
131 '#------------------FN_DYNVARS_089_06-----------------------#'
132 SELECT @@global.min_examined_row_limit = VARIABLE_VALUE
133 FROM INFORMATION_SCHEMA.GLOBAL_VARIABLES
134 WHERE VARIABLE_NAME='min_examined_row_limit';
135 @@global.min_examined_row_limit = VARIABLE_VALUE
136 1
137 '#------------------FN_DYNVARS_089_07-----------------------#'
138 SELECT @@session.min_examined_row_limit = VARIABLE_VALUE
139 FROM INFORMATION_SCHEMA.SESSION_VARIABLES
140 WHERE VARIABLE_NAME='min_examined_row_limit';
141 @@session.min_examined_row_limit = VARIABLE_VALUE
142 1
143 '#------------------FN_DYNVARS_089_08-----------------------#'
144 SET @@global.min_examined_row_limit = TRUE;
145 SELECT @@global.min_examined_row_limit;
146 @@global.min_examined_row_limit
147 1
148 SET @@global.min_examined_row_limit = FALSE;
149 SELECT @@global.min_examined_row_limit;
150 @@global.min_examined_row_limit
151 0
152 '#---------------------FN_DYNVARS_089_09----------------------#'
153 SET @@global.min_examined_row_limit = 10;
154 SELECT @@min_examined_row_limit = @@global.min_examined_row_limit;
155 @@min_examined_row_limit = @@global.min_examined_row_limit
156 0
157 '#---------------------FN_DYNVARS_089_10----------------------#'
158 SET @@min_examined_row_limit = 100;
159 SELECT @@min_examined_row_limit = @@local.min_examined_row_limit;
160 @@min_examined_row_limit = @@local.min_examined_row_limit
161 1
162 SELECT @@local.min_examined_row_limit = @@session.min_examined_row_limit;
163 @@local.min_examined_row_limit = @@session.min_examined_row_limit
164 1
165 '#---------------------FN_DYNVARS_089_11----------------------#'
166 SET min_examined_row_limit = 1;
167 SELECT @@min_examined_row_limit;
168 @@min_examined_row_limit
169 1
170 SELECT local.min_examined_row_limit;
171 ERROR 42S02: Unknown table 'local' in SELECT
172 SELECT session.min_examined_row_limit;
173 ERROR 42S02: Unknown table 'session' in SELECT
174 SELECT min_examined_row_limit = @@session.min_examined_row_limit;
175 ERROR 42S22: Unknown column 'min_examined_row_limit' in 'SELECT'
176 SET @@global.min_examined_row_limit = @start_global_value;
177 SELECT @@global.min_examined_row_limit;
178 @@global.min_examined_row_limit
179 0
180 SET @@session.min_examined_row_limit = @start_session_value;
181 SELECT @@session.min_examined_row_limit;
182 @@session.min_examined_row_limit
183 0