diff options
| author | unknown <gluh@gluh.mysql.r18.ru> | 2003-12-10 18:41:14 +0400 |
|---|---|---|
| committer | unknown <gluh@gluh.mysql.r18.ru> | 2003-12-10 18:41:14 +0400 |
| commit | 02cf765fba0a6cf88d7166c737e227f9c389f87c (patch) | |
| tree | b9ec762dfc9d686d0f6604688e6c37b371abff55 /mysql-test | |
| parent | 2e4343c85a1807a8f84eecf346c08f97b5a6f524 (diff) | |
| parent | 568d3a5d231cd9e3816d91bd40ae70845e7e8e64 (diff) | |
| download | mariadb-git-02cf765fba0a6cf88d7166c737e227f9c389f87c.tar.gz | |
Merge sgluhov@bk-internal.mysql.com:/home/bk/mysql-4.0
into gluh.mysql.r18.ru:/home/gluh/mysql-4.0.ssl
Diffstat (limited to 'mysql-test')
| -rw-r--r-- | mysql-test/r/mysqldump.result | 48 | ||||
| -rw-r--r-- | mysql-test/t/mysqldump.test | 19 |
2 files changed, 67 insertions, 0 deletions
diff --git a/mysql-test/r/mysqldump.result b/mysql-test/r/mysqldump.result index 085cf2788f9..01edd10b896 100644 --- a/mysql-test/r/mysqldump.result +++ b/mysql-test/r/mysqldump.result @@ -15,3 +15,51 @@ INSERT INTO t1 VALUES (1), (2); </database> </mysqldump> DROP TABLE t1; +CREATE TABLE t1 (a decimal(240, 20)); +INSERT INTO t1 VALUES ("1234567890123456789012345678901234567890"), +("0987654321098765432109876543210987654321"); +-- MySQL dump 9.09 +-- +-- Host: localhost Database: test +-- ------------------------------------------------------ +-- Server version 4.0.17-debug-log + +-- +-- Table structure for table `t1` +-- + +CREATE TABLE t1 ( + a decimal(240,20) default NULL +) TYPE=MyISAM; + +-- +-- Dumping data for table `t1` +-- + +INSERT INTO t1 VALUES ("1234567890123456789012345678901234567890.00000000000000000000"); +INSERT INTO t1 VALUES ("0987654321098765432109876543210987654321.00000000000000000000"); + +DROP TABLE t1; +CREATE TABLE t1 (a double); +INSERT INTO t1 VALUES (-9e999999); +-- MySQL dump 9.09 +-- +-- Host: localhost Database: test +-- ------------------------------------------------------ +-- Server version 4.0.17-debug-log + +-- +-- Table structure for table `t1` +-- + +CREATE TABLE t1 ( + a double default NULL +) TYPE=MyISAM; + +-- +-- Dumping data for table `t1` +-- + +INSERT INTO t1 VALUES (NULL); + +DROP TABLE t1; diff --git a/mysql-test/t/mysqldump.test b/mysql-test/t/mysqldump.test index c98fd4050f2..87363855db0 100644 --- a/mysql-test/t/mysqldump.test +++ b/mysql-test/t/mysqldump.test @@ -8,3 +8,22 @@ CREATE TABLE t1(a int); INSERT INTO t1 VALUES (1), (2); --exec $MYSQL_DUMP -X test t1 DROP TABLE t1; + +# +# Bug #2005 +# + +CREATE TABLE t1 (a decimal(240, 20)); +INSERT INTO t1 VALUES ("1234567890123456789012345678901234567890"), +("0987654321098765432109876543210987654321"); +--exec $MYSQL_DUMP test t1 +DROP TABLE t1; + +# +# Bug #2055 +# + +CREATE TABLE t1 (a double); +INSERT INTO t1 VALUES (-9e999999); +--exec $MYSQL_DUMP test t1 +DROP TABLE t1; |