From 0d5aabd632ea3fc70d4de2ad934ad314231fb7c8 Mon Sep 17 00:00:00 2001 From: Varun Gupta Date: Thu, 25 Apr 2019 18:18:26 +0530 Subject: 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. --- mysql-test/r/statistics.result | 14 ++++++++++++++ mysql-test/t/statistics.test | 15 +++++++++++++++ 2 files changed, 29 insertions(+) (limited to 'mysql-test') 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; -- cgit v1.2.1