Comment 1 for bug 622458
Revision history for this message
| Hartmut Holzgraefe (hartmut-php) wrote | #1 |
© 2004
Canonical Ltd.
•
Terms of use
•
Data privacy
•
Contact Launchpad Support
•
Blog
•
Careers
•
System status
•
1b1ed1a
(Get the code!)
How to reproduce
DROP TABLE IF EXISTS t1;
CREATE TABLE `t1` (
`id` INT NOT NULL AUTO_INCREMENT,
`totalhits` INT DEFAULT NULL,
PRIMARY KEY (`id`)
);
INSERT INTO t1 SELECT NULL, 0;
INSERT INTO t1 SELECT NULL, 0 FROM t1;
INSERT INTO t1 SELECT NULL, 0 FROM t1;
INSERT INTO t1 SELECT NULL, 0 FROM t1;
INSERT INTO t1 SELECT NULL, 0 FROM t1;
INSERT INTO t1 SELECT NULL, 0 FROM t1;
INSERT INTO t1 SELECT NULL, 0 FROM t1;
INSERT INTO t1 SELECT NULL, 0 FROM t1;
INSERT INTO t1 SELECT NULL, 0 FROM t1;
INSERT INTO t1 SELECT NULL, 0 FROM t1;
INSERT INTO t1 SELECT NULL, 0 FROM t1;
EXPLAIN SELECT * FROM t1 WHERE id IN (1,2);
EXPLAIN SELECT * FROM t1 WHERE id IN ('1','2');
EXPLAIN SELECT * FROM t1 WHERE id IN (1,'2');
last explain shows a full table scan while the other two are using in index as expected