diff options
author | Monty <monty@mariadb.org> | 2019-04-01 19:42:26 +0300 |
---|---|---|
committer | Monty <monty@mariadb.org> | 2019-04-01 19:47:24 +0300 |
commit | 884004502134d881af0bcb59f97a838784ab5bbe (patch) | |
tree | 499c76eb6ad251e1f62d464f146b614dc4ae393e /mysql-test/main/index_merge_myisam.result | |
parent | 48810a00144481b7fec4ce8e23024e9f899626a7 (diff) | |
download | mariadb-git-884004502134d881af0bcb59f97a838784ab5bbe.tar.gz |
index_merge_innodb did sometimes give wrong results
Fixed by adding more rows to a table
Other things:
- Speed up index_merge tests 20% by adding begin/commit around loops that
generated rows.
Diffstat (limited to 'mysql-test/main/index_merge_myisam.result')
-rw-r--r-- | mysql-test/main/index_merge_myisam.result | 3 |
1 files changed, 3 insertions, 0 deletions
diff --git a/mysql-test/main/index_merge_myisam.result b/mysql-test/main/index_merge_myisam.result index e1f7c72bc4a..3d31f8d3dfa 100644 --- a/mysql-test/main/index_merge_myisam.result +++ b/mysql-test/main/index_merge_myisam.result @@ -1135,6 +1135,7 @@ key3 int not null default 0 ); insert into t1(key1) values (1),(2),(3),(4),(5),(6),(7),(8); set @d=8; +begin; insert into t1 (key1) select key1+@d from t1; set @d=@d*2; insert into t1 (key1) select key1+@d from t1; @@ -1149,9 +1150,11 @@ insert into t1 (key1) select key1+@d from t1; set @d=@d*2; insert into t1 (key1) select key1+@d from t1; set @d=@d*2; +commit; alter table t1 add index i2(key2); alter table t1 add index i3(key3); update t1 set key2=key1,key3=key1; +insert into t1 select 10000+key1, 10000+key2,10000+key3 from t1; analyze table t1; Table Op Msg_type Msg_text test.t1 analyze status Engine-independent statistics collected |