diff options
author | Igor Babaev <igor@askmonty.org> | 2013-04-05 13:01:46 -0700 |
---|---|---|
committer | Igor Babaev <igor@askmonty.org> | 2013-04-05 13:01:46 -0700 |
commit | 503731d80f732a3a790443cc530fea2c3721b869 (patch) | |
tree | 25387182582cd5d2e53913a567dbde17b2907cae /mysql-test/t/selectivity.test | |
parent | daaa5834c9fb567924c21d467983c1ec3401f832 (diff) | |
download | mariadb-git-503731d80f732a3a790443cc530fea2c3721b869.tar.gz |
Fixed bug mdev-4371.
Avoid possible division by 0.
Diffstat (limited to 'mysql-test/t/selectivity.test')
-rw-r--r-- | mysql-test/t/selectivity.test | 33 |
1 files changed, 33 insertions, 0 deletions
diff --git a/mysql-test/t/selectivity.test b/mysql-test/t/selectivity.test index aab8c504f3c..5bce7f50e0d 100644 --- a/mysql-test/t/selectivity.test +++ b/mysql-test/t/selectivity.test @@ -412,4 +412,37 @@ set histogram_size=@save_histogram_size; set histogram_type=@save_histogram_type; set use_stat_tables=@save_use_stat_tables; +--echo # +--echo # Bug mdev-4371: Join with condition supported by index on an empty table +--echo # with optimizer_use_condition_selectivity=3 +--echo # + +set use_stat_tables=PREFERABLY; + +CREATE TABLE t1 (a int, b int, INDEX(a)); + +CREATE TABLE t2 (c int); +INSERT INTO t2 VALUES (1),(2),(3),(4),(5),(6),(7),(8); + +ANALYZE TABLE t1, t2; +FLUSH TABLES; + +set optimizer_use_condition_selectivity=3; + +set @save_optimizer_switch=@@optimizer_switch; +set optimizer_switch='index_condition_pushdown=off'; + +EXPLAIN EXTENDED +SELECT * FROM t1, t2 WHERE a > 9; +SELECT * FROM t1, t2 WHERE a > 9; + +set optimizer_switch=@save_optimizer_switch; + +set optimizer_use_condition_selectivity=@save_optimizer_use_condition_selectivity; + +DROP TABLE t1,t2; + +set use_stat_tables=@save_use_stat_tables; + + set use_stat_tables=@save_use_stat_tables; |