diff options
| author | Sergey Petrunya <psergey@askmonty.org> | 2014-03-28 00:32:53 +0400 |
|---|---|---|
| committer | Sergey Petrunya <psergey@askmonty.org> | 2014-03-28 00:32:53 +0400 |
| commit | 92e49bb066da7cb5a38c2d3390176afdc5e67592 (patch) | |
| tree | 264a8ce5c05ac36c7e70f0ef36fc486ef67a0662 /mysql-test/r/stat_tables.result | |
| parent | 42263a2b0a16211f260e721a3087a1b14b09bbd9 (diff) | |
| download | mariadb-git-92e49bb066da7cb5a38c2d3390176afdc5e67592.tar.gz | |
MDEV-4360: ANALYZE shows "Table is already up to date" while updating stats
- Show a line with "Engine-independent statistics collected" when ANALYZE command
caused EITS statistics to be recollected.
Diffstat (limited to 'mysql-test/r/stat_tables.result')
| -rw-r--r-- | mysql-test/r/stat_tables.result | 5 |
1 files changed, 5 insertions, 0 deletions
diff --git a/mysql-test/r/stat_tables.result b/mysql-test/r/stat_tables.result index 63c65e23c19..285284596c4 100644 --- a/mysql-test/r/stat_tables.result +++ b/mysql-test/r/stat_tables.result @@ -350,6 +350,7 @@ create table t1 (i int); lock table t1 write; analyze table t1; Table Op Msg_type Msg_text +test.t1 analyze status Engine-independent statistics collected test.t1 analyze status Table is already up to date alter table t1 add column a varchar(8); drop table t1; @@ -362,6 +363,7 @@ INSERT INTO t1 VALUES (1),(2); DELETE FROM t1 WHERE a=1; ANALYZE TABLE t1; Table Op Msg_type Msg_text +test.t1 analyze status Engine-independent statistics collected test.t1 analyze status OK DROP TABLE t1; # @@ -390,10 +392,12 @@ CREATE TABLE t1 (id int PRIMARY KEY) ENGINE=MyISAM; INSERT INTO t1 VALUES (1),(2); ANALYZE TABLE t1; Table Op Msg_type Msg_text +test.t1 analyze status Engine-independent statistics collected test.t1 analyze status OK CREATE TABLE t2 (name char(3)) ENGINE=MyISAM; ANALYZE TABLE t2; Table Op Msg_type Msg_text +test.t2 analyze status Engine-independent statistics collected test.t2 analyze status Table is already up to date INSERT INTO t2 VALUES ('USA'),('AUS'); SELECT * FROM t1 STRAIGHT_JOIN t2 WHERE name IN ( 'AUS','YEM' ) AND id = 1; @@ -406,6 +410,7 @@ id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE t2 ALL NULL NULL NULL NULL 0 Using where ANALYZE TABLE t2; Table Op Msg_type Msg_text +test.t2 analyze status Engine-independent statistics collected test.t2 analyze status OK SELECT * FROM t1 STRAIGHT_JOIN t2 WHERE name IN ( 'AUS','YEM' ) AND id = 1; id name |