diff options
| author | unknown <konstantin@mysql.com> | 2006-01-16 22:31:13 +0300 |
|---|---|---|
| committer | unknown <konstantin@mysql.com> | 2006-01-16 22:31:13 +0300 |
| commit | e1c4d6d8e5c75a5828e7fffe1d5f97e95b45cabd (patch) | |
| tree | b7ca4184ec490b91302257cd7289c720c5ca6565 /mysql-test/r | |
| parent | a4a906b9716ee2a447bd83996b6abe5482cd0e02 (diff) | |
| download | mariadb-git-e1c4d6d8e5c75a5828e7fffe1d5f97e95b45cabd.tar.gz | |
A test case for Bug#7670 "Loss of precision for some integer
values stored into DOUBLE column" (Can't repeat)
mysql-test/r/type_decimal.result:
Test results fixed (Bug#7670)
mysql-test/t/type_decimal.test:
A test case for Bug#7670
Diffstat (limited to 'mysql-test/r')
| -rw-r--r-- | mysql-test/r/type_decimal.result | 13 |
1 files changed, 13 insertions, 0 deletions
diff --git a/mysql-test/r/type_decimal.result b/mysql-test/r/type_decimal.result index d7f5f9fa328..df5abfe8ae3 100644 --- a/mysql-test/r/type_decimal.result +++ b/mysql-test/r/type_decimal.result @@ -772,3 +772,16 @@ productid zlevelprice 003trans 39.98 004trans 31.18 drop table t1, t2; +create table t1 (a double(53,0)); +insert into t1 values (9988317491112007680) ,(99883133042600208184115200); +select a from t1; +a +9988317491112007680 +99883133042600208184115200 +truncate t1; +insert into t1 values (9988317491112007680.0) ,(99883133042600208184115200.0); +select a from t1; +a +9988317491112007680 +99883133042600208184115200 +drop table t1; |