diff options
Diffstat (limited to 'mysql-test/main/range_vs_index_merge.test')
| -rw-r--r-- | mysql-test/main/range_vs_index_merge.test | 12 |
1 files changed, 7 insertions, 5 deletions
diff --git a/mysql-test/main/range_vs_index_merge.test b/mysql-test/main/range_vs_index_merge.test index a8e86e44b9e..3f8427e7bf6 100644 --- a/mysql-test/main/range_vs_index_merge.test +++ b/mysql-test/main/range_vs_index_merge.test @@ -1172,9 +1172,9 @@ SELECT * FROM t1,t2,t3 DROP TABLE t1,t2,t3; -# -# LP bug #823301: index merge sort union with possible index scan -# +--echo # +--echo # LP bug #823301: index merge sort union with possible index scan +--echo # CREATE TABLE t1 ( a int, b int, c int, d int, @@ -1190,12 +1190,14 @@ SET SESSION optimizer_switch='index_merge_sort_union=off'; EXPLAIN SELECT * FROM t1 WHERE t1.b>7 AND t1.d>1 AND t1.d<>8 OR t1.d>=7 AND t1.d<8 OR t1.d>7; +--sorted_result SELECT * FROM t1 WHERE t1.b>7 AND t1.d>1 AND t1.d<>8 OR t1.d>=7 AND t1.d<8 OR t1.d>7; SET SESSION optimizer_switch='index_merge_sort_union=on'; EXPLAIN SELECT * FROM t1 WHERE t1.b>7 AND t1.d>1 AND t1.d<>8 OR t1.d>=7 AND t1.d<8 OR t1.d>7; +--sorted_result SELECT * FROM t1 WHERE t1.b>7 AND t1.d>1 AND t1.d<>8 OR t1.d>=7 AND t1.d<8 OR t1.d>7; SET SESSION optimizer_switch=DEFAULT; @@ -1318,9 +1320,9 @@ where Country='NOR' AND Name IN ('Oslo', 'Bergen') OR Country='ITA' AND Name IN ('Napoli', 'Venezia'); -eval $q; eval explain $q; - +--sorted_result +eval $q; DROP DATABASE world; |