diff options
| author | unknown <kaa@polly.(none)> | 2007-10-23 13:19:54 +0400 |
|---|---|---|
| committer | unknown <kaa@polly.(none)> | 2007-10-23 13:19:54 +0400 |
| commit | 251b083ed767b5a58b34dafc6d8a3cf9c602841d (patch) | |
| tree | 232aedbfbe8c6aab6ae751cc9fd7663e6044a655 /mysql-test/t/insert.test | |
| parent | b05b0182f944d484ffeec828853014665db0c236 (diff) | |
| parent | 4eec3b087de468382f6c4e9eb2397cacfc18821f (diff) | |
| download | mariadb-git-251b083ed767b5a58b34dafc6d8a3cf9c602841d.tar.gz | |
Merge polly.(none):/home/kaa/src/maint/bug30453/my50-bug28878
into polly.(none):/home/kaa/src/maint/bug30453/my51-bug28878
mysql-test/r/insert.result:
Auto merged
mysql-test/t/insert.test:
Auto merged
strings/ctype-simple.c:
Manual merge.
Diffstat (limited to 'mysql-test/t/insert.test')
| -rw-r--r-- | mysql-test/t/insert.test | 15 |
1 files changed, 15 insertions, 0 deletions
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. |