diff options
author | unknown <joerg@mysql.com> | 2005-05-26 12:51:44 +0200 |
---|---|---|
committer | unknown <joerg@mysql.com> | 2005-05-26 12:51:44 +0200 |
commit | 96f629db87b4c790f980dfeb539c8ddea0901354 (patch) | |
tree | eaa4a697ce366f6da89001d3d3eaa62af2a7483b /mysql-test/t/union.test | |
parent | f0f9b5959eecb87b369fc45c981d926b79de0c61 (diff) | |
parent | 7e5651ca17706473c3ea791db48a08c849181f1c (diff) | |
download | mariadb-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.test | 15 |
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; |