diff options
| author | unknown <jimw@mysql.com> | 2005-11-30 13:10:08 -0800 |
|---|---|---|
| committer | unknown <jimw@mysql.com> | 2005-11-30 13:10:08 -0800 |
| commit | b775d23faaa98297ddd5ed6978b5a214432516d3 (patch) | |
| tree | 85364671b86aac78bc180c91e86162e1a8478c2b /mysql-test/r/union.result | |
| parent | 03e057cd9ec2feb08f00578a9f22801f8656d92d (diff) | |
| download | mariadb-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.result | 52 |
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; |