diff options
| author | Sergei Petrunia <psergey@askmonty.org> | 2016-09-05 12:28:35 +0300 |
|---|---|---|
| committer | Sergei Petrunia <psergey@askmonty.org> | 2016-09-05 12:28:35 +0300 |
| commit | a14f61ef749ad9f9ab2b0f5badf6754ba7443c9e (patch) | |
| tree | a4b04f923c35f7e2bf45d05a70316ef4773666cc /mysql-test/r/index_merge_innodb.result | |
| parent | f81f985f37ccdcf04aa9707fe994a0c87f67b1a8 (diff) | |
| download | mariadb-git-a14f61ef749ad9f9ab2b0f5badf6754ba7443c9e.tar.gz | |
MDEV-7142: main.index_merge_innodb fails sporadically in buildbot
Attempt to stabilize the testcase.
Diffstat (limited to 'mysql-test/r/index_merge_innodb.result')
| -rw-r--r-- | mysql-test/r/index_merge_innodb.result | 3 |
1 files changed, 3 insertions, 0 deletions
diff --git a/mysql-test/r/index_merge_innodb.result b/mysql-test/r/index_merge_innodb.result index 5202c79f3c7..5bf56e213ab 100644 --- a/mysql-test/r/index_merge_innodb.result +++ b/mysql-test/r/index_merge_innodb.result @@ -311,6 +311,9 @@ set @d=@d*2; alter table t1 add index i2(key2); alter table t1 add index i3(key3); update t1 set key2=key1,key3=key1; +analyze table t1; +Table Op Msg_type Msg_text +test.t1 analyze status OK explain select * from t1 where (key3 > 30 and key3<35) or (key2 >32 and key2 < 40); id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE t1 index_merge i2,i3 i3,i2 4,4 NULL REF Using sort_union(i3,i2); Using where |