You can not select more than 25 topics
Topics must start with a letter or number, can include dashes ('-') and can be up to 35 characters long.
13 lines
379 B
13 lines
379 B
--source include/force_myisam_default.inc
|
|
--source include/have_myisam.inc
|
|
|
|
--echo #
|
|
--echo # Bug #11747810: EXPLAIN SHOWS BOGUS VALUE FOR
|
|
--echo # 'FILTERED' COLUMN FOR LIMIT QUERY
|
|
--echo #
|
|
|
|
CREATE TABLE t1 (a INT, KEY (a)) ENGINE=Myisam;
|
|
INSERT INTO t1 VALUES (0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
|
|
EXPLAIN SELECT * FROM t1 ORDER BY a LIMIT 1;
|
|
DROP TABLE t1;
|
|
|
|
|