summaryrefslogtreecommitdiff
path: root/mysql-test/main/mysqlcheck.result
diff options
context:
space:
mode:
authorMonty <monty@mariadb.org>2019-05-02 16:11:32 +0300
committerMonty <monty@mariadb.org>2019-05-02 16:11:32 +0300
commit0cc7c6085e2caa71ad21eca6f19f5cca45457660 (patch)
tree26eff3f9b131c93afedbca773a60f0f654480592 /mysql-test/main/mysqlcheck.result
parent2b7e080faece853f463f6f546066d54e1cbc330b (diff)
downloadmariadb-git-0cc7c6085e2caa71ad21eca6f19f5cca45457660.tar.gz
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.
Diffstat (limited to 'mysql-test/main/mysqlcheck.result')
-rw-r--r--mysql-test/main/mysqlcheck.result10
1 files changed, 5 insertions, 5 deletions
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;