diff options
| author | unknown <kaa@polly.(none)> | 2007-10-23 13:39:31 +0400 |
|---|---|---|
| committer | unknown <kaa@polly.(none)> | 2007-10-23 13:39:31 +0400 |
| commit | 7e91dbd3313ac4cbca9ab9e017addcedf41d7b87 (patch) | |
| tree | a1e81fd81b0861dd598392b9323a4dbaab8ec6b0 /mysql-test | |
| parent | 3d54e7320c8791acd7406b26af96552b57a72ca0 (diff) | |
| parent | 251b083ed767b5a58b34dafc6d8a3cf9c602841d (diff) | |
| download | mariadb-git-7e91dbd3313ac4cbca9ab9e017addcedf41d7b87.tar.gz | |
Merge polly.(none):/home/kaa/src/maint/bug30453/my51-bug28878
into polly.(none):/home/kaa/src/maint/mysql-5.1-maint
Diffstat (limited to 'mysql-test')
| -rw-r--r-- | mysql-test/r/insert.result | 14 | ||||
| -rw-r--r-- | mysql-test/t/insert.test | 15 |
2 files changed, 29 insertions, 0 deletions
diff --git a/mysql-test/r/insert.result b/mysql-test/r/insert.result index 8dbba4d454a..a884b51eada 100644 --- a/mysql-test/r/insert.result +++ b/mysql-test/r/insert.result @@ -499,4 +499,18 @@ i 2 2 DROP TABLE t1, t2; +CREATE TABLE t1 (c1 INT NOT NULL); +INSERT INTO t1 VALUES(4188.32999999999992724042385816574096679687500), +('4188.32999999999992724042385816574096679687500'), (4188); +SELECT * FROM t1; +c1 +4188 +4188 +4188 +CREATE TABLE t2 (c1 BIGINT); +INSERT INTO t2 VALUES('15449237462.0000000000'); +SELECT * FROM t2; +c1 +15449237462 +DROP TABLE t1, t2; End of 5.0 tests. diff --git a/mysql-test/t/insert.test b/mysql-test/t/insert.test index 3d32da9c3b7..59da875bb24 100644 --- a/mysql-test/t/insert.test +++ b/mysql-test/t/insert.test @@ -387,5 +387,20 @@ SELECT * FROM t2; DROP TABLE t1, t2; +# +# Bug #30453: String not cast to int correctly +# + +CREATE TABLE t1 (c1 INT NOT NULL); +INSERT INTO t1 VALUES(4188.32999999999992724042385816574096679687500), +('4188.32999999999992724042385816574096679687500'), (4188); +SELECT * FROM t1; + +CREATE TABLE t2 (c1 BIGINT); +INSERT INTO t2 VALUES('15449237462.0000000000'); +SELECT * FROM t2; + +DROP TABLE t1, t2; + --echo End of 5.0 tests. |