diff options
| author | Andrei Elkin <aelkin@mysql.com> | 2008-12-08 16:29:13 +0200 |
|---|---|---|
| committer | Andrei Elkin <aelkin@mysql.com> | 2008-12-08 16:29:13 +0200 |
| commit | 0ec3e14e984d9972236c5fe13a340441ee6118e9 (patch) | |
| tree | 0de385e74b751c121550638b36dfafcdd918a4c5 /mysql-test | |
| parent | cea55f3dc68953050dacd5366a7003e2ab29cdcf (diff) | |
| parent | 772685705cebbd7ac35f186076f1c33441478dc8 (diff) | |
| download | mariadb-git-0ec3e14e984d9972236c5fe13a340441ee6118e9.tar.gz | |
merge 5.0->5.0-bugteam for a local tree containing bug#33420 Test 'rpl_packet' fails randomly.
Diffstat (limited to 'mysql-test')
| -rw-r--r-- | mysql-test/r/type_float.result | 13 | ||||
| -rw-r--r-- | mysql-test/t/type_float.test | 17 |
2 files changed, 30 insertions, 0 deletions
diff --git a/mysql-test/r/type_float.result b/mysql-test/r/type_float.result index f1075604ca9..e7f17bd75a7 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 diff --git a/mysql-test/t/type_float.test b/mysql-test/t/type_float.test index 9aa8c00d24a..b23755b44fb 100644 --- a/mysql-test/t/type_float.test +++ b/mysql-test/t/type_float.test @@ -252,4 +252,21 @@ insert into t1 values (2e30), (-2e30); select f1 + 0e0 from t1; drop table t1; +# +# Bug #27483: Casting 'scientific notation type' to 'unsigned bigint' fails on +# windows. +# + +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; + +drop table t1; + --echo End of 5.0 tests |