diff options
| author | holyfoot/hf@hfmain.(none) <> | 2007-03-22 11:43:23 +0400 |
|---|---|---|
| committer | holyfoot/hf@hfmain.(none) <> | 2007-03-22 11:43:23 +0400 |
| commit | d24fb40374886dc8388182a10d35e44f6538db1c (patch) | |
| tree | 357eb02100ecceb9c157fe76f223296b10cbe950 /mysql-test/t/union.test | |
| parent | 45fb6c90f09db34b383915542d80fd07e844cc19 (diff) | |
| parent | e2c9c9cc20e423767a9a3c123cd84a752785fd84 (diff) | |
| download | mariadb-git-d24fb40374886dc8388182a10d35e44f6538db1c.tar.gz | |
Merge mysql.com:/home/hf/work/mrg/mysql-5.0-opt
into mysql.com:/home/hf/work/mrg/mysql-5.1-opt
Diffstat (limited to 'mysql-test/t/union.test')
| -rw-r--r-- | mysql-test/t/union.test | 9 |
1 files changed, 9 insertions, 0 deletions
diff --git a/mysql-test/t/union.test b/mysql-test/t/union.test index cc93fbd715a..a57ab469ac2 100644 --- a/mysql-test/t/union.test +++ b/mysql-test/t/union.test @@ -913,4 +913,13 @@ SELECT a FROM (SELECT a FROM t1 UNION SELECT a FROM t1 ORDER BY c) AS test; DROP TABLE t1; +# +# Bug#23345: Wrongly allowed INTO in a non-last select of a UNION. +# +--error 1221 +(select 1 into @var) union (select 1); +(select 1) union (select 1 into @var); +select @var; +--error 1172 +(select 2) union (select 1 into @var); --echo End of 5.0 tests |