diff options
| author | unknown <bell@sanja.is.com.ua> | 2002-06-19 17:52:44 +0300 |
|---|---|---|
| committer | unknown <bell@sanja.is.com.ua> | 2002-06-19 17:52:44 +0300 |
| commit | c6a2ae17a01d1f93257ea1ce5af0513d870585b0 (patch) | |
| tree | cc55f99d5599771fbb2ddecda5ce0467fd2ede67 /mysql-test/t/subselect.test | |
| parent | 454712d20e89b34e2c45973f3d601f4720c3e471 (diff) | |
| download | mariadb-git-c6a2ae17a01d1f93257ea1ce5af0513d870585b0.tar.gz | |
EXISTS type of subselect
more correct parameters in result creation script
mysql-test/create-test-result:
more correct parameters in result creation script
mysql-test/r/subselect.result:
test of EXISTS
mysql-test/t/subselect.test:
test of EXISTS
sql/item_subselect.cc:
EXISTS type of subselect
sql/item_subselect.h:
EXISTS type of subselect
sql/sql_class.cc:
EXISTS type of subselect
sql/sql_class.h:
EXISTS type of subselect
sql/sql_yacc.yy:
EXISTS type of subselect
Diffstat (limited to 'mysql-test/t/subselect.test')
| -rw-r--r-- | mysql-test/t/subselect.test | 2 |
1 files changed, 2 insertions, 0 deletions
diff --git a/mysql-test/t/subselect.test b/mysql-test/t/subselect.test index c94522fde8f..78300dc3e09 100644 --- a/mysql-test/t/subselect.test +++ b/mysql-test/t/subselect.test @@ -26,4 +26,6 @@ select * from t1 where t1.a=(select t2.a from t2 where t2.b=(select max(a) from select * from t1 where t1.a=(select t2.a from t2 where t2.b=(select max(a) from t3 where t3.a > t1.a) order by 1 desc limit 1); select * from t1 where t1.a=(select t2.a from t2 where t2.b=(select max(a) from t3 where t3.a < t1.a) order by 1 desc limit 1); select b,(select avg(t2.a+(select min(t3.a) from t3 where t3.a >= t4.a)) from t2) from t4; +select * from t3 where exists (select * from t2 where t2.b=t3.a); +select * from t3 where not exists (select * from t2 where t2.b=t3.a); drop table t1,t2,t3,t4; |