summaryrefslogtreecommitdiff
path: root/mysql-test/t/range.test
diff options
context:
space:
mode:
authorunknown <igor@rurik.mysql.com>2004-10-19 16:07:10 -0700
committerunknown <igor@rurik.mysql.com>2004-10-19 16:07:10 -0700
commita3e71bdbf54163ca8823aabc1c5938e5f593aa32 (patch)
treec4a004a87cda30de2a6a2e8f1edd255d89e8a247 /mysql-test/t/range.test
parent24b608b23084f0576bd94066c887b4891d55233d (diff)
parent05933f13f7466a0057b0d5689300ded9101588f8 (diff)
downloadmariadb-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.test4
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;