diff options
| author | Monty <monty@mariadb.org> | 2022-10-04 16:16:06 +0300 |
|---|---|---|
| committer | Monty <monty@mariadb.org> | 2022-10-04 21:46:44 +0300 |
| commit | 30f3d767ef4a8789860452127d8e04b92fadaabc (patch) | |
| tree | 4a2c0b88479e3812e98bbbe849b3123f4cc0dd75 /mysql-test/main/range_vs_index_merge.test | |
| parent | a35f715f440eb9ce93e4245cb1e4e5bc6f6972a2 (diff) | |
| download | mariadb-git-10.7-selectivity.tar.gz | |
Added test cases for preceding test10.7-selectivity
This includes all test changes from
"Changing all cost calculation to be given in milliseconds"
and forwards
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; |