diff options
| author | unknown <bell@sanja.is.com.ua> | 2003-01-03 17:08:00 +0200 |
|---|---|---|
| committer | unknown <bell@sanja.is.com.ua> | 2003-01-03 17:08:00 +0200 |
| commit | 2ca6d018d767207c0583fceeccd2a941281e51f2 (patch) | |
| tree | 5c0b86fe439500b6ad56cb5e2816bdfe18e1cb73 /mysql-test/r | |
| parent | 3f4c4cbfdd36c2e14cf966ee24fdd309bc133e85 (diff) | |
| download | mariadb-git-2ca6d018d767207c0583fceeccd2a941281e51f2.tar.gz | |
fixed do with subselects
mysql-test/r/subselect.result:
test of DO with subselects
mysql-test/t/subselect.test:
test of DO with subselects
Diffstat (limited to 'mysql-test/r')
| -rw-r--r-- | mysql-test/r/subselect.result | 11 |
1 files changed, 10 insertions, 1 deletions
diff --git a/mysql-test/r/subselect.result b/mysql-test/r/subselect.result index 7dc03a31878..38a8e0368c6 100644 --- a/mysql-test/r/subselect.result +++ b/mysql-test/r/subselect.result @@ -841,4 +841,13 @@ ROW(1, 1, 'a') IN (select b,a,c from t where c='b' or c='a') 1 select ROW(1, 1, 'a') IN (select b,a,c from t limit 2); This version of MySQL doesn't yet support 'LIMIT & IN/ALL/ANY/SOME subquery' -drop table if exists t; +drop table t; +create table t (a int); +insert into t values (1); +do @a:=(SELECT a from t); +select @a; +@a +1 +drop table t; +do (SELECT a from t); +Table 'test.t' doesn't exist |