diff options
| author | Igor Babaev <igor@askmonty.org> | 2010-08-31 09:34:21 -0700 |
|---|---|---|
| committer | Igor Babaev <igor@askmonty.org> | 2010-08-31 09:34:21 -0700 |
| commit | 94cfcbd9dffdfe5e38dd29c542738de85beaeb06 (patch) | |
| tree | dca2c84e183cce7a4a08cc82ac696adfc9c244a8 /mysql-test/include/index_merge2.inc | |
| parent | 02c040dd5c26cbc97ae30776638463c36d96a938 (diff) | |
| download | mariadb-git-94cfcbd9dffdfe5e38dd29c542738de85beaeb06.tar.gz | |
The main patch for MWL#128: Implement Block Nested Loop Hash Join.
Diffstat (limited to 'mysql-test/include/index_merge2.inc')
| -rw-r--r-- | mysql-test/include/index_merge2.inc | 2 |
1 files changed, 2 insertions, 0 deletions
diff --git a/mysql-test/include/index_merge2.inc b/mysql-test/include/index_merge2.inc index 32a176630ad..a6a7a4b2ae1 100644 --- a/mysql-test/include/index_merge2.inc +++ b/mysql-test/include/index_merge2.inc @@ -123,6 +123,7 @@ analyze table t1; select count(*) from t1; --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; @@ -130,6 +131,7 @@ select count(*) from t1 where key1a = 2 and key1b is null and key2a = 2 and key2b is null; --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; |