diff options
| author | Sinisa@sinisa.nasamreza.org <> | 2005-04-26 21:27:06 +0300 |
|---|---|---|
| committer | Sinisa@sinisa.nasamreza.org <> | 2005-04-26 21:27:06 +0300 |
| commit | edf2a160492093a89d77f8f674ee8bb59717f3e7 (patch) | |
| tree | 2c0cd4e2b9abd91635ca0bb910f05aad6a453bcf /mysql-test/t/union.test | |
| parent | 71c7c0d341b41d18127cd91bd1ae293eb4af8240 (diff) | |
| download | mariadb-git-edf2a160492093a89d77f8f674ee8bb59717f3e7.tar.gz | |
union.result:
Results for the above test case
union.test:
A test case for bug #10032 involving UNION's and ORDER BY clause
sql_yacc.yy:
Fix for a bug #10032 involving a parser bug with UNION's and ORDER BY
Diffstat (limited to 'mysql-test/t/union.test')
| -rw-r--r-- | mysql-test/t/union.test | 11 |
1 files changed, 11 insertions, 0 deletions
diff --git a/mysql-test/t/union.test b/mysql-test/t/union.test index b0446e1ea4a..ecd98428b5a 100644 --- a/mysql-test/t/union.test +++ b/mysql-test/t/union.test @@ -742,3 +742,14 @@ create table t2 select a from t1 union select c from t1; create table t2 select a from t1 union select b from t1; show columns from t2; drop table t2, t1; + + +# +# Bug #10032 Bug in parsing UNION with ORDER BY when one node does not use FROM +# + +create table t1 ( id int not null auto_increment, primary key (id), col1 int); +insert into t1 (col1) values (2),(3),(4),(5),(6); +select 99 union all select id from t1 order by 1; +select id from t1 union all select 99 order by 1; +drop table t1; |