diff options
| author | Alexey Kopytov <Alexey.Kopytov@sun.com> | 2009-03-27 13:40:35 +0300 |
|---|---|---|
| committer | Alexey Kopytov <Alexey.Kopytov@sun.com> | 2009-03-27 13:40:35 +0300 |
| commit | 1b93843864c16cc98494c0c805828d142eb5065d (patch) | |
| tree | 2443db07ded3aa10caee6e9992b00b054780063c /mysql-test/r/union.result | |
| parent | 15baa13f84b9880eb9217a3c3b4f19c51bdfaf2d (diff) | |
| parent | 0b60184b90cfb7ed1eb927e5106eb194677d43f7 (diff) | |
| download | mariadb-git-1b93843864c16cc98494c0c805828d142eb5065d.tar.gz | |
Manual merge.
Diffstat (limited to 'mysql-test/r/union.result')
| -rw-r--r-- | mysql-test/r/union.result | 12 |
1 files changed, 12 insertions, 0 deletions
diff --git a/mysql-test/r/union.result b/mysql-test/r/union.result index 2a10f34d081..b89ce61100c 100644 --- a/mysql-test/r/union.result +++ b/mysql-test/r/union.result @@ -1562,4 +1562,16 @@ DESC t6; Field Type Null Key Default Extra NULL int(11) YES NULL DROP TABLE t1, t2, t3, t4, t5, t6; +CREATE TABLE t1 (f FLOAT(9,6)); +CREATE TABLE t2 AS SELECT f FROM t1 UNION SELECT f FROM t1; +SHOW FIELDS FROM t2; +Field Type Null Key Default Extra +f float(9,6) YES NULL +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; +Field Type Null Key Default Extra +d double(9,6) YES NULL +DROP TABLE t1, t2; End of 5.0 tests |