summaryrefslogtreecommitdiff
path: root/mysql-test/t/union.test
diff options
context:
space:
mode:
authorunknown <joerg@mysql.com>2005-05-26 12:51:44 +0200
committerunknown <joerg@mysql.com>2005-05-26 12:51:44 +0200
commit96f629db87b4c790f980dfeb539c8ddea0901354 (patch)
treeeaa4a697ce366f6da89001d3d3eaa62af2a7483b /mysql-test/t/union.test
parentf0f9b5959eecb87b369fc45c981d926b79de0c61 (diff)
parent7e5651ca17706473c3ea791db48a08c849181f1c (diff)
downloadmariadb-git-96f629db87b4c790f980dfeb539c8ddea0901354.tar.gz
Manual merge.
client/mysqldump.c: Auto merged include/my_global.h: Auto merged mysql-test/r/mysqldump.result: Auto merged mysql-test/r/select.result: Auto merged mysql-test/t/mysqldump.test: Auto merged sql/item.cc: Auto merged sql/sql_yacc.yy: Auto merged support-files/mysql.spec.sh: Auto merged client/client_priv.h: Manual merge (still to be corrected!)
Diffstat (limited to 'mysql-test/t/union.test')
-rw-r--r--mysql-test/t/union.test15
1 files changed, 13 insertions, 2 deletions
diff --git a/mysql-test/t/union.test b/mysql-test/t/union.test
index 239a7aaad4b..42cdf54544a 100644
--- a/mysql-test/t/union.test
+++ b/mysql-test/t/union.test
@@ -740,12 +740,12 @@ select concat('value is: ', @val) union select 'some text';
# Enum merging test
#
CREATE TABLE t1 (
- a ENUM('ä','ö','ü') character set utf8 not null default 'ü',
+ a ENUM('ä','ö','ü') character set utf8 not null default 'ü',
b ENUM("one", "two") character set utf8,
c ENUM("one", "two")
);
show create table t1;
-insert into t1 values ('ä', 'one', 'one'), ('ö', 'two', 'one'), ('ü', NULL, NULL);
+insert into t1 values ('ä', 'one', 'one'), ('ö', 'two', 'one'), ('ü', NULL, NULL);
create table t2 select NULL union select a from t1;
show columns from t2;
drop table t2;
@@ -772,3 +772,14 @@ select row_format from information_schema.TABLES where table_schema="test" and t
alter table t2 ROW_FORMAT=fixed;
show create table t2;
drop table t1,t2;
+
+
+#
+# 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;