From edf2a160492093a89d77f8f674ee8bb59717f3e7 Mon Sep 17 00:00:00 2001
From: "Sinisa@sinisa.nasamreza.org" <>
Date: Tue, 26 Apr 2005 21:27:06 +0300
Subject: 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

---
 mysql-test/t/union.test | 11 +++++++++++
 1 file changed, 11 insertions(+)

(limited to 'mysql-test/t/union.test')

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;
-- 
cgit v1.2.1