Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Not a Bug
-
10.0.7
-
None
-
None
Description
Populate a sysbench table
handler `test`.`sbtest` open as t00000; |
handler t00000 read `PRIMARY` >= (4995723) where `id` >= 4995723 and `id` <= 4995822 and (`id` between 4995723 and 4995822) limit 2; |
+---------+---+---+----------------------------------------------------+ |
| id | k | c | pad |
|
+---------+---+---+----------------------------------------------------+ |
| 4995723 | 0 | | qqqqqqqqqqwwwwwwwwwweeeeeeeeeerrrrrrrrrrtttttttttt |
|
| 4995724 | 0 | | qqqqqqqqqqwwwwwwwwwweeeeeeeeeerrrrrrrrrrtttttttttt |
|
+---------+---+---+----------------------------------------------------+ |
2 rows in set (0,00 sec) |
 |
handler t00000 read `PRIMARY` next where `id` >= 4995723 and `id` <= 4995822 and (`id` between 4995723 and 4995822) limit 100; |
[1/28/14 10:31:50 AM] svaroqui: | 4995822 | 0 | | qqqqqqqqqqwwwwwwwwwweeeeeeeeeerrrrrrrrrrtttttttttt |
|
+---------+---+---+----------------------------------------------------+ |
98 rows in set (7,89 sec) |
| Handler_read_next | 5004278 |
|