Debian Codegraph @

mysql-test/suite/innodb/r/records_in_range.result

raw
1 CREATE TABLE records_in_range_test (
2 c1 VARCHAR(16),
3 c2 VARCHAR(512),
4 PRIMARY KEY (c1)
5 ) ENGINE=INNODB STATS_PERSISTENT=1;
6 INSERT INTO records_in_range_test VALUES
7 ('ccc', REPEAT('v', 512)),
8 ('kkk01', REPEAT('v', 512)),
9 ('kkk02', REPEAT('v', 512)),
10 ('kkk03', REPEAT('v', 512)),
11 ('kkk04', REPEAT('v', 512)),
12 ('kkk05', REPEAT('v', 512)),
13 ('kkk06', REPEAT('v', 512)),
14 ('kkk07', REPEAT('v', 512)),
15 ('kkk08', REPEAT('v', 512)),
16 ('mmm', REPEAT('v', 512)),
17 ('nnn', REPEAT('v', 512)),
18 ('uuu01', REPEAT('v', 512)),
19 ('uuu02', REPEAT('v', 512)),
20 ('uuu03', REPEAT('v', 512)),
21 ('uuu04', REPEAT('v', 512)),
22 ('uuu05', REPEAT('v', 512)),
23 ('uuu06', REPEAT('v', 512)),
24 ('uuu07', REPEAT('v', 512)),
25 ('uuu08', REPEAT('v', 512)),
26 ('xxx', REPEAT('v', 512));
27 SET STATEMENT use_stat_tables=never FOR
28 ANALYZE TABLE records_in_range_test;
29 Table Op Msg_type Msg_text
30 test.records_in_range_test analyze status OK
31 SELECT index_name, stat_name, stat_value
32 FROM mysql.innodb_index_stats
33 WHERE
34 table_name='records_in_range_test' AND stat_name = 'n_leaf_pages';
35 index_name stat_name stat_value
36 PRIMARY n_leaf_pages 1
37 SELECT index_name, stat_name, stat_value
38 FROM mysql.innodb_index_stats
39 WHERE
40 table_name='records_in_range_test' AND stat_name = 'size';
41 index_name stat_name stat_value
42 PRIMARY size 1
43 SET @save_dbug = @@debug_dbug;
44 SET DEBUG_DBUG='+d,print_btr_estimate_n_rows_in_range_return_value';
45
46 In all SELECTs below the number of the records in the range returned
47 by COUNT(*) must be the same as the number returned by
48 btr_estimate_n_rows_in_range() which can be seen inside the artificial
49 warning
50
51 Test left-unbounded, right-open intervals
52
53 SELECT COUNT(*) FROM records_in_range_test WHERE c1 < 'aaa';
54 COUNT(*)
55 0
56 Warnings:
57 Warning 1230 btr_estimate_n_rows_in_range(): 0
58 SELECT COUNT(*) FROM records_in_range_test WHERE c1 < 'ccc';
59 COUNT(*)
60 0
61 Warnings:
62 Warning 1230 btr_estimate_n_rows_in_range(): 0
63 SELECT COUNT(*) FROM records_in_range_test WHERE c1 < 'eee';
64 COUNT(*)
65 1
66 Warnings:
67 Warning 1230 btr_estimate_n_rows_in_range(): 1
68 SELECT COUNT(*) FROM records_in_range_test WHERE c1 < 'mmm';
69 COUNT(*)
70 9
71 Warnings:
72 Warning 1230 btr_estimate_n_rows_in_range(): 9
73 SELECT COUNT(*) FROM records_in_range_test WHERE c1 < 'nnn';
74 COUNT(*)
75 10
76 Warnings:
77 Warning 1230 btr_estimate_n_rows_in_range(): 10
78 SELECT COUNT(*) FROM records_in_range_test WHERE c1 < 'qqq';
79 COUNT(*)
80 11
81 Warnings:
82 Warning 1230 btr_estimate_n_rows_in_range(): 11
83 SELECT COUNT(*) FROM records_in_range_test WHERE c1 < 'xxx';
84 COUNT(*)
85 19
86 Warnings:
87 Warning 1230 btr_estimate_n_rows_in_range(): 19
88 SELECT COUNT(*) FROM records_in_range_test WHERE c1 < 'zzz';
89 COUNT(*)
90 20
91 Warnings:
92 Warning 1230 btr_estimate_n_rows_in_range(): 20
93
94 Test left-unbounded, right-closed intervals
95
96 SELECT COUNT(*) FROM records_in_range_test WHERE c1 <= 'aaa';
97 COUNT(*)
98 0
99 Warnings:
100 Warning 1230 btr_estimate_n_rows_in_range(): 0
101 SELECT COUNT(*) FROM records_in_range_test WHERE c1 <= 'ccc';
102 COUNT(*)
103 1
104 Warnings:
105 Warning 1230 btr_estimate_n_rows_in_range(): 1
106 SELECT COUNT(*) FROM records_in_range_test WHERE c1 <= 'eee';
107 COUNT(*)
108 1
109 Warnings:
110 Warning 1230 btr_estimate_n_rows_in_range(): 1
111 SELECT COUNT(*) FROM records_in_range_test WHERE c1 <= 'mmm';
112 COUNT(*)
113 10
114 Warnings:
115 Warning 1230 btr_estimate_n_rows_in_range(): 10
116 SELECT COUNT(*) FROM records_in_range_test WHERE c1 <= 'nnn';
117 COUNT(*)
118 11
119 Warnings:
120 Warning 1230 btr_estimate_n_rows_in_range(): 11
121 SELECT COUNT(*) FROM records_in_range_test WHERE c1 <= 'qqq';
122 COUNT(*)
123 11
124 Warnings:
125 Warning 1230 btr_estimate_n_rows_in_range(): 11
126 SELECT COUNT(*) FROM records_in_range_test WHERE c1 <= 'xxx';
127 COUNT(*)
128 20
129 Warnings:
130 Warning 1230 btr_estimate_n_rows_in_range(): 20
131 SELECT COUNT(*) FROM records_in_range_test WHERE c1 <= 'zzz';
132 COUNT(*)
133 20
134 Warnings:
135 Warning 1230 btr_estimate_n_rows_in_range(): 20
136
137 Test left-open, right-unbounded intervals
138
139 SELECT COUNT(*) FROM records_in_range_test WHERE c1 > 'aaa';
140 COUNT(*)
141 20
142 Warnings:
143 Warning 1230 btr_estimate_n_rows_in_range(): 20
144 SELECT COUNT(*) FROM records_in_range_test WHERE c1 > 'ccc';
145 COUNT(*)
146 19
147 Warnings:
148 Warning 1230 btr_estimate_n_rows_in_range(): 19
149 SELECT COUNT(*) FROM records_in_range_test WHERE c1 > 'eee';
150 COUNT(*)
151 19
152 Warnings:
153 Warning 1230 btr_estimate_n_rows_in_range(): 19
154 SELECT COUNT(*) FROM records_in_range_test WHERE c1 > 'mmm';
155 COUNT(*)
156 10
157 Warnings:
158 Warning 1230 btr_estimate_n_rows_in_range(): 10
159 SELECT COUNT(*) FROM records_in_range_test WHERE c1 > 'nnn';
160 COUNT(*)
161 9
162 Warnings:
163 Warning 1230 btr_estimate_n_rows_in_range(): 9
164 SELECT COUNT(*) FROM records_in_range_test WHERE c1 > 'qqq';
165 COUNT(*)
166 9
167 Warnings:
168 Warning 1230 btr_estimate_n_rows_in_range(): 9
169 SELECT COUNT(*) FROM records_in_range_test WHERE c1 > 'xxx';
170 COUNT(*)
171 0
172 Warnings:
173 Warning 1230 btr_estimate_n_rows_in_range(): 0
174 SELECT COUNT(*) FROM records_in_range_test WHERE c1 > 'zzz';
175 COUNT(*)
176 0
177 Warnings:
178 Warning 1230 btr_estimate_n_rows_in_range(): 0
179
180 Test left-closed, right-unbounded intervals
181
182 SELECT COUNT(*) FROM records_in_range_test WHERE c1 >= 'aaa';
183 COUNT(*)
184 20
185 Warnings:
186 Warning 1230 btr_estimate_n_rows_in_range(): 20
187 SELECT COUNT(*) FROM records_in_range_test WHERE c1 >= 'ccc';
188 COUNT(*)
189 20
190 Warnings:
191 Warning 1230 btr_estimate_n_rows_in_range(): 20
192 SELECT COUNT(*) FROM records_in_range_test WHERE c1 >= 'eee';
193 COUNT(*)
194 19
195 Warnings:
196 Warning 1230 btr_estimate_n_rows_in_range(): 19
197 SELECT COUNT(*) FROM records_in_range_test WHERE c1 >= 'mmm';
198 COUNT(*)
199 11
200 Warnings:
201 Warning 1230 btr_estimate_n_rows_in_range(): 11
202 SELECT COUNT(*) FROM records_in_range_test WHERE c1 >= 'nnn';
203 COUNT(*)
204 10
205 Warnings:
206 Warning 1230 btr_estimate_n_rows_in_range(): 10
207 SELECT COUNT(*) FROM records_in_range_test WHERE c1 >= 'qqq';
208 COUNT(*)
209 9
210 Warnings:
211 Warning 1230 btr_estimate_n_rows_in_range(): 9
212 SELECT COUNT(*) FROM records_in_range_test WHERE c1 >= 'xxx';
213 COUNT(*)
214 1
215 Warnings:
216 Warning 1230 btr_estimate_n_rows_in_range(): 1
217 SELECT COUNT(*) FROM records_in_range_test WHERE c1 >= 'zzz';
218 COUNT(*)
219 0
220 Warnings:
221 Warning 1230 btr_estimate_n_rows_in_range(): 0
222
223 Test left-open, right-open intervals
224 In some cases here the optimizer is smart enough not to call
225 ha_innobase::records_in_range() at all, so we get no warning containing
226 the value returned from btr_estimate_n_rows_in_range()
227
228 SELECT COUNT(*) FROM records_in_range_test WHERE c1 > 'aaa' AND c1 < 'bbb';
229 COUNT(*)
230 0
231 Warnings:
232 Warning 1230 btr_estimate_n_rows_in_range(): 0
233 SELECT COUNT(*) FROM records_in_range_test WHERE c1 > 'aaa' AND c1 < 'ccc';
234 COUNT(*)
235 0
236 Warnings:
237 Warning 1230 btr_estimate_n_rows_in_range(): 0
238 SELECT COUNT(*) FROM records_in_range_test WHERE c1 > 'aaa' AND c1 < 'eee';
239 COUNT(*)
240 1
241 Warnings:
242 Warning 1230 btr_estimate_n_rows_in_range(): 1
243 SELECT COUNT(*) FROM records_in_range_test WHERE c1 > 'aaa' AND c1 < 'mmm';
244 COUNT(*)
245 9
246 Warnings:
247 Warning 1230 btr_estimate_n_rows_in_range(): 9
248 SELECT COUNT(*) FROM records_in_range_test WHERE c1 > 'aaa' AND c1 < 'nnn';
249 COUNT(*)
250 10
251 Warnings:
252 Warning 1230 btr_estimate_n_rows_in_range(): 10
253 SELECT COUNT(*) FROM records_in_range_test WHERE c1 > 'aaa' AND c1 < 'qqq';
254 COUNT(*)
255 11
256 Warnings:
257 Warning 1230 btr_estimate_n_rows_in_range(): 11
258 SELECT COUNT(*) FROM records_in_range_test WHERE c1 > 'aaa' AND c1 < 'xxx';
259 COUNT(*)
260 19
261 Warnings:
262 Warning 1230 btr_estimate_n_rows_in_range(): 19
263 SELECT COUNT(*) FROM records_in_range_test WHERE c1 > 'aaa' AND c1 < 'zzz';
264 COUNT(*)
265 20
266 Warnings:
267 Warning 1230 btr_estimate_n_rows_in_range(): 20
268
269 SELECT COUNT(*) FROM records_in_range_test WHERE c1 > 'ccc' AND c1 < 'bbb';
270 COUNT(*)
271 0
272 SELECT COUNT(*) FROM records_in_range_test WHERE c1 > 'ccc' AND c1 < 'ccc';
273 COUNT(*)
274 0
275 SELECT COUNT(*) FROM records_in_range_test WHERE c1 > 'ccc' AND c1 < 'eee';
276 COUNT(*)
277 0
278 Warnings:
279 Warning 1230 btr_estimate_n_rows_in_range(): 0
280 SELECT COUNT(*) FROM records_in_range_test WHERE c1 > 'ccc' AND c1 < 'mmm';
281 COUNT(*)
282 8
283 Warnings:
284 Warning 1230 btr_estimate_n_rows_in_range(): 8
285 SELECT COUNT(*) FROM records_in_range_test WHERE c1 > 'ccc' AND c1 < 'nnn';
286 COUNT(*)
287 9
288 Warnings:
289 Warning 1230 btr_estimate_n_rows_in_range(): 9
290 SELECT COUNT(*) FROM records_in_range_test WHERE c1 > 'ccc' AND c1 < 'qqq';
291 COUNT(*)
292 10
293 Warnings:
294 Warning 1230 btr_estimate_n_rows_in_range(): 10
295 SELECT COUNT(*) FROM records_in_range_test WHERE c1 > 'ccc' AND c1 < 'xxx';
296 COUNT(*)
297 18
298 Warnings:
299 Warning 1230 btr_estimate_n_rows_in_range(): 18
300 SELECT COUNT(*) FROM records_in_range_test WHERE c1 > 'ccc' AND c1 < 'zzz';
301 COUNT(*)
302 19
303 Warnings:
304 Warning 1230 btr_estimate_n_rows_in_range(): 19
305
306 SELECT COUNT(*) FROM records_in_range_test WHERE c1 > 'eee' AND c1 < 'bbb';
307 COUNT(*)
308 0
309 SELECT COUNT(*) FROM records_in_range_test WHERE c1 > 'eee' AND c1 < 'ccc';
310 COUNT(*)
311 0
312 SELECT COUNT(*) FROM records_in_range_test WHERE c1 > 'eee' AND c1 < 'eee';
313 COUNT(*)
314 0
315 SELECT COUNT(*) FROM records_in_range_test WHERE c1 > 'eee' AND c1 < 'mmm';
316 COUNT(*)
317 8
318 Warnings:
319 Warning 1230 btr_estimate_n_rows_in_range(): 8
320 SELECT COUNT(*) FROM records_in_range_test WHERE c1 > 'eee' AND c1 < 'nnn';
321 COUNT(*)
322 9
323 Warnings:
324 Warning 1230 btr_estimate_n_rows_in_range(): 9
325 SELECT COUNT(*) FROM records_in_range_test WHERE c1 > 'eee' AND c1 < 'qqq';
326 COUNT(*)
327 10
328 Warnings:
329 Warning 1230 btr_estimate_n_rows_in_range(): 10
330 SELECT COUNT(*) FROM records_in_range_test WHERE c1 > 'eee' AND c1 < 'xxx';
331 COUNT(*)
332 18
333 Warnings:
334 Warning 1230 btr_estimate_n_rows_in_range(): 18
335 SELECT COUNT(*) FROM records_in_range_test WHERE c1 > 'eee' AND c1 < 'zzz';
336 COUNT(*)
337 19
338 Warnings:
339 Warning 1230 btr_estimate_n_rows_in_range(): 19
340
341 SELECT COUNT(*) FROM records_in_range_test WHERE c1 > 'mmm' AND c1 < 'bbb';
342 COUNT(*)
343 0
344 SELECT COUNT(*) FROM records_in_range_test WHERE c1 > 'mmm' AND c1 < 'ccc';
345 COUNT(*)
346 0
347 SELECT COUNT(*) FROM records_in_range_test WHERE c1 > 'mmm' AND c1 < 'eee';
348 COUNT(*)
349 0
350 SELECT COUNT(*) FROM records_in_range_test WHERE c1 > 'mmm' AND c1 < 'mmm';
351 COUNT(*)
352 0
353 SELECT COUNT(*) FROM records_in_range_test WHERE c1 > 'mmm' AND c1 < 'nnn';
354 COUNT(*)
355 0
356 Warnings:
357 Warning 1230 btr_estimate_n_rows_in_range(): 0
358 SELECT COUNT(*) FROM records_in_range_test WHERE c1 > 'mmm' AND c1 < 'qqq';
359 COUNT(*)
360 1
361 Warnings:
362 Warning 1230 btr_estimate_n_rows_in_range(): 1
363 SELECT COUNT(*) FROM records_in_range_test WHERE c1 > 'mmm' AND c1 < 'xxx';
364 COUNT(*)
365 9
366 Warnings:
367 Warning 1230 btr_estimate_n_rows_in_range(): 9
368 SELECT COUNT(*) FROM records_in_range_test WHERE c1 > 'mmm' AND c1 < 'zzz';
369 COUNT(*)
370 10
371 Warnings:
372 Warning 1230 btr_estimate_n_rows_in_range(): 10
373
374 SELECT COUNT(*) FROM records_in_range_test WHERE c1 > 'nnn' AND c1 < 'bbb';
375 COUNT(*)
376 0
377 SELECT COUNT(*) FROM records_in_range_test WHERE c1 > 'nnn' AND c1 < 'ccc';
378 COUNT(*)
379 0
380 SELECT COUNT(*) FROM records_in_range_test WHERE c1 > 'nnn' AND c1 < 'eee';
381 COUNT(*)
382 0
383 SELECT COUNT(*) FROM records_in_range_test WHERE c1 > 'nnn' AND c1 < 'mmm';
384 COUNT(*)
385 0
386 SELECT COUNT(*) FROM records_in_range_test WHERE c1 > 'nnn' AND c1 < 'nnn';
387 COUNT(*)
388 0
389 SELECT COUNT(*) FROM records_in_range_test WHERE c1 > 'nnn' AND c1 < 'qqq';
390 COUNT(*)
391 0
392 Warnings:
393 Warning 1230 btr_estimate_n_rows_in_range(): 0
394 SELECT COUNT(*) FROM records_in_range_test WHERE c1 > 'nnn' AND c1 < 'xxx';
395 COUNT(*)
396 8
397 Warnings:
398 Warning 1230 btr_estimate_n_rows_in_range(): 8
399 SELECT COUNT(*) FROM records_in_range_test WHERE c1 > 'nnn' AND c1 < 'zzz';
400 COUNT(*)
401 9
402 Warnings:
403 Warning 1230 btr_estimate_n_rows_in_range(): 9
404
405 SELECT COUNT(*) FROM records_in_range_test WHERE c1 > 'qqq' AND c1 < 'bbb';
406 COUNT(*)
407 0
408 SELECT COUNT(*) FROM records_in_range_test WHERE c1 > 'qqq' AND c1 < 'ccc';
409 COUNT(*)
410 0
411 SELECT COUNT(*) FROM records_in_range_test WHERE c1 > 'qqq' AND c1 < 'eee';
412 COUNT(*)
413 0
414 SELECT COUNT(*) FROM records_in_range_test WHERE c1 > 'qqq' AND c1 < 'mmm';
415 COUNT(*)
416 0
417 SELECT COUNT(*) FROM records_in_range_test WHERE c1 > 'qqq' AND c1 < 'nnn';
418 COUNT(*)
419 0
420 SELECT COUNT(*) FROM records_in_range_test WHERE c1 > 'qqq' AND c1 < 'qqq';
421 COUNT(*)
422 0
423 SELECT COUNT(*) FROM records_in_range_test WHERE c1 > 'qqq' AND c1 < 'xxx';
424 COUNT(*)
425 8
426 Warnings:
427 Warning 1230 btr_estimate_n_rows_in_range(): 8
428 SELECT COUNT(*) FROM records_in_range_test WHERE c1 > 'qqq' AND c1 < 'zzz';
429 COUNT(*)
430 9
431 Warnings:
432 Warning 1230 btr_estimate_n_rows_in_range(): 9
433
434 SELECT COUNT(*) FROM records_in_range_test WHERE c1 > 'xxx' AND c1 < 'bbb';
435 COUNT(*)
436 0
437 SELECT COUNT(*) FROM records_in_range_test WHERE c1 > 'xxx' AND c1 < 'ccc';
438 COUNT(*)
439 0
440 SELECT COUNT(*) FROM records_in_range_test WHERE c1 > 'xxx' AND c1 < 'eee';
441 COUNT(*)
442 0
443 SELECT COUNT(*) FROM records_in_range_test WHERE c1 > 'xxx' AND c1 < 'mmm';
444 COUNT(*)
445 0
446 SELECT COUNT(*) FROM records_in_range_test WHERE c1 > 'xxx' AND c1 < 'nnn';
447 COUNT(*)
448 0
449 SELECT COUNT(*) FROM records_in_range_test WHERE c1 > 'xxx' AND c1 < 'qqq';
450 COUNT(*)
451 0
452 SELECT COUNT(*) FROM records_in_range_test WHERE c1 > 'xxx' AND c1 < 'xxx';
453 COUNT(*)
454 0
455 SELECT COUNT(*) FROM records_in_range_test WHERE c1 > 'xxx' AND c1 < 'zzz';
456 COUNT(*)
457 0
458 Warnings:
459 Warning 1230 btr_estimate_n_rows_in_range(): 0
460
461 SELECT COUNT(*) FROM records_in_range_test WHERE c1 > 'zzz' AND c1 < 'bbb';
462 COUNT(*)
463 0
464 SELECT COUNT(*) FROM records_in_range_test WHERE c1 > 'zzz' AND c1 < 'ccc';
465 COUNT(*)
466 0
467 SELECT COUNT(*) FROM records_in_range_test WHERE c1 > 'zzz' AND c1 < 'eee';
468 COUNT(*)
469 0
470 SELECT COUNT(*) FROM records_in_range_test WHERE c1 > 'zzz' AND c1 < 'mmm';
471 COUNT(*)
472 0
473 SELECT COUNT(*) FROM records_in_range_test WHERE c1 > 'zzz' AND c1 < 'nnn';
474 COUNT(*)
475 0
476 SELECT COUNT(*) FROM records_in_range_test WHERE c1 > 'zzz' AND c1 < 'qqq';
477 COUNT(*)
478 0
479 SELECT COUNT(*) FROM records_in_range_test WHERE c1 > 'zzz' AND c1 < 'xxx';
480 COUNT(*)
481 0
482 SELECT COUNT(*) FROM records_in_range_test WHERE c1 > 'zzz' AND c1 < 'zzz';
483 COUNT(*)
484 0
485
486 Test left-closed, right-open intervals
487 In some cases here the optimizer is smart enough not to call
488 ha_innobase::records_in_range() at all, so we get no warning containing
489 the value returned from btr_estimate_n_rows_in_range()
490
491 SELECT COUNT(*) FROM records_in_range_test WHERE c1 >= 'aaa' AND c1 < 'bbb';
492 COUNT(*)
493 0
494 Warnings:
495 Warning 1230 btr_estimate_n_rows_in_range(): 0
496 SELECT COUNT(*) FROM records_in_range_test WHERE c1 >= 'aaa' AND c1 < 'ccc';
497 COUNT(*)
498 0
499 Warnings:
500 Warning 1230 btr_estimate_n_rows_in_range(): 0
501 SELECT COUNT(*) FROM records_in_range_test WHERE c1 >= 'aaa' AND c1 < 'eee';
502 COUNT(*)
503 1
504 Warnings:
505 Warning 1230 btr_estimate_n_rows_in_range(): 1
506 SELECT COUNT(*) FROM records_in_range_test WHERE c1 >= 'aaa' AND c1 < 'mmm';
507 COUNT(*)
508 9
509 Warnings:
510 Warning 1230 btr_estimate_n_rows_in_range(): 9
511 SELECT COUNT(*) FROM records_in_range_test WHERE c1 >= 'aaa' AND c1 < 'nnn';
512 COUNT(*)
513 10
514 Warnings:
515 Warning 1230 btr_estimate_n_rows_in_range(): 10
516 SELECT COUNT(*) FROM records_in_range_test WHERE c1 >= 'aaa' AND c1 < 'qqq';
517 COUNT(*)
518 11
519 Warnings:
520 Warning 1230 btr_estimate_n_rows_in_range(): 11
521 SELECT COUNT(*) FROM records_in_range_test WHERE c1 >= 'aaa' AND c1 < 'xxx';
522 COUNT(*)
523 19
524 Warnings:
525 Warning 1230 btr_estimate_n_rows_in_range(): 19
526 SELECT COUNT(*) FROM records_in_range_test WHERE c1 >= 'aaa' AND c1 < 'zzz';
527 COUNT(*)
528 20
529 Warnings:
530 Warning 1230 btr_estimate_n_rows_in_range(): 20
531
532 SELECT COUNT(*) FROM records_in_range_test WHERE c1 >= 'ccc' AND c1 < 'bbb';
533 COUNT(*)
534 0
535 SELECT COUNT(*) FROM records_in_range_test WHERE c1 >= 'ccc' AND c1 < 'ccc';
536 COUNT(*)
537 0
538 SELECT COUNT(*) FROM records_in_range_test WHERE c1 >= 'ccc' AND c1 < 'eee';
539 COUNT(*)
540 1
541 Warnings:
542 Warning 1230 btr_estimate_n_rows_in_range(): 1
543 SELECT COUNT(*) FROM records_in_range_test WHERE c1 >= 'ccc' AND c1 < 'mmm';
544 COUNT(*)
545 9
546 Warnings:
547 Warning 1230 btr_estimate_n_rows_in_range(): 9
548 SELECT COUNT(*) FROM records_in_range_test WHERE c1 >= 'ccc' AND c1 < 'nnn';
549 COUNT(*)
550 10
551 Warnings:
552 Warning 1230 btr_estimate_n_rows_in_range(): 10
553 SELECT COUNT(*) FROM records_in_range_test WHERE c1 >= 'ccc' AND c1 < 'qqq';
554 COUNT(*)
555 11
556 Warnings:
557 Warning 1230 btr_estimate_n_rows_in_range(): 11
558 SELECT COUNT(*) FROM records_in_range_test WHERE c1 >= 'ccc' AND c1 < 'xxx';
559 COUNT(*)
560 19
561 Warnings:
562 Warning 1230 btr_estimate_n_rows_in_range(): 19
563 SELECT COUNT(*) FROM records_in_range_test WHERE c1 >= 'ccc' AND c1 < 'zzz';
564 COUNT(*)
565 20
566 Warnings:
567 Warning 1230 btr_estimate_n_rows_in_range(): 20
568
569 SELECT COUNT(*) FROM records_in_range_test WHERE c1 >= 'eee' AND c1 < 'bbb';
570 COUNT(*)
571 0
572 SELECT COUNT(*) FROM records_in_range_test WHERE c1 >= 'eee' AND c1 < 'ccc';
573 COUNT(*)
574 0
575 SELECT COUNT(*) FROM records_in_range_test WHERE c1 >= 'eee' AND c1 < 'eee';
576 COUNT(*)
577 0
578 SELECT COUNT(*) FROM records_in_range_test WHERE c1 >= 'eee' AND c1 < 'mmm';
579 COUNT(*)
580 8
581 Warnings:
582 Warning 1230 btr_estimate_n_rows_in_range(): 8
583 SELECT COUNT(*) FROM records_in_range_test WHERE c1 >= 'eee' AND c1 < 'nnn';
584 COUNT(*)
585 9
586 Warnings:
587 Warning 1230 btr_estimate_n_rows_in_range(): 9
588 SELECT COUNT(*) FROM records_in_range_test WHERE c1 >= 'eee' AND c1 < 'qqq';
589 COUNT(*)
590 10
591 Warnings:
592 Warning 1230 btr_estimate_n_rows_in_range(): 10
593 SELECT COUNT(*) FROM records_in_range_test WHERE c1 >= 'eee' AND c1 < 'xxx';
594 COUNT(*)
595 18
596 Warnings:
597 Warning 1230 btr_estimate_n_rows_in_range(): 18
598 SELECT COUNT(*) FROM records_in_range_test WHERE c1 >= 'eee' AND c1 < 'zzz';
599 COUNT(*)
600 19
601 Warnings:
602 Warning 1230 btr_estimate_n_rows_in_range(): 19
603
604 SELECT COUNT(*) FROM records_in_range_test WHERE c1 >= 'mmm' AND c1 < 'bbb';
605 COUNT(*)
606 0
607 SELECT COUNT(*) FROM records_in_range_test WHERE c1 >= 'mmm' AND c1 < 'ccc';
608 COUNT(*)
609 0
610 SELECT COUNT(*) FROM records_in_range_test WHERE c1 >= 'mmm' AND c1 < 'eee';
611 COUNT(*)
612 0
613 SELECT COUNT(*) FROM records_in_range_test WHERE c1 >= 'mmm' AND c1 < 'mmm';
614 COUNT(*)
615 0
616 SELECT COUNT(*) FROM records_in_range_test WHERE c1 >= 'mmm' AND c1 < 'nnn';
617 COUNT(*)
618 1
619 Warnings:
620 Warning 1230 btr_estimate_n_rows_in_range(): 1
621 SELECT COUNT(*) FROM records_in_range_test WHERE c1 >= 'mmm' AND c1 < 'qqq';
622 COUNT(*)
623 2
624 Warnings:
625 Warning 1230 btr_estimate_n_rows_in_range(): 2
626 SELECT COUNT(*) FROM records_in_range_test WHERE c1 >= 'mmm' AND c1 < 'xxx';
627 COUNT(*)
628 10
629 Warnings:
630 Warning 1230 btr_estimate_n_rows_in_range(): 10
631 SELECT COUNT(*) FROM records_in_range_test WHERE c1 >= 'mmm' AND c1 < 'zzz';
632 COUNT(*)
633 11
634 Warnings:
635 Warning 1230 btr_estimate_n_rows_in_range(): 11
636
637 SELECT COUNT(*) FROM records_in_range_test WHERE c1 >= 'nnn' AND c1 < 'bbb';
638 COUNT(*)
639 0
640 SELECT COUNT(*) FROM records_in_range_test WHERE c1 >= 'nnn' AND c1 < 'ccc';
641 COUNT(*)
642 0
643 SELECT COUNT(*) FROM records_in_range_test WHERE c1 >= 'nnn' AND c1 < 'eee';
644 COUNT(*)
645 0
646 SELECT COUNT(*) FROM records_in_range_test WHERE c1 >= 'nnn' AND c1 < 'mmm';
647 COUNT(*)
648 0
649 SELECT COUNT(*) FROM records_in_range_test WHERE c1 >= 'nnn' AND c1 < 'nnn';
650 COUNT(*)
651 0
652 SELECT COUNT(*) FROM records_in_range_test WHERE c1 >= 'nnn' AND c1 < 'qqq';
653 COUNT(*)
654 1
655 Warnings:
656 Warning 1230 btr_estimate_n_rows_in_range(): 1
657 SELECT COUNT(*) FROM records_in_range_test WHERE c1 >= 'nnn' AND c1 < 'xxx';
658 COUNT(*)
659 9
660 Warnings:
661 Warning 1230 btr_estimate_n_rows_in_range(): 9
662 SELECT COUNT(*) FROM records_in_range_test WHERE c1 >= 'nnn' AND c1 < 'zzz';
663 COUNT(*)
664 10
665 Warnings:
666 Warning 1230 btr_estimate_n_rows_in_range(): 10
667
668 SELECT COUNT(*) FROM records_in_range_test WHERE c1 >= 'qqq' AND c1 < 'bbb';
669 COUNT(*)
670 0
671 SELECT COUNT(*) FROM records_in_range_test WHERE c1 >= 'qqq' AND c1 < 'ccc';
672 COUNT(*)
673 0
674 SELECT COUNT(*) FROM records_in_range_test WHERE c1 >= 'qqq' AND c1 < 'eee';
675 COUNT(*)
676 0
677 SELECT COUNT(*) FROM records_in_range_test WHERE c1 >= 'qqq' AND c1 < 'mmm';
678 COUNT(*)
679 0
680 SELECT COUNT(*) FROM records_in_range_test WHERE c1 >= 'qqq' AND c1 < 'nnn';
681 COUNT(*)
682 0
683 SELECT COUNT(*) FROM records_in_range_test WHERE c1 >= 'qqq' AND c1 < 'qqq';
684 COUNT(*)
685 0
686 SELECT COUNT(*) FROM records_in_range_test WHERE c1 >= 'qqq' AND c1 < 'xxx';
687 COUNT(*)
688 8
689 Warnings:
690 Warning 1230 btr_estimate_n_rows_in_range(): 8
691 SELECT COUNT(*) FROM records_in_range_test WHERE c1 >= 'qqq' AND c1 < 'zzz';
692 COUNT(*)
693 9
694 Warnings:
695 Warning 1230 btr_estimate_n_rows_in_range(): 9
696
697 SELECT COUNT(*) FROM records_in_range_test WHERE c1 >= 'xxx' AND c1 < 'bbb';
698 COUNT(*)
699 0
700 SELECT COUNT(*) FROM records_in_range_test WHERE c1 >= 'xxx' AND c1 < 'ccc';
701 COUNT(*)
702 0
703 SELECT COUNT(*) FROM records_in_range_test WHERE c1 >= 'xxx' AND c1 < 'eee';
704 COUNT(*)
705 0
706 SELECT COUNT(*) FROM records_in_range_test WHERE c1 >= 'xxx' AND c1 < 'mmm';
707 COUNT(*)
708 0
709 SELECT COUNT(*) FROM records_in_range_test WHERE c1 >= 'xxx' AND c1 < 'nnn';
710 COUNT(*)
711 0
712 SELECT COUNT(*) FROM records_in_range_test WHERE c1 >= 'xxx' AND c1 < 'qqq';
713 COUNT(*)
714 0
715 SELECT COUNT(*) FROM records_in_range_test WHERE c1 >= 'xxx' AND c1 < 'xxx';
716 COUNT(*)
717 0
718 SELECT COUNT(*) FROM records_in_range_test WHERE c1 >= 'xxx' AND c1 < 'zzz';
719 COUNT(*)
720 1
721 Warnings:
722 Warning 1230 btr_estimate_n_rows_in_range(): 1
723
724 SELECT COUNT(*) FROM records_in_range_test WHERE c1 >= 'zzz' AND c1 < 'bbb';
725 COUNT(*)
726 0
727 SELECT COUNT(*) FROM records_in_range_test WHERE c1 >= 'zzz' AND c1 < 'ccc';
728 COUNT(*)
729 0
730 SELECT COUNT(*) FROM records_in_range_test WHERE c1 >= 'zzz' AND c1 < 'eee';
731 COUNT(*)
732 0
733 SELECT COUNT(*) FROM records_in_range_test WHERE c1 >= 'zzz' AND c1 < 'mmm';
734 COUNT(*)
735 0
736 SELECT COUNT(*) FROM records_in_range_test WHERE c1 >= 'zzz' AND c1 < 'nnn';
737 COUNT(*)
738 0
739 SELECT COUNT(*) FROM records_in_range_test WHERE c1 >= 'zzz' AND c1 < 'qqq';
740 COUNT(*)
741 0
742 SELECT COUNT(*) FROM records_in_range_test WHERE c1 >= 'zzz' AND c1 < 'xxx';
743 COUNT(*)
744 0
745 SELECT COUNT(*) FROM records_in_range_test WHERE c1 >= 'zzz' AND c1 < 'zzz';
746 COUNT(*)
747 0
748
749 Test left-open, right-closed intervals
750 In some cases here the optimizer is smart enough not to call
751 ha_innobase::records_in_range() at all, so we get no warning containing
752 the value returned from btr_estimate_n_rows_in_range()
753
754 SELECT COUNT(*) FROM records_in_range_test WHERE c1 > 'aaa' AND c1 <= 'bbb';
755 COUNT(*)
756 0
757 Warnings:
758 Warning 1230 btr_estimate_n_rows_in_range(): 0
759 SELECT COUNT(*) FROM records_in_range_test WHERE c1 > 'aaa' AND c1 <= 'ccc';
760 COUNT(*)
761 1
762 Warnings:
763 Warning 1230 btr_estimate_n_rows_in_range(): 1
764 SELECT COUNT(*) FROM records_in_range_test WHERE c1 > 'aaa' AND c1 <= 'eee';
765 COUNT(*)
766 1
767 Warnings:
768 Warning 1230 btr_estimate_n_rows_in_range(): 1
769 SELECT COUNT(*) FROM records_in_range_test WHERE c1 > 'aaa' AND c1 <= 'mmm';
770 COUNT(*)
771 10
772 Warnings:
773 Warning 1230 btr_estimate_n_rows_in_range(): 10
774 SELECT COUNT(*) FROM records_in_range_test WHERE c1 > 'aaa' AND c1 <= 'nnn';
775 COUNT(*)
776 11
777 Warnings:
778 Warning 1230 btr_estimate_n_rows_in_range(): 11
779 SELECT COUNT(*) FROM records_in_range_test WHERE c1 > 'aaa' AND c1 <= 'qqq';
780 COUNT(*)
781 11
782 Warnings:
783 Warning 1230 btr_estimate_n_rows_in_range(): 11
784 SELECT COUNT(*) FROM records_in_range_test WHERE c1 > 'aaa' AND c1 <= 'xxx';
785 COUNT(*)
786 20
787 Warnings:
788 Warning 1230 btr_estimate_n_rows_in_range(): 20
789 SELECT COUNT(*) FROM records_in_range_test WHERE c1 > 'aaa' AND c1 <= 'zzz';
790 COUNT(*)
791 20
792 Warnings:
793 Warning 1230 btr_estimate_n_rows_in_range(): 20
794
795 SELECT COUNT(*) FROM records_in_range_test WHERE c1 > 'ccc' AND c1 <= 'bbb';
796 COUNT(*)
797 0
798 SELECT COUNT(*) FROM records_in_range_test WHERE c1 > 'ccc' AND c1 <= 'ccc';
799 COUNT(*)
800 0
801 SELECT COUNT(*) FROM records_in_range_test WHERE c1 > 'ccc' AND c1 <= 'eee';
802 COUNT(*)
803 0
804 Warnings:
805 Warning 1230 btr_estimate_n_rows_in_range(): 0
806 SELECT COUNT(*) FROM records_in_range_test WHERE c1 > 'ccc' AND c1 <= 'mmm';
807 COUNT(*)
808 9
809 Warnings:
810 Warning 1230 btr_estimate_n_rows_in_range(): 9
811 SELECT COUNT(*) FROM records_in_range_test WHERE c1 > 'ccc' AND c1 <= 'nnn';
812 COUNT(*)
813 10
814 Warnings:
815 Warning 1230 btr_estimate_n_rows_in_range(): 10
816 SELECT COUNT(*) FROM records_in_range_test WHERE c1 > 'ccc' AND c1 <= 'qqq';
817 COUNT(*)
818 10
819 Warnings:
820 Warning 1230 btr_estimate_n_rows_in_range(): 10
821 SELECT COUNT(*) FROM records_in_range_test WHERE c1 > 'ccc' AND c1 <= 'xxx';
822 COUNT(*)
823 19
824 Warnings:
825 Warning 1230 btr_estimate_n_rows_in_range(): 19
826 SELECT COUNT(*) FROM records_in_range_test WHERE c1 > 'ccc' AND c1 <= 'zzz';
827 COUNT(*)
828 19
829 Warnings:
830 Warning 1230 btr_estimate_n_rows_in_range(): 19
831
832 SELECT COUNT(*) FROM records_in_range_test WHERE c1 > 'eee' AND c1 <= 'bbb';
833 COUNT(*)
834 0
835 SELECT COUNT(*) FROM records_in_range_test WHERE c1 > 'eee' AND c1 <= 'ccc';
836 COUNT(*)
837 0
838 SELECT COUNT(*) FROM records_in_range_test WHERE c1 > 'eee' AND c1 <= 'eee';
839 COUNT(*)
840 0
841 SELECT COUNT(*) FROM records_in_range_test WHERE c1 > 'eee' AND c1 <= 'mmm';
842 COUNT(*)
843 9
844 Warnings:
845 Warning 1230 btr_estimate_n_rows_in_range(): 9
846 SELECT COUNT(*) FROM records_in_range_test WHERE c1 > 'eee' AND c1 <= 'nnn';
847 COUNT(*)
848 10
849 Warnings:
850 Warning 1230 btr_estimate_n_rows_in_range(): 10
851 SELECT COUNT(*) FROM records_in_range_test WHERE c1 > 'eee' AND c1 <= 'qqq';
852 COUNT(*)
853 10
854 Warnings:
855 Warning 1230 btr_estimate_n_rows_in_range(): 10
856 SELECT COUNT(*) FROM records_in_range_test WHERE c1 > 'eee' AND c1 <= 'xxx';
857 COUNT(*)
858 19
859 Warnings:
860 Warning 1230 btr_estimate_n_rows_in_range(): 19
861 SELECT COUNT(*) FROM records_in_range_test WHERE c1 > 'eee' AND c1 <= 'zzz';
862 COUNT(*)
863 19
864 Warnings:
865 Warning 1230 btr_estimate_n_rows_in_range(): 19
866
867 SELECT COUNT(*) FROM records_in_range_test WHERE c1 > 'mmm' AND c1 <= 'bbb';
868 COUNT(*)
869 0
870 SELECT COUNT(*) FROM records_in_range_test WHERE c1 > 'mmm' AND c1 <= 'ccc';
871 COUNT(*)
872 0
873 SELECT COUNT(*) FROM records_in_range_test WHERE c1 > 'mmm' AND c1 <= 'eee';
874 COUNT(*)
875 0
876 SELECT COUNT(*) FROM records_in_range_test WHERE c1 > 'mmm' AND c1 <= 'mmm';
877 COUNT(*)
878 0
879 SELECT COUNT(*) FROM records_in_range_test WHERE c1 > 'mmm' AND c1 <= 'nnn';
880 COUNT(*)
881 1
882 Warnings:
883 Warning 1230 btr_estimate_n_rows_in_range(): 1
884 SELECT COUNT(*) FROM records_in_range_test WHERE c1 > 'mmm' AND c1 <= 'qqq';
885 COUNT(*)
886 1
887 Warnings:
888 Warning 1230 btr_estimate_n_rows_in_range(): 1
889 SELECT COUNT(*) FROM records_in_range_test WHERE c1 > 'mmm' AND c1 <= 'xxx';
890 COUNT(*)
891 10
892 Warnings:
893 Warning 1230 btr_estimate_n_rows_in_range(): 10
894 SELECT COUNT(*) FROM records_in_range_test WHERE c1 > 'mmm' AND c1 <= 'zzz';
895 COUNT(*)
896 10
897 Warnings:
898 Warning 1230 btr_estimate_n_rows_in_range(): 10
899
900 SELECT COUNT(*) FROM records_in_range_test WHERE c1 > 'nnn' AND c1 <= 'bbb';
901 COUNT(*)
902 0
903 SELECT COUNT(*) FROM records_in_range_test WHERE c1 > 'nnn' AND c1 <= 'ccc';
904 COUNT(*)
905 0
906 SELECT COUNT(*) FROM records_in_range_test WHERE c1 > 'nnn' AND c1 <= 'eee';
907 COUNT(*)
908 0
909 SELECT COUNT(*) FROM records_in_range_test WHERE c1 > 'nnn' AND c1 <= 'mmm';
910 COUNT(*)
911 0
912 SELECT COUNT(*) FROM records_in_range_test WHERE c1 > 'nnn' AND c1 <= 'nnn';
913 COUNT(*)
914 0
915 SELECT COUNT(*) FROM records_in_range_test WHERE c1 > 'nnn' AND c1 <= 'qqq';
916 COUNT(*)
917 0
918 Warnings:
919 Warning 1230 btr_estimate_n_rows_in_range(): 0
920 SELECT COUNT(*) FROM records_in_range_test WHERE c1 > 'nnn' AND c1 <= 'xxx';
921 COUNT(*)
922 9
923 Warnings:
924 Warning 1230 btr_estimate_n_rows_in_range(): 9
925 SELECT COUNT(*) FROM records_in_range_test WHERE c1 > 'nnn' AND c1 <= 'zzz';
926 COUNT(*)
927 9
928 Warnings:
929 Warning 1230 btr_estimate_n_rows_in_range(): 9
930
931 SELECT COUNT(*) FROM records_in_range_test WHERE c1 > 'qqq' AND c1 <= 'bbb';
932 COUNT(*)
933 0
934 SELECT COUNT(*) FROM records_in_range_test WHERE c1 > 'qqq' AND c1 <= 'ccc';
935 COUNT(*)
936 0
937 SELECT COUNT(*) FROM records_in_range_test WHERE c1 > 'qqq' AND c1 <= 'eee';
938 COUNT(*)
939 0
940 SELECT COUNT(*) FROM records_in_range_test WHERE c1 > 'qqq' AND c1 <= 'mmm';
941 COUNT(*)
942 0
943 SELECT COUNT(*) FROM records_in_range_test WHERE c1 > 'qqq' AND c1 <= 'nnn';
944 COUNT(*)
945 0
946 SELECT COUNT(*) FROM records_in_range_test WHERE c1 > 'qqq' AND c1 <= 'qqq';
947 COUNT(*)
948 0
949 SELECT COUNT(*) FROM records_in_range_test WHERE c1 > 'qqq' AND c1 <= 'xxx';
950 COUNT(*)
951 9
952 Warnings:
953 Warning 1230 btr_estimate_n_rows_in_range(): 9
954 SELECT COUNT(*) FROM records_in_range_test WHERE c1 > 'qqq' AND c1 <= 'zzz';
955 COUNT(*)
956 9
957 Warnings:
958 Warning 1230 btr_estimate_n_rows_in_range(): 9
959
960 SELECT COUNT(*) FROM records_in_range_test WHERE c1 > 'xxx' AND c1 <= 'bbb';
961 COUNT(*)
962 0
963 SELECT COUNT(*) FROM records_in_range_test WHERE c1 > 'xxx' AND c1 <= 'ccc';
964 COUNT(*)
965 0
966 SELECT COUNT(*) FROM records_in_range_test WHERE c1 > 'xxx' AND c1 <= 'eee';
967 COUNT(*)
968 0
969 SELECT COUNT(*) FROM records_in_range_test WHERE c1 > 'xxx' AND c1 <= 'mmm';
970 COUNT(*)
971 0
972 SELECT COUNT(*) FROM records_in_range_test WHERE c1 > 'xxx' AND c1 <= 'nnn';
973 COUNT(*)
974 0
975 SELECT COUNT(*) FROM records_in_range_test WHERE c1 > 'xxx' AND c1 <= 'qqq';
976 COUNT(*)
977 0
978 SELECT COUNT(*) FROM records_in_range_test WHERE c1 > 'xxx' AND c1 <= 'xxx';
979 COUNT(*)
980 0
981 SELECT COUNT(*) FROM records_in_range_test WHERE c1 > 'xxx' AND c1 <= 'zzz';
982 COUNT(*)
983 0
984 Warnings:
985 Warning 1230 btr_estimate_n_rows_in_range(): 0
986
987 SELECT COUNT(*) FROM records_in_range_test WHERE c1 > 'zzz' AND c1 <= 'bbb';
988 COUNT(*)
989 0
990 SELECT COUNT(*) FROM records_in_range_test WHERE c1 > 'zzz' AND c1 <= 'ccc';
991 COUNT(*)
992 0
993 SELECT COUNT(*) FROM records_in_range_test WHERE c1 > 'zzz' AND c1 <= 'eee';
994 COUNT(*)
995 0
996 SELECT COUNT(*) FROM records_in_range_test WHERE c1 > 'zzz' AND c1 <= 'mmm';
997 COUNT(*)
998 0
999 SELECT COUNT(*) FROM records_in_range_test WHERE c1 > 'zzz' AND c1 <= 'nnn';
1000 COUNT(*)
1001 0
1002 SELECT COUNT(*) FROM records_in_range_test WHERE c1 > 'zzz' AND c1 <= 'qqq';
1003 COUNT(*)
1004 0
1005 SELECT COUNT(*) FROM records_in_range_test WHERE c1 > 'zzz' AND c1 <= 'xxx';
1006 COUNT(*)
1007 0
1008 SELECT COUNT(*) FROM records_in_range_test WHERE c1 > 'zzz' AND c1 <= 'zzz';
1009 COUNT(*)
1010 0
1011
1012 Test left-closed, right-closed intervals
1013 In some cases here the optimizer is smart enough not to call
1014 ha_innobase::records_in_range() at all, so we get no warning containing
1015 the value returned from btr_estimate_n_rows_in_range()
1016
1017 SELECT COUNT(*) FROM records_in_range_test WHERE c1 >= 'aaa' AND c1 <= 'bbb';
1018 COUNT(*)
1019 0
1020 Warnings:
1021 Warning 1230 btr_estimate_n_rows_in_range(): 0
1022 SELECT COUNT(*) FROM records_in_range_test WHERE c1 >= 'aaa' AND c1 <= 'ccc';
1023 COUNT(*)
1024 1
1025 Warnings:
1026 Warning 1230 btr_estimate_n_rows_in_range(): 1
1027 SELECT COUNT(*) FROM records_in_range_test WHERE c1 >= 'aaa' AND c1 <= 'eee';
1028 COUNT(*)
1029 1
1030 Warnings:
1031 Warning 1230 btr_estimate_n_rows_in_range(): 1
1032 SELECT COUNT(*) FROM records_in_range_test WHERE c1 >= 'aaa' AND c1 <= 'mmm';
1033 COUNT(*)
1034 10
1035 Warnings:
1036 Warning 1230 btr_estimate_n_rows_in_range(): 10
1037 SELECT COUNT(*) FROM records_in_range_test WHERE c1 >= 'aaa' AND c1 <= 'nnn';
1038 COUNT(*)
1039 11
1040 Warnings:
1041 Warning 1230 btr_estimate_n_rows_in_range(): 11
1042 SELECT COUNT(*) FROM records_in_range_test WHERE c1 >= 'aaa' AND c1 <= 'qqq';
1043 COUNT(*)
1044 11
1045 Warnings:
1046 Warning 1230 btr_estimate_n_rows_in_range(): 11
1047 SELECT COUNT(*) FROM records_in_range_test WHERE c1 >= 'aaa' AND c1 <= 'xxx';
1048 COUNT(*)
1049 20
1050 Warnings:
1051 Warning 1230 btr_estimate_n_rows_in_range(): 20
1052 SELECT COUNT(*) FROM records_in_range_test WHERE c1 >= 'aaa' AND c1 <= 'zzz';
1053 COUNT(*)
1054 20
1055 Warnings:
1056 Warning 1230 btr_estimate_n_rows_in_range(): 20
1057
1058 SELECT COUNT(*) FROM records_in_range_test WHERE c1 >= 'ccc' AND c1 <= 'bbb';
1059 COUNT(*)
1060 0
1061 SELECT COUNT(*) FROM records_in_range_test WHERE c1 >= 'ccc' AND c1 <= 'ccc';
1062 COUNT(*)
1063 1
1064 SELECT COUNT(*) FROM records_in_range_test WHERE c1 >= 'ccc' AND c1 <= 'eee';
1065 COUNT(*)
1066 1
1067 Warnings:
1068 Warning 1230 btr_estimate_n_rows_in_range(): 1
1069 SELECT COUNT(*) FROM records_in_range_test WHERE c1 >= 'ccc' AND c1 <= 'mmm';
1070 COUNT(*)
1071 10
1072 Warnings:
1073 Warning 1230 btr_estimate_n_rows_in_range(): 10
1074 SELECT COUNT(*) FROM records_in_range_test WHERE c1 >= 'ccc' AND c1 <= 'nnn';
1075 COUNT(*)
1076 11
1077 Warnings:
1078 Warning 1230 btr_estimate_n_rows_in_range(): 11
1079 SELECT COUNT(*) FROM records_in_range_test WHERE c1 >= 'ccc' AND c1 <= 'qqq';
1080 COUNT(*)
1081 11
1082 Warnings:
1083 Warning 1230 btr_estimate_n_rows_in_range(): 11
1084 SELECT COUNT(*) FROM records_in_range_test WHERE c1 >= 'ccc' AND c1 <= 'xxx';
1085 COUNT(*)
1086 20
1087 Warnings:
1088 Warning 1230 btr_estimate_n_rows_in_range(): 20
1089 SELECT COUNT(*) FROM records_in_range_test WHERE c1 >= 'ccc' AND c1 <= 'zzz';
1090 COUNT(*)
1091 20
1092 Warnings:
1093 Warning 1230 btr_estimate_n_rows_in_range(): 20
1094
1095 SELECT COUNT(*) FROM records_in_range_test WHERE c1 >= 'eee' AND c1 <= 'bbb';
1096 COUNT(*)
1097 0
1098 SELECT COUNT(*) FROM records_in_range_test WHERE c1 >= 'eee' AND c1 <= 'ccc';
1099 COUNT(*)
1100 0
1101 SELECT COUNT(*) FROM records_in_range_test WHERE c1 >= 'eee' AND c1 <= 'eee';
1102 COUNT(*)
1103 0
1104 SELECT COUNT(*) FROM records_in_range_test WHERE c1 >= 'eee' AND c1 <= 'mmm';
1105 COUNT(*)
1106 9
1107 Warnings:
1108 Warning 1230 btr_estimate_n_rows_in_range(): 9
1109 SELECT COUNT(*) FROM records_in_range_test WHERE c1 >= 'eee' AND c1 <= 'nnn';
1110 COUNT(*)
1111 10
1112 Warnings:
1113 Warning 1230 btr_estimate_n_rows_in_range(): 10
1114 SELECT COUNT(*) FROM records_in_range_test WHERE c1 >= 'eee' AND c1 <= 'qqq';
1115 COUNT(*)
1116 10
1117 Warnings:
1118 Warning 1230 btr_estimate_n_rows_in_range(): 10
1119 SELECT COUNT(*) FROM records_in_range_test WHERE c1 >= 'eee' AND c1 <= 'xxx';
1120 COUNT(*)
1121 19
1122 Warnings:
1123 Warning 1230 btr_estimate_n_rows_in_range(): 19
1124 SELECT COUNT(*) FROM records_in_range_test WHERE c1 >= 'eee' AND c1 <= 'zzz';
1125 COUNT(*)
1126 19
1127 Warnings:
1128 Warning 1230 btr_estimate_n_rows_in_range(): 19
1129
1130 SELECT COUNT(*) FROM records_in_range_test WHERE c1 >= 'mmm' AND c1 <= 'bbb';
1131 COUNT(*)
1132 0
1133 SELECT COUNT(*) FROM records_in_range_test WHERE c1 >= 'mmm' AND c1 <= 'ccc';
1134 COUNT(*)
1135 0
1136 SELECT COUNT(*) FROM records_in_range_test WHERE c1 >= 'mmm' AND c1 <= 'eee';
1137 COUNT(*)
1138 0
1139 SELECT COUNT(*) FROM records_in_range_test WHERE c1 >= 'mmm' AND c1 <= 'mmm';
1140 COUNT(*)
1141 1
1142 SELECT COUNT(*) FROM records_in_range_test WHERE c1 >= 'mmm' AND c1 <= 'nnn';
1143 COUNT(*)
1144 2
1145 Warnings:
1146 Warning 1230 btr_estimate_n_rows_in_range(): 2
1147 SELECT COUNT(*) FROM records_in_range_test WHERE c1 >= 'mmm' AND c1 <= 'qqq';
1148 COUNT(*)
1149 2
1150 Warnings:
1151 Warning 1230 btr_estimate_n_rows_in_range(): 2
1152 SELECT COUNT(*) FROM records_in_range_test WHERE c1 >= 'mmm' AND c1 <= 'xxx';
1153 COUNT(*)
1154 11
1155 Warnings:
1156 Warning 1230 btr_estimate_n_rows_in_range(): 11
1157 SELECT COUNT(*) FROM records_in_range_test WHERE c1 >= 'mmm' AND c1 <= 'zzz';
1158 COUNT(*)
1159 11
1160 Warnings:
1161 Warning 1230 btr_estimate_n_rows_in_range(): 11
1162
1163 SELECT COUNT(*) FROM records_in_range_test WHERE c1 >= 'nnn' AND c1 <= 'bbb';
1164 COUNT(*)
1165 0
1166 SELECT COUNT(*) FROM records_in_range_test WHERE c1 >= 'nnn' AND c1 <= 'ccc';
1167 COUNT(*)
1168 0
1169 SELECT COUNT(*) FROM records_in_range_test WHERE c1 >= 'nnn' AND c1 <= 'eee';
1170 COUNT(*)
1171 0
1172 SELECT COUNT(*) FROM records_in_range_test WHERE c1 >= 'nnn' AND c1 <= 'mmm';
1173 COUNT(*)
1174 0
1175 SELECT COUNT(*) FROM records_in_range_test WHERE c1 >= 'nnn' AND c1 <= 'nnn';
1176 COUNT(*)
1177 1
1178 SELECT COUNT(*) FROM records_in_range_test WHERE c1 >= 'nnn' AND c1 <= 'qqq';
1179 COUNT(*)
1180 1
1181 Warnings:
1182 Warning 1230 btr_estimate_n_rows_in_range(): 1
1183 SELECT COUNT(*) FROM records_in_range_test WHERE c1 >= 'nnn' AND c1 <= 'xxx';
1184 COUNT(*)
1185 10
1186 Warnings:
1187 Warning 1230 btr_estimate_n_rows_in_range(): 10
1188 SELECT COUNT(*) FROM records_in_range_test WHERE c1 >= 'nnn' AND c1 <= 'zzz';
1189 COUNT(*)
1190 10
1191 Warnings:
1192 Warning 1230 btr_estimate_n_rows_in_range(): 10
1193
1194 SELECT COUNT(*) FROM records_in_range_test WHERE c1 >= 'qqq' AND c1 <= 'bbb';
1195 COUNT(*)
1196 0
1197 SELECT COUNT(*) FROM records_in_range_test WHERE c1 >= 'qqq' AND c1 <= 'ccc';
1198 COUNT(*)
1199 0
1200 SELECT COUNT(*) FROM records_in_range_test WHERE c1 >= 'qqq' AND c1 <= 'eee';
1201 COUNT(*)
1202 0
1203 SELECT COUNT(*) FROM records_in_range_test WHERE c1 >= 'qqq' AND c1 <= 'mmm';
1204 COUNT(*)
1205 0
1206 SELECT COUNT(*) FROM records_in_range_test WHERE c1 >= 'qqq' AND c1 <= 'nnn';
1207 COUNT(*)
1208 0
1209 SELECT COUNT(*) FROM records_in_range_test WHERE c1 >= 'qqq' AND c1 <= 'qqq';
1210 COUNT(*)
1211 0
1212 SELECT COUNT(*) FROM records_in_range_test WHERE c1 >= 'qqq' AND c1 <= 'xxx';
1213 COUNT(*)
1214 9
1215 Warnings:
1216 Warning 1230 btr_estimate_n_rows_in_range(): 9
1217 SELECT COUNT(*) FROM records_in_range_test WHERE c1 >= 'qqq' AND c1 <= 'zzz';
1218 COUNT(*)
1219 9
1220 Warnings:
1221 Warning 1230 btr_estimate_n_rows_in_range(): 9
1222
1223 SELECT COUNT(*) FROM records_in_range_test WHERE c1 >= 'xxx' AND c1 <= 'bbb';
1224 COUNT(*)
1225 0
1226 SELECT COUNT(*) FROM records_in_range_test WHERE c1 >= 'xxx' AND c1 <= 'ccc';
1227 COUNT(*)
1228 0
1229 SELECT COUNT(*) FROM records_in_range_test WHERE c1 >= 'xxx' AND c1 <= 'eee';
1230 COUNT(*)
1231 0
1232 SELECT COUNT(*) FROM records_in_range_test WHERE c1 >= 'xxx' AND c1 <= 'mmm';
1233 COUNT(*)
1234 0
1235 SELECT COUNT(*) FROM records_in_range_test WHERE c1 >= 'xxx' AND c1 <= 'nnn';
1236 COUNT(*)
1237 0
1238 SELECT COUNT(*) FROM records_in_range_test WHERE c1 >= 'xxx' AND c1 <= 'qqq';
1239 COUNT(*)
1240 0
1241 SELECT COUNT(*) FROM records_in_range_test WHERE c1 >= 'xxx' AND c1 <= 'xxx';
1242 COUNT(*)
1243 1
1244 SELECT COUNT(*) FROM records_in_range_test WHERE c1 >= 'xxx' AND c1 <= 'zzz';
1245 COUNT(*)
1246 1
1247 Warnings:
1248 Warning 1230 btr_estimate_n_rows_in_range(): 1
1249
1250 SELECT COUNT(*) FROM records_in_range_test WHERE c1 >= 'zzz' AND c1 <= 'bbb';
1251 COUNT(*)
1252 0
1253 SELECT COUNT(*) FROM records_in_range_test WHERE c1 >= 'zzz' AND c1 <= 'ccc';
1254 COUNT(*)
1255 0
1256 SELECT COUNT(*) FROM records_in_range_test WHERE c1 >= 'zzz' AND c1 <= 'eee';
1257 COUNT(*)
1258 0
1259 SELECT COUNT(*) FROM records_in_range_test WHERE c1 >= 'zzz' AND c1 <= 'mmm';
1260 COUNT(*)
1261 0
1262 SELECT COUNT(*) FROM records_in_range_test WHERE c1 >= 'zzz' AND c1 <= 'nnn';
1263 COUNT(*)
1264 0
1265 SELECT COUNT(*) FROM records_in_range_test WHERE c1 >= 'zzz' AND c1 <= 'qqq';
1266 COUNT(*)
1267 0
1268 SELECT COUNT(*) FROM records_in_range_test WHERE c1 >= 'zzz' AND c1 <= 'xxx';
1269 COUNT(*)
1270 0
1271 SELECT COUNT(*) FROM records_in_range_test WHERE c1 >= 'zzz' AND c1 <= 'zzz';
1272 COUNT(*)
1273 0
1274 SET DEBUG_DBUG = @save_dbug;
1275 DROP TABLE records_in_range_test;