summaryrefslogtreecommitdiff
path: root/mysql-test/r/union.result
diff options
context:
space:
mode:
authorunknown <jimw@mysql.com>2005-11-30 13:10:08 -0800
committerunknown <jimw@mysql.com>2005-11-30 13:10:08 -0800
commitb775d23faaa98297ddd5ed6978b5a214432516d3 (patch)
tree85364671b86aac78bc180c91e86162e1a8478c2b /mysql-test/r/union.result
parent03e057cd9ec2feb08f00578a9f22801f8656d92d (diff)
downloadmariadb-git-b775d23faaa98297ddd5ed6978b5a214432516d3.tar.gz
Fix union.result
mysql-test/r/union.result: Fix order of test results
Diffstat (limited to 'mysql-test/r/union.result')
-rw-r--r--mysql-test/r/union.result52
1 files changed, 26 insertions, 26 deletions
diff --git a/mysql-test/r/union.result b/mysql-test/r/union.result
index 48aac1b3a0a..f2708a50c77 100644
--- a/mysql-test/r/union.result
+++ b/mysql-test/r/union.result
@@ -1220,6 +1220,32 @@ show columns from t2;
Field Type Null Key Default Extra
a varchar(3) YES NULL
drop table t2, t1;
+create table t1 (f1 decimal(60,25), f2 decimal(60,25));
+insert into t1 values (0.0,0.0);
+select f1 from t1 union all select f2 from t1;
+f1
+0.0000000000000000000000000
+0.0000000000000000000000000
+select 'XXXXXXXXXXXXXXXXXXXX' as description, f1 from t1
+union all
+select 'YYYYYYYYYYYYYYYYYYYY' as description, f2 from t1;
+description f1
+XXXXXXXXXXXXXXXXXXXX 0.0000000000000000000000000
+YYYYYYYYYYYYYYYYYYYY 0.0000000000000000000000000
+drop table t1;
+create table t1 (f1 decimal(60,24), f2 decimal(60,24));
+insert into t1 values (0.0,0.0);
+select f1 from t1 union all select f2 from t1;
+f1
+0.000000000000000000000000
+0.000000000000000000000000
+select 'XXXXXXXXXXXXXXXXXXXX' as description, f1 from t1
+union all
+select 'YYYYYYYYYYYYYYYYYYYY' as description, f2 from t1;
+description f1
+XXXXXXXXXXXXXXXXXXXX 0.000000000000000000000000
+YYYYYYYYYYYYYYYYYYYY 0.000000000000000000000000
+drop table t1;
create table t1 (a varchar(5));
create table t2 select * from t1 union select 'abcdefghijkl';
show create table t2;
@@ -1270,29 +1296,3 @@ id
5
99
drop table t1;
-create table t1 (f1 decimal(60,25), f2 decimal(60,25));
-insert into t1 values (0.0,0.0);
-select f1 from t1 union all select f2 from t1;
-f1
-0.0000000000000000000000000
-0.0000000000000000000000000
-select 'XXXXXXXXXXXXXXXXXXXX' as description, f1 from t1
-union all
-select 'YYYYYYYYYYYYYYYYYYYY' as description, f2 from t1;
-description f1
-XXXXXXXXXXXXXXXXXXXX 0.0000000000000000000000000
-YYYYYYYYYYYYYYYYYYYY 0.0000000000000000000000000
-drop table t1;
-create table t1 (f1 decimal(60,24), f2 decimal(60,24));
-insert into t1 values (0.0,0.0);
-select f1 from t1 union all select f2 from t1;
-f1
-0.000000000000000000000000
-0.000000000000000000000000
-select 'XXXXXXXXXXXXXXXXXXXX' as description, f1 from t1
-union all
-select 'YYYYYYYYYYYYYYYYYYYY' as description, f2 from t1;
-description f1
-XXXXXXXXXXXXXXXXXXXX 0.000000000000000000000000
-YYYYYYYYYYYYYYYYYYYY 0.000000000000000000000000
-drop table t1;