846
846
select sum(count) from t2 ch where ch.defid in (50,52) and ch.day between 20070320 and 20070401 group by defid;
847
847
drop table t1, t2;
851
--echo # Bug#50939: Loose Index Scan unduly relies on engine to remember range
858
) PARTITION BY HASH (a) PARTITIONS 1;
866
INSERT INTO t1 VALUES (1, 1), (2, 2), (3, 3), (4, 4), (5, 5);
868
INSERT INTO t1 SELECT a + 5, b + 5 FROM t1;
869
INSERT INTO t1 SELECT a + 10, b + 10 FROM t1;
870
INSERT INTO t1 SELECT a + 20, b + 20 FROM t1;
871
INSERT INTO t1 SELECT a + 40, b + 40 FROM t1;
873
INSERT INTO t2 SELECT * FROM t1;
875
--echo # plans should be identical
876
EXPLAIN SELECT a, MAX(b) FROM t1 WHERE a IN (10,100) GROUP BY a;
877
EXPLAIN SELECT a, MAX(b) FROM t2 WHERE a IN (10,100) GROUP BY a;
880
SELECT a, MAX(b) FROM t1 WHERE a IN (10, 100) GROUP BY a;
881
--echo # Should be no more than 4 reads.
882
SHOW status LIKE 'handler_read_key';
885
SELECT a, MAX(b) FROM t2 WHERE a IN (10, 100) GROUP BY a;
886
--echo # Should be no more than 4 reads.
887
SHOW status LIKE 'handler_read_key';