diff options
| author | unknown <igor@rurik.mysql.com> | 2004-10-19 16:07:10 -0700 |
|---|---|---|
| committer | unknown <igor@rurik.mysql.com> | 2004-10-19 16:07:10 -0700 |
| commit | a3e71bdbf54163ca8823aabc1c5938e5f593aa32 (patch) | |
| tree | c4a004a87cda30de2a6a2e8f1edd255d89e8a247 /mysql-test/t/range.test | |
| parent | 24b608b23084f0576bd94066c887b4891d55233d (diff) | |
| parent | 05933f13f7466a0057b0d5689300ded9101588f8 (diff) | |
| download | mariadb-git-a3e71bdbf54163ca8823aabc1c5938e5f593aa32.tar.gz | |
Merge for post-merge fixes for Item_equal patch.
BitKeeper/etc/ignore:
auto-union
mysql-test/r/range.result:
Auto merged
mysql-test/r/select.result:
Auto merged
mysql-test/t/range.test:
Auto merged
sql/item.cc:
Auto merged
sql/opt_range.cc:
Auto merged
sql/opt_sum.cc:
Auto merged
sql/sql_select.h:
Auto merged
sql/item.h:
Manual merge
sql/sql_select.cc:
Manual merge
Diffstat (limited to 'mysql-test/t/range.test')
| -rw-r--r-- | mysql-test/t/range.test | 4 |
1 files changed, 4 insertions, 0 deletions
diff --git a/mysql-test/t/range.test b/mysql-test/t/range.test index 7a86c0cef1d..e1427cdf260 100644 --- a/mysql-test/t/range.test +++ b/mysql-test/t/range.test @@ -378,8 +378,12 @@ insert into t2(id, uid, name) select id, uid, name from t1; select count(*) from t1; select count(*) from t2; +analyze table t1,t2; + explain select * from t1, t2 where t1.uid=t2.uid AND t1.uid > 0; +explain select * from t1, t2 where t1.uid=t2.uid AND t2.uid > 0; explain select * from t1, t2 where t1.uid=t2.uid AND t1.uid != 0; +explain select * from t1, t2 where t1.uid=t2.uid AND t2.uid != 0; select * from t1, t2 where t1.uid=t2.uid AND t1.uid > 0; select * from t1, t2 where t1.uid=t2.uid AND t1.uid != 0; |