diff options
author | Alexander Barkov <bar@mariadb.com> | 2019-05-14 21:47:38 +0400 |
---|---|---|
committer | Alexander Barkov <bar@mariadb.com> | 2019-05-15 07:21:00 +0400 |
commit | 462d6893977f31ffd4cb35f7eb76b521acfd1fb4 (patch) | |
tree | 38ada44127c26fc8c833988b09a42dbe22186c7c /mysql-test/main/type_float.test | |
parent | 49373397057aac63b4ce1557c941d508ea87be99 (diff) | |
download | mariadb-git-462d6893977f31ffd4cb35f7eb76b521acfd1fb4.tar.gz |
MDEV-19468 Hybrid type expressions return wrong format for FLOAT
Diffstat (limited to 'mysql-test/main/type_float.test')
-rw-r--r-- | mysql-test/main/type_float.test | 37 |
1 files changed, 37 insertions, 0 deletions
diff --git a/mysql-test/main/type_float.test b/mysql-test/main/type_float.test index 9dba1c709d5..5f9958dbe2b 100644 --- a/mysql-test/main/type_float.test +++ b/mysql-test/main/type_float.test @@ -581,3 +581,40 @@ DROP TABLE t1; --echo # --echo # End of 10.2 tests --echo # + +--echo # +--echo # Start of 10.3 tests +--echo # + +--echo # +--echo # MDEV-19468 Hybrid type expressions return wrong format for FLOAT +--echo # + +CREATE TABLE t1 (a FLOAT); +INSERT INTO t1 VALUES (0.671437); +SELECT a, COALESCE(a), MAX(a), LEAST(a,a), (SELECT a FROM t1) AS c FROM t1; +DROP TABLE t1; + +CREATE TABLE t1 (a FLOAT); +INSERT INTO t1 VALUES (0.671437); +SELECT + CONCAT(a), + CONCAT(COALESCE(a)), + CONCAT(LEAST(a,a)), + CONCAT(MAX(a)), + CONCAT((SELECT a FROM t1)) AS c +FROM t1; +CREATE TABLE t2 AS SELECT + CONCAT(a), + CONCAT(COALESCE(a)), + CONCAT(LEAST(a,a)), + CONCAT(MAX(a)), + CONCAT((SELECT a FROM t1)) AS c +FROM t1; +SELECT * FROM t2; +DROP TABLE t1, t2; + + +--echo # +--echo # End of 10.3 tests +--echo # |