diff options
| author | unknown <Sinisa@sinisa.nasamreza.org> | 2002-12-09 20:47:47 +0200 |
|---|---|---|
| committer | unknown <Sinisa@sinisa.nasamreza.org> | 2002-12-09 20:47:47 +0200 |
| commit | 4e20633094629303a0bcb3f98fd213a9050af5bc (patch) | |
| tree | bb14e9a19e4481dc1f337136bb6624f7f2b76255 /mysql-test | |
| parent | 89524b29c4fba7f30b7267f212d879459211582d (diff) | |
| download | mariadb-git-4e20633094629303a0bcb3f98fd213a9050af5bc.tar.gz | |
fix for a bug with UNION in sub-select's and start working on
UNION's in derived tables
Diffstat (limited to 'mysql-test')
| -rw-r--r-- | mysql-test/r/union.result | 3 | ||||
| -rw-r--r-- | mysql-test/t/union.test | 1 |
2 files changed, 4 insertions, 0 deletions
diff --git a/mysql-test/r/union.result b/mysql-test/r/union.result index 02dda58d48f..9f62ffe5c40 100644 --- a/mysql-test/r/union.result +++ b/mysql-test/r/union.result @@ -201,3 +201,6 @@ set SQL_SELECT_LIMIT=DEFAULT; drop table t1,t2; select * union select 1; No tables used +select 1 as a,(select a union select a); +a (select a union select a) +1 1 diff --git a/mysql-test/t/union.test b/mysql-test/t/union.test index 9ddfda7872f..449bafbdef6 100644 --- a/mysql-test/t/union.test +++ b/mysql-test/t/union.test @@ -103,3 +103,4 @@ drop table t1,t2; --error 1096 select * union select 1; +select 1 as a,(select a union select a); |