diff options
author | Alexander Barkov <bar@mariadb.com> | 2019-05-16 10:16:09 +0400 |
---|---|---|
committer | Alexander Barkov <bar@mariadb.com> | 2019-05-16 10:16:32 +0400 |
commit | b7d22a843e36cd5b8695f8ac2b92789d1cf50e4f (patch) | |
tree | df7f8b4d747ecec69424e24fe989aeda0df16b44 /mysql-test/main/cast.result | |
parent | e0e805759f5403352debb9a2c97a4c0ee8f3c10f (diff) | |
download | mariadb-git-b7d22a843e36cd5b8695f8ac2b92789d1cf50e4f.tar.gz |
MDEV-16872 Add CAST(expr AS FLOAT)
Diffstat (limited to 'mysql-test/main/cast.result')
-rw-r--r-- | mysql-test/main/cast.result | 4 |
1 files changed, 2 insertions, 2 deletions
diff --git a/mysql-test/main/cast.result b/mysql-test/main/cast.result index 1dc6bbbf9e7..d500ef4fa1d 100644 --- a/mysql-test/main/cast.result +++ b/mysql-test/main/cast.result @@ -271,12 +271,12 @@ select cast(1000 as double(5,2)); cast(1000 as double(5,2)) 999.99 Warnings: -Warning 1264 Out of range value for column 'cast(1000 as double(5,2))' at row 1 +Note 1264 Out of range value for column 'cast(1000 as double(5,2))' at row 1 select cast(-1000 as double(5,2)); cast(-1000 as double(5,2)) -999.99 Warnings: -Warning 1264 Out of range value for column 'cast(-1000 as double(5,2))' at row 1 +Note 1264 Out of range value for column 'cast(-1000 as double(5,2))' at row 1 select cast(010203101112.121314 as datetime); cast(010203101112.121314 as datetime) 2001-02-03 10:11:12 |