diff options
Diffstat (limited to 'mysql-test/include/index_merge2.inc')
-rw-r--r-- | mysql-test/include/index_merge2.inc | 12 |
1 files changed, 4 insertions, 8 deletions
diff --git a/mysql-test/include/index_merge2.inc b/mysql-test/include/index_merge2.inc index 23c8c6466c7..1d6b82e1787 100644 --- a/mysql-test/include/index_merge2.inc +++ b/mysql-test/include/index_merge2.inc @@ -122,20 +122,16 @@ insert into t1 (key1a, key1b, key2a, key2b, key3a, key3b) analyze table t1; select count(*) from t1; -if ($index_merge_random_rows_in_EXPLAIN) -{ - --replace_column 9 # -} +--replace_column 9 REF +--replace_result i2,i1 i1,i2 explain select count(*) from t1 where key1a = 2 and key1b is null and key2a = 2 and key2b is null; select count(*) from t1 where key1a = 2 and key1b is null and key2a = 2 and key2b is null; -if ($index_merge_random_rows_in_EXPLAIN) -{ - --replace_column 9 # -} +--replace_column 9 REF +--replace_result i3,i1 i1,i3 explain select count(*) from t1 where key1a = 2 and key1b is null and key3a = 2 and key3b is null; |