diff options
| author | Alexey Kopytov <Alexey.Kopytov@sun.com> | 2009-03-27 15:58:34 +0300 |
|---|---|---|
| committer | Alexey Kopytov <Alexey.Kopytov@sun.com> | 2009-03-27 15:58:34 +0300 |
| commit | dcac05be55b40a2be5e0a9d25567caa3c19e75d1 (patch) | |
| tree | 8538630e9ee89f814bc37da8e1a1b32011cb3fb2 /mysql-test/t/union.test | |
| parent | c2c47b67fd6f6130b941a0b50fa701b0bb105ba7 (diff) | |
| parent | 0b60184b90cfb7ed1eb927e5106eb194677d43f7 (diff) | |
| download | mariadb-git-dcac05be55b40a2be5e0a9d25567caa3c19e75d1.tar.gz | |
Automerge.
Diffstat (limited to 'mysql-test/t/union.test')
| -rw-r--r-- | mysql-test/t/union.test | 15 |
1 files changed, 15 insertions, 0 deletions
diff --git a/mysql-test/t/union.test b/mysql-test/t/union.test index 3c792f28d4f..1dbbdae24b7 100644 --- a/mysql-test/t/union.test +++ b/mysql-test/t/union.test @@ -1023,4 +1023,19 @@ SELECT * FROM (SELECT * FROM (SELECT NULL)a) b UNION SELECT a FROM t1; DESC t6; DROP TABLE t1, t2, t3, t4, t5, t6; + +# +# Bug #43432: Union on floats does unnecessary rounding +# + +CREATE TABLE t1 (f FLOAT(9,6)); +CREATE TABLE t2 AS SELECT f FROM t1 UNION SELECT f FROM t1; +SHOW FIELDS FROM t2; +DROP TABLE t1, t2; + +CREATE TABLE t1(d DOUBLE(9,6)); +CREATE TABLE t2 AS SELECT d FROM t1 UNION SELECT d FROM t1; +SHOW FIELDS FROM t2; +DROP TABLE t1, t2; + --echo End of 5.0 tests |