diff options
| author | Sergey Petrunya <psergey@askmonty.org> | 2014-10-10 17:08:12 +0400 |
|---|---|---|
| committer | Sergey Petrunya <psergey@askmonty.org> | 2014-10-10 17:08:12 +0400 |
| commit | 41b45a81637be64c5039d4f600ce7eb9dbf03844 (patch) | |
| tree | 83239aed4de0642d8d2997a9de55c3ef18861253 /mysql-test/t/selectivity_innodb.test | |
| parent | 33f1ac66ad0c995396026881260c27a937da19ec (diff) | |
| download | mariadb-git-41b45a81637be64c5039d4f600ce7eb9dbf03844.tar.gz | |
MDEV-6738: use_stat_table + histograms crashing optimizer
- When EITS code calls store_key_image_to_rec(), it should follow its
calling convention (which is counter-intuitive)
Diffstat (limited to 'mysql-test/t/selectivity_innodb.test')
| -rw-r--r-- | mysql-test/t/selectivity_innodb.test | 14 |
1 files changed, 14 insertions, 0 deletions
diff --git a/mysql-test/t/selectivity_innodb.test b/mysql-test/t/selectivity_innodb.test index 60b0da0d5d1..5674cb5c006 100644 --- a/mysql-test/t/selectivity_innodb.test +++ b/mysql-test/t/selectivity_innodb.test @@ -65,6 +65,20 @@ SELECT * FROM t1, t2 WHERE ( 't', 'o' ) IN ( ); DROP TABLE t1,t2; +--echo # +--echo # MDEV-6738: use_stat_table + histograms crashing optimizer +--echo # + +set use_stat_tables='preferably'; +set optimizer_use_condition_selectivity=4; + +--echo # Need innodb because there is a special kind of field_bit for non-myisam tables +create table t1(col1 int, col2 bit(1) DEFAULT NULL) engine=innodb; + +select * from t1 where col2 != true; + +drop table t1; + --echo # --echo # End of 10.0 tests --echo # |