diff options
author | Alexey Kopytov <alexeyk@mysql.com> | 2008-12-07 17:51:22 +0300 |
---|---|---|
committer | Alexey Kopytov <alexeyk@mysql.com> | 2008-12-07 17:51:22 +0300 |
commit | 6aa4125be3ff8d910fff82ff53ace4075a39cc94 (patch) | |
tree | 82715ba21e2d49dfb58b215e7cc5d9af0294a0b6 /mysql-test/r/type_float.result | |
parent | 014143e8588c4313ccf10e269aa34a997f5772b6 (diff) | |
parent | 91f0c94c23eb9b48421d9590662666de9e4c75d5 (diff) | |
download | mariadb-git-6aa4125be3ff8d910fff82ff53ace4075a39cc94.tar.gz |
Merge from mysql-5.0-bugteam to mysql-5.1-bugteam.
Diffstat (limited to 'mysql-test/r/type_float.result')
-rw-r--r-- | mysql-test/r/type_float.result | 13 |
1 files changed, 13 insertions, 0 deletions
diff --git a/mysql-test/r/type_float.result b/mysql-test/r/type_float.result index 6fbc8268a64..49edaf06847 100644 --- a/mysql-test/r/type_float.result +++ b/mysql-test/r/type_float.result @@ -392,4 +392,17 @@ f1 + 0e0 1.0000000150475e+30 -1.0000000150475e+30 drop table t1; +create table t1(d double, u bigint unsigned); +insert into t1(d) values (9.2233720368547777e+18), +(9.223372036854779e18), +(9.22337203685479e18), +(1.84e19); +update t1 set u = d; +select * from t1; +d u +9.22337203685478e+18 9223372036854775808 +9.22337203685478e+18 9223372036854779904 +9.22337203685479e+18 9223372036854790144 +1.84e+19 18400000000000000000 +drop table t1; End of 5.0 tests |