diff options
| author | unknown <sergefp@mysql.com> | 2005-06-20 11:05:38 +0200 |
|---|---|---|
| committer | unknown <sergefp@mysql.com> | 2005-06-20 11:05:38 +0200 |
| commit | 3b6d50d83584fb220a9907f890c8de0eb03600a5 (patch) | |
| tree | 3dcd72e4fc88ab6c16db5d5bddc62f07076e96b7 /mysql-test/t/index_merge.test | |
| parent | c7e49b6bd689b9adf3a7f6f28766fc05efb78f41 (diff) | |
| download | mariadb-git-3b6d50d83584fb220a9907f890c8de0eb03600a5.tar.gz | |
Fix for BUG#10804: allow differences in rows field in EXPLAIN output
Diffstat (limited to 'mysql-test/t/index_merge.test')
| -rw-r--r-- | mysql-test/t/index_merge.test | 3 |
1 files changed, 2 insertions, 1 deletions
diff --git a/mysql-test/t/index_merge.test b/mysql-test/t/index_merge.test index 5ac91f1f8b1..42175a757c2 100644 --- a/mysql-test/t/index_merge.test +++ b/mysql-test/t/index_merge.test @@ -310,7 +310,8 @@ update t0 set key2=1, key3=1, key4=1, key5=1,key6=1,key7=1 where key7 < 500; # The next query will not use index i7 in intersection if the OS doesn't # support file sizes > 2GB. (ha_myisam::ref_length depends on this and index # scan cost estimates depend on ha_myisam::ref_length) ---replace_result "4,4,4,4,4,4,4" X "4,4,4,4,4,4" X "i6,i7" "i6,i7?" "i6" "i6,i7?" 7 # 16 # 18 # +--replace_column 9 # +--replace_result "4,4,4,4,4,4,4" X "4,4,4,4,4,4" X "i6,i7" "i6,i7?" "i6" "i6,i7?" explain select max(A.key1 + B.key1 + A.key2 + B.key2 + A.key3 + B.key3 + A.key4 + B.key4 + A.key5 + B.key5) from t0 as A, t0 as B where (A.key1 = 1 and A.key2 = 1 and A.key3 = 1 and A.key4=1 and A.key5=1 and A.key6=1 and A.key7 = 1 or A.key8=1) |