From 0cc7c6085e2caa71ad21eca6f19f5cca45457660 Mon Sep 17 00:00:00 2001 From: Monty Date: Thu, 2 May 2019 16:11:32 +0300 Subject: Enable mysqlcheck and flush_read_lock tests - Updated results - Run mysqlcheck without --user-stat-tables=PREFERABLY to keep results consistent - Don't allow one to run analyze table under FTWRL as analyze table nowadays has to update status tables. --- mysql-test/main/mysqlcheck.result | 10 +++++----- 1 file changed, 5 insertions(+), 5 deletions(-) (limited to 'mysql-test/main/mysqlcheck.result') diff --git a/mysql-test/main/mysqlcheck.result b/mysql-test/main/mysqlcheck.result index 063560e388e..02ab2af9fc1 100644 --- a/mysql-test/main/mysqlcheck.result +++ b/mysql-test/main/mysqlcheck.result @@ -468,11 +468,11 @@ drop database mysqltest1; # create table t1(a int); insert into t1 (a) values (1), (2), (3); -select * from mysql.column_stats; -db_name table_name column_name min_value max_value nulls_ratio avg_length avg_frequency hist_size hist_type histogram +select db_name,table_name,column_name,min_value,max_value,nulls_ratio,avg_length,avg_frequency,hist_size,hist_type from mysql.column_stats order by db_name,table_name; +db_name table_name column_name min_value max_value nulls_ratio avg_length avg_frequency hist_size hist_type test.t1 Engine-independent statistics collected status : OK -select * from mysql.column_stats where db_name = 'test' and table_name = 't1'; -db_name table_name column_name min_value max_value nulls_ratio avg_length avg_frequency hist_size hist_type histogram -test t1 a 1 3 0.0000 4.0000 1.0000 0 NULL NULL +select db_name,table_name,column_name,min_value,max_value,nulls_ratio,avg_length,avg_frequency,hist_size,hist_type from mysql.column_stats where db_name = 'test' and table_name = 't1' order by db_name,table_name; +db_name table_name column_name min_value max_value nulls_ratio avg_length avg_frequency hist_size hist_type +test t1 a 1 3 0.0000 4.0000 1.0000 254 DOUBLE_PREC_HB drop table t1; -- cgit v1.2.1