diff options
Diffstat (limited to 'mysql-test/main/stat_tables_innodb.result')
-rw-r--r-- | mysql-test/main/stat_tables_innodb.result | 37 |
1 files changed, 32 insertions, 5 deletions
diff --git a/mysql-test/main/stat_tables_innodb.result b/mysql-test/main/stat_tables_innodb.result index c2f6981fa16..d504b531170 100644 --- a/mysql-test/main/stat_tables_innodb.result +++ b/mysql-test/main/stat_tables_innodb.result @@ -832,7 +832,38 @@ col1 2004-01-01 2004-02-29 0000-10-31 +set @@sql_mode= @save_sql_mode; +set @@use_stat_tables=@save_use_stat_tables; +set @@histogram_size= @save_histogram_size; +set @@histogram_type=@save_histogram_type; +set @@optimizer_use_condition_selectivity=@save_optimizer_use_condition_selectivity; drop table t1; +# +# MDEV-20589: Server still crashes in Field::set_warning_truncated_wrong_value +# +set names utf8; +create table t1 ( a varchar(255) character set utf8); +insert into t1 values (REPEAT('ӥ',255)), (REPEAT('ç',255)); +set use_stat_tables='preferably'; +analyze table t1 persistent for all; +Table Op Msg_type Msg_text +test.t1 analyze status Engine-independent statistics collected +test.t1 analyze status OK +set @save_sql_mode= @@sql_mode; +set sql_mode='ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION'; +update mysql.column_stats set min_value= REPEAT('ӥ',256) where db_name='test' and table_name='t1'; +Warnings: +Warning 1265 Data truncated for column 'min_value' at row 1 +set @@sql_mode= @save_sql_mode; +select length(a) from t1 where a=REPEAT('ӥ',255); +length(a) +510 +set names latin1; +set @@use_stat_tables=@save_use_stat_tables; +drop table t1; +# please keep this at the last +set @@global.histogram_size=@save_histogram_size; +# Start of 10.4 tests set histogram_size=0; # # MDEV-17255: New optimizer defaults and ANALYZE TABLE @@ -890,11 +921,7 @@ id select_type table type possible_keys key key_len ref rows r_rows filtered r_f 1 SIMPLE t1 ALL NULL NULL NULL NULL 10 10.00 2.78 10.00 Using where drop table t1; set @@global.histogram_size=@save_histogram_size; -set @@histogram_size= @save_histogram_size; -set @@histogram_type=@save_histogram_type; -set @@optimizer_use_condition_selectivity=@save_optimizer_use_condition_selectivity; -set @@sql_mode= @save_sql_mode; -set @@use_stat_tables=@save_use_stat_tables; +# End of 10.4 tests set global innodb_stats_persistent= @innodb_stats_persistent_save; set global innodb_stats_persistent_sample_pages= @innodb_stats_persistent_sample_pages_save; |