From 943b8fccf94cdbdc71fab8d6dc79df0255e37ea2 Mon Sep 17 00:00:00 2001 From: Sergei Petrunia Date: Fri, 1 Oct 2021 23:24:05 +0300 Subject: MDEV-26710: Histogram field in mysql.column_stats is too short Change it to LONGBLOB. Also, update_statistics_for_table() should not "swallow" an error from open_stat_tables. --- mysql-test/main/system_mysql_db.result | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) (limited to 'mysql-test/main/system_mysql_db.result') diff --git a/mysql-test/main/system_mysql_db.result b/mysql-test/main/system_mysql_db.result index f9e37a6e616..dcc71da3677 100644 --- a/mysql-test/main/system_mysql_db.result +++ b/mysql-test/main/system_mysql_db.result @@ -235,7 +235,7 @@ column_stats CREATE TABLE `column_stats` ( `avg_frequency` decimal(12,4) DEFAULT NULL, `hist_size` tinyint(3) unsigned DEFAULT NULL, `hist_type` enum('SINGLE_PREC_HB','DOUBLE_PREC_HB','JSON_HB') COLLATE utf8mb3_bin DEFAULT NULL, - `histogram` blob DEFAULT NULL, + `histogram` longblob DEFAULT NULL, PRIMARY KEY (`db_name`,`table_name`,`column_name`) ) ENGINE=Aria DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_bin PAGE_CHECKSUM=1 TRANSACTIONAL=0 COMMENT='Statistics on Columns' show create table index_stats; -- cgit v1.2.1