diff options
| author | unknown <Sinisa@sinisa.nasamreza.org> | 2005-04-26 21:27:06 +0300 |
|---|---|---|
| committer | unknown <Sinisa@sinisa.nasamreza.org> | 2005-04-26 21:27:06 +0300 |
| commit | 783705fc65080e9f1bdc8659f0a792f61069abe0 (patch) | |
| tree | 2c0cd4e2b9abd91635ca0bb910f05aad6a453bcf /mysql-test/r/union.result | |
| parent | 20cf8f82eefbc4db26ec50aef4f602c991811397 (diff) | |
| download | mariadb-git-783705fc65080e9f1bdc8659f0a792f61069abe0.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
sql/sql_yacc.yy:
Fix for a bug #10032 involving a parser bug with UNION's and ORDER BY
mysql-test/t/union.test:
A test case for bug #10032 involving UNION's and ORDER BY clause
mysql-test/r/union.result:
Results for the above test case
Diffstat (limited to 'mysql-test/r/union.result')
| -rw-r--r-- | mysql-test/r/union.result | 19 |
1 files changed, 19 insertions, 0 deletions
diff --git a/mysql-test/r/union.result b/mysql-test/r/union.result index c140ecd26e1..b315ae9a3f5 100644 --- a/mysql-test/r/union.result +++ b/mysql-test/r/union.result @@ -1235,3 +1235,22 @@ show columns from t2; Field Type Null Key Default Extra a varchar(3) YES NULL drop table t2, t1; +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; +99 +1 +2 +3 +4 +5 +99 +select id from t1 union all select 99 order by 1; +id +1 +2 +3 +4 +5 +99 +drop table t1; |