diff options
| author | unknown <igor@rurik.mysql.com> | 2003-12-23 02:24:12 -0800 |
|---|---|---|
| committer | unknown <igor@rurik.mysql.com> | 2003-12-23 02:24:12 -0800 |
| commit | b02b6c708eb56c890cbc9a08c73e9f88c4645fcb (patch) | |
| tree | 5e777a4d18231796e5654856dfb16db8d8a4cd75 /mysql-test/t/range.test | |
| parent | d4898d174c7e728a66831a299b8dddfd5ca6e802 (diff) | |
| parent | 9c264e4ad27731b17bddf6369792c78ecc91d626 (diff) | |
| download | mariadb-git-b02b6c708eb56c890cbc9a08c73e9f88c4645fcb.tar.gz | |
Auto Merge
BitKeeper/etc/ignore:
auto-union
mysql-test/r/bdb.result:
Auto merged
mysql-test/r/func_group.result:
Auto merged
mysql-test/r/func_test.result:
Auto merged
mysql-test/r/heap_btree.result:
Auto merged
mysql-test/r/index_merge.result:
Auto merged
mysql-test/r/innodb.result:
Auto merged
mysql-test/r/join_outer.result:
Auto merged
mysql-test/r/range.result:
Auto merged
mysql-test/r/select.result:
Auto merged
mysql-test/r/subselect.result:
Auto merged
mysql-test/t/range.test:
Auto merged
sql/item.cc:
Auto merged
sql/item.h:
Auto merged
sql/item_cmpfunc.cc:
Auto merged
sql/item_func.cc:
Auto merged
sql/item_func.h:
Auto merged
sql/item_strfunc.h:
Auto merged
sql/sql_list.h:
Auto merged
sql/sql_select.cc:
Auto merged
sql/sql_select.h:
Auto merged
sql/opt_range.cc:
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 f01d8d4eacf..18e4ea20990 100644 --- a/mysql-test/t/range.test +++ b/mysql-test/t/range.test @@ -334,8 +334,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; |