diff options
| author | jimw@mysql.com <> | 2005-11-29 11:52:58 -0800 |
|---|---|---|
| committer | jimw@mysql.com <> | 2005-11-29 11:52:58 -0800 |
| commit | f353bec511bc1346d7ff7d99526004108e7015bf (patch) | |
| tree | 9d576c89a7af36d9d1aae6bdddce1da4749304b8 /mysql-test/t/union.test | |
| parent | 572e338fa8960ccaaf3ce6e1d4226377e4a985a5 (diff) | |
| parent | e55f906130a6c4d96d9202e72934aca1d8c59c1b (diff) | |
| download | mariadb-git-f353bec511bc1346d7ff7d99526004108e7015bf.tar.gz | |
Merge mysql.com:/home/jimw/my/mysql-4.1-14216
into mysql.com:/home/jimw/my/mysql-4.1-clean
Diffstat (limited to 'mysql-test/t/union.test')
| -rw-r--r-- | mysql-test/t/union.test | 18 |
1 files changed, 18 insertions, 0 deletions
diff --git a/mysql-test/t/union.test b/mysql-test/t/union.test index 6a54909536a..1f6fc2c8d3b 100644 --- a/mysql-test/t/union.test +++ b/mysql-test/t/union.test @@ -756,4 +756,22 @@ 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; +# +# Bug #14216: UNION + DECIMAL wrong values in result +# +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; +select 'XXXXXXXXXXXXXXXXXXXX' as description, f1 from t1 +union all +select 'YYYYYYYYYYYYYYYYYYYY' as description, f2 from t1; +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; +select 'XXXXXXXXXXXXXXXXXXXX' as description, f1 from t1 +union all +select 'YYYYYYYYYYYYYYYYYYYY' as description, f2 from t1; +drop table t1; + # End of 4.1 tests |