diff options
Diffstat (limited to 'mysql-test/r/union.result')
| -rw-r--r-- | mysql-test/r/union.result | 14 |
1 files changed, 0 insertions, 14 deletions
diff --git a/mysql-test/r/union.result b/mysql-test/r/union.result index 9640f18db78..f89d41aa982 100644 --- a/mysql-test/r/union.result +++ b/mysql-test/r/union.result @@ -879,20 +879,6 @@ d 444 d 454 NULL NULL f 666 NULL NULL g 777 drop table t1; -create table t1 ( id int, name char(10) not null, name2 char(10) not null ) engine=innodb; -insert into t1 values(1,'first','fff'),(2,'second','sss'),(3,'third','ttt'); -select name2 from t1 union all select name from t1 union all select id from t1; -name2 -fff -sss -ttt -first -second -third -1 -2 -3 -drop table t1; create table t1 (col1 tinyint unsigned, col2 tinyint unsigned); insert into t1 values (1,2),(3,4),(5,6),(7,8),(9,10); select col1 n from t1 union select col2 n from t1 order by n; |