diff options
| author | Varun Gupta <varun.gupta@mariadb.com> | 2019-04-25 18:18:26 +0530 |
|---|---|---|
| committer | Varun Gupta <varun.gupta@mariadb.com> | 2019-04-27 14:27:02 +0530 |
| commit | 0d5aabd632ea3fc70d4de2ad934ad314231fb7c8 (patch) | |
| tree | 93055f71d398ebc297ccda379e5094d931f959ec /mysql-test | |
| parent | f239fd5034fe66a06a7a254fe1721eae781b118e (diff) | |
| download | mariadb-git-0d5aabd632ea3fc70d4de2ad934ad314231fb7c8.tar.gz | |
MDEV-19334: bool is_eits_usable(Field*): Assertion `field->table->stats_is_read' failed.
Fixed the assert by making sure that not to use EITS if the column statistics was not allocated.
Diffstat (limited to 'mysql-test')
| -rw-r--r-- | mysql-test/r/statistics.result | 14 | ||||
| -rw-r--r-- | mysql-test/t/statistics.test | 15 |
2 files changed, 29 insertions, 0 deletions
diff --git a/mysql-test/r/statistics.result b/mysql-test/r/statistics.result index 295a9b34e49..135a0806bc3 100644 --- a/mysql-test/r/statistics.result +++ b/mysql-test/r/statistics.result @@ -1735,4 +1735,18 @@ rename table t1 to t2, t3 to t4; ERROR 42S02: Table 'test.t3' doesn't exist drop table t1, mysql.table_stats; rename table test.table_stats to mysql.table_stats; +# +# MDEV-19334: bool is_eits_usable(Field*): Assertion `field->table->stats_is_read' failed. +# +create temporary table t1(a int); +insert into t1 values (1),(2),(3); +set use_stat_tables=preferably; +set @optimizer_use_condition_selectivity= @@optimizer_use_condition_selectivity; +set optimizer_use_condition_selectivity=4; +select * from t1 where a >= 2; +a +2 +3 +drop table t1; +set @@optimizer_use_condition_selectivity= @save_optimizer_use_condition_selectivity; set use_stat_tables=@save_use_stat_tables; diff --git a/mysql-test/t/statistics.test b/mysql-test/t/statistics.test index e4f9870a622..7d2e7e898d3 100644 --- a/mysql-test/t/statistics.test +++ b/mysql-test/t/statistics.test @@ -809,4 +809,19 @@ rename table t1 to t2, t3 to t4; drop table t1, mysql.table_stats; rename table test.table_stats to mysql.table_stats; +--echo # +--echo # MDEV-19334: bool is_eits_usable(Field*): Assertion `field->table->stats_is_read' failed. +--echo # + +create temporary table t1(a int); +insert into t1 values (1),(2),(3); + +set use_stat_tables=preferably; +set @optimizer_use_condition_selectivity= @@optimizer_use_condition_selectivity; +set optimizer_use_condition_selectivity=4; + +select * from t1 where a >= 2; +drop table t1; +set @@optimizer_use_condition_selectivity= @save_optimizer_use_condition_selectivity; + set use_stat_tables=@save_use_stat_tables; |