1317
--echo # Bug#50939: Loose Index Scan unduly relies on engine to remember range
1324
) PARTITION BY HASH (a) PARTITIONS 1;
1332
INSERT INTO t1 VALUES (1, 1), (2, 2), (3, 3), (4, 4), (5, 5);
1334
INSERT INTO t1 SELECT a + 5, b + 5 FROM t1;
1335
INSERT INTO t1 SELECT a + 10, b + 10 FROM t1;
1336
INSERT INTO t1 SELECT a + 20, b + 20 FROM t1;
1337
INSERT INTO t1 SELECT a + 40, b + 40 FROM t1;
1339
INSERT INTO t2 SELECT * FROM t1;
1341
--echo # plans should be identical
1342
EXPLAIN SELECT a, MAX(b) FROM t1 WHERE a IN (10,100) GROUP BY a;
1343
EXPLAIN SELECT a, MAX(b) FROM t2 WHERE a IN (10,100) GROUP BY a;
1346
SELECT a, MAX(b) FROM t1 WHERE a IN (10, 100) GROUP BY a;
1347
--echo # Should be no more than 4 reads.
1348
SHOW status LIKE 'handler_read_key';
1351
SELECT a, MAX(b) FROM t2 WHERE a IN (10, 100) GROUP BY a;
1352
--echo # Should be no more than 4 reads.
1353
SHOW status LIKE 'handler_read_key';
1316
1357
--echo End of 5.1 tests