diff options
Diffstat (limited to 'mysql-test/main/order_by.test')
| -rw-r--r-- | mysql-test/main/order_by.test | 17 |
1 files changed, 3 insertions, 14 deletions
diff --git a/mysql-test/main/order_by.test b/mysql-test/main/order_by.test index 24c90a62041..c336a6784a5 100644 --- a/mysql-test/main/order_by.test +++ b/mysql-test/main/order_by.test @@ -922,17 +922,6 @@ SELECT 1 AS col FROM t1 WHERE a=2 AND (c=10 OR c IS NULL) ORDER BY c; --echo # Must return 1 row SELECT 1 AS col FROM t1 WHERE a=2 AND (c=10 OR c IS NULL) ORDER BY c; ---echo # With more rows "filesort" is removed -INSERT INTO t1 select seq,seq from seq_1_to_2; -EXPLAIN -SELECT 1 AS col FROM t1 WHERE a=2 AND (c=10 OR c IS NULL) ORDER BY c; -SELECT 1 AS col FROM t1 WHERE a=2 AND (c=10 OR c IS NULL) ORDER BY c; - ---echo # With more rows "range" changes to "ref_or_null" -INSERT INTO t1 select seq,seq from seq_3_to_10; -EXPLAIN -SELECT 1 AS col FROM t1 WHERE a=2 AND (c=10 OR c IS NULL) ORDER BY c; - # part 2 of the problem : DESC test cases --echo # Must use ref-or-null on the a_c index --replace_column 1 x 2 x 3 x 6 x 7 x 8 x 9 x 10 x @@ -2409,7 +2398,7 @@ let $query= select t2.key1 = t1.a and t2.key1 IS NOT NULL ORDER BY t2.key2 ASC - LIMIT 1) + LIMIT 1) as "con" from t1; --echo # here type should show ref not index @@ -2692,8 +2681,8 @@ CREATE TABLE t2 (a INT, b INT); INSERT INTO t1 (a,b) VALUES (58,1),(96,2),(273,3),(23,4),(231,5),(525,6), (2354,7),(321421,3),(535,2),(4535,3); -INSERT INTO t2 (a,b) VALUES (58,3),(96,3),(273,3),(1000,1000),(2000,2000); - +INSERT INTO t2 (a,b) VALUES (58,3),(96,3),(273,3),(1000,1000),(2000,2000),(3000,3000); +INSERT INTO t2 select seq,seq from seq_10_to_100; --echo # Join order should have the SJM scan table as the first table for both --echo # the queries with GROUP BY and ORDER BY clause. |