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/selectivity_no_engine.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/selectivity_no_engine.result')
| -rw-r--r-- | mysql-test/r/selectivity_no_engine.result | 3 |
1 files changed, 3 insertions, 0 deletions
diff --git a/mysql-test/r/selectivity_no_engine.result b/mysql-test/r/selectivity_no_engine.result index 107d4b76903..05405a8777f 100644 --- a/mysql-test/r/selectivity_no_engine.result +++ b/mysql-test/r/selectivity_no_engine.result @@ -31,6 +31,7 @@ set histogram_size=100; set optimizer_use_condition_selectivity=4; analyze table t2 persistent for all; Table Op Msg_type Msg_text +test.t2 analyze status Engine-independent statistics collected test.t2 analyze status OK # The following two must have the same in 'Extra' column: explain extended select * from t2 where col1 IN (20, 180); @@ -55,6 +56,7 @@ set histogram_size=20; set histogram_type='single_prec_hb'; 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 use_stat_tables='preferably'; set optimizer_use_condition_selectivity=4; @@ -96,6 +98,7 @@ min(col1) max(col1) count(*) set histogram_size=100; 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 explain extended select * from t1 where col1 in (1,2,3); id select_type table type possible_keys key key_len ref rows filtered Extra |