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