diff options
| author | bell@sanja.is.com.ua <> | 2003-01-04 16:33:42 +0200 |
|---|---|---|
| committer | bell@sanja.is.com.ua <> | 2003-01-04 16:33:42 +0200 |
| commit | cfc99ce45c30254e9730baaece196028ab7b0d2f (patch) | |
| tree | b43db14ab12c2b2db7996edda5fbffd75c7a9308 /mysql-test | |
| parent | 7c82789929e36ede31dd181f54ddffd30ba7f3ed (diff) | |
| download | mariadb-git-cfc99ce45c30254e9730baaece196028ab7b0d2f.tar.gz | |
fixed SET with subselect
Diffstat (limited to 'mysql-test')
| -rw-r--r-- | mysql-test/r/subselect.result | 7 | ||||
| -rw-r--r-- | mysql-test/t/subselect.test | 5 |
2 files changed, 12 insertions, 0 deletions
diff --git a/mysql-test/r/subselect.result b/mysql-test/r/subselect.result index 38a8e0368c6..97191567cc9 100644 --- a/mysql-test/r/subselect.result +++ b/mysql-test/r/subselect.result @@ -848,6 +848,13 @@ do @a:=(SELECT a from t); select @a; @a 1 +set @a:=2; +set @a:=(SELECT a from t); +select @a; +@a +1 drop table t; do (SELECT a from t); Table 'test.t' doesn't exist +set @a:=(SELECT a from t); +Table 'test.t' doesn't exist diff --git a/mysql-test/t/subselect.test b/mysql-test/t/subselect.test index de07df1905b..608657e69d5 100644 --- a/mysql-test/t/subselect.test +++ b/mysql-test/t/subselect.test @@ -468,6 +468,11 @@ create table t (a int); insert into t values (1); do @a:=(SELECT a from t); select @a; +set @a:=2; +set @a:=(SELECT a from t); +select @a; drop table t; -- error 1146 do (SELECT a from t); +-- error 1146 +set @a:=(SELECT a from t);
\ No newline at end of file |