diff options
| author | Sergey Petrunya <psergey@askmonty.org> | 2013-07-03 19:42:05 +0400 |
|---|---|---|
| committer | Sergey Petrunya <psergey@askmonty.org> | 2013-07-03 19:42:05 +0400 |
| commit | e98bb64cbe8e3c46a091a317a8baea09b5e76da4 (patch) | |
| tree | 5cf983dfc8cb2e7e9f32ff2b127cfc0c450f6fb0 /mysql-test/r | |
| parent | 6baf3e1304e9ae2ee649d063d8cbc42e180e1874 (diff) | |
| download | mariadb-git-e98bb64cbe8e3c46a091a317a8baea09b5e76da4.tar.gz | |
MDEV-4750: (patch#2): undo previous attempts to stabilize
persistent table statistics with ANALYZE TABLE commands
Diffstat (limited to 'mysql-test/r')
| -rw-r--r-- | mysql-test/r/join_outer_innodb.result | 6 | ||||
| -rw-r--r-- | mysql-test/r/type_bit_innodb.result | 2 |
2 files changed, 0 insertions, 8 deletions
diff --git a/mysql-test/r/join_outer_innodb.result b/mysql-test/r/join_outer_innodb.result index 18fa982b0d5..650946d8b06 100644 --- a/mysql-test/r/join_outer_innodb.result +++ b/mysql-test/r/join_outer_innodb.result @@ -4,12 +4,6 @@ CREATE TABLE t2 (id int(11) NOT NULL PRIMARY KEY, fkey int(11), FOREIGN KEY (fkey) REFERENCES t2(id)) ENGINE=InnoDB; INSERT INTO t1 VALUES (1,'A1'),(2,'A2'),(3,'B'); INSERT INTO t2 VALUES (1,1),(2,2),(3,2),(4,3),(5,3); -ANALYZE TABLE t1; -Table Op Msg_type Msg_text -test.t1 analyze status OK -ANALYZE TABLE t2; -Table Op Msg_type Msg_text -test.t2 analyze status OK EXPLAIN SELECT COUNT(*) FROM t2 LEFT JOIN t1 ON t2.fkey = t1.id WHERE t1.name LIKE 'A%'; diff --git a/mysql-test/r/type_bit_innodb.result b/mysql-test/r/type_bit_innodb.result index 4960feae533..9bdd8658690 100644 --- a/mysql-test/r/type_bit_innodb.result +++ b/mysql-test/r/type_bit_innodb.result @@ -84,7 +84,6 @@ a+0 2 3 alter table t1 add key (a); -analyze table t1; explain select a+0 from t1; id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE t1 index NULL a 2 NULL 4 Using index @@ -103,7 +102,6 @@ insert into t1 values (116, 390), (119, 368), (87, 351), (123, 411), (24, 398), (34, 202), (28, 499), (30, 83), (5, 178), (60, 343), (4, 245), (104, 280), (106, 446), (127, 403), (44, 307), (68, 454), (57, 135); -analyze table t1; explain select a+0 from t1; id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE t1 index NULL a 5 NULL 38 Using index |