diff options
| author | unknown <sanja@montyprogram.com> | 2014-03-14 09:31:16 +0200 |
|---|---|---|
| committer | unknown <sanja@montyprogram.com> | 2014-03-14 09:31:16 +0200 |
| commit | f9b3cc11bc7a2851731b1cf4055c16069b17ad76 (patch) | |
| tree | a10f73d292d2df59052f9cc148670585aaed5997 /mysql-test/r/type_float.result | |
| parent | e63c03db8d620765b7a1bc769150a04a230b9353 (diff) | |
| download | mariadb-git-f9b3cc11bc7a2851731b1cf4055c16069b17ad76.tar.gz | |
MDEV-5819: MySQL Bug #13500371 63704: CONVERSION OF '1.' TO A NUMBER GIVES ERROR 1265 (WARN_DATA_TRUNCATED)
Fix by MySQL ported
Diffstat (limited to 'mysql-test/r/type_float.result')
| -rw-r--r-- | mysql-test/r/type_float.result | 18 |
1 files changed, 18 insertions, 0 deletions
diff --git a/mysql-test/r/type_float.result b/mysql-test/r/type_float.result index f41c2e7688b..f498b6889a5 100644 --- a/mysql-test/r/type_float.result +++ b/mysql-test/r/type_float.result @@ -447,3 +447,21 @@ End of 5.0 tests select format(truncate('1.7976931348623157E+308',-12),1,'fr_BE') as foo; foo 0 +# +# Bug #13500371 63704: CONVERSION OF '1.' TO A NUMBER GIVES ERROR 1265 +# (WARN_DATA_TRUNCATED) +# +CREATE TABLE t1 (f FLOAT); +INSERT INTO t1 VALUES ('1.'); +INSERT INTO t1 VALUES ('2.0.'); +Warnings: +Warning 1265 Data truncated for column 'f' at row 1 +INSERT INTO t1 VALUES ('.'); +Warnings: +Warning 1265 Data truncated for column 'f' at row 1 +SELECT * FROM t1 ORDER BY f; +f +0 +1 +2 +DROP TABLE t1; |