diff options
| author | unknown <vva@eagle.mysql.r18.ru> | 2004-04-05 23:18:16 +0500 |
|---|---|---|
| committer | unknown <vva@eagle.mysql.r18.ru> | 2004-04-05 23:18:16 +0500 |
| commit | 280dcf42ab236a3df7d9fea5b24fd88e5ac9800c (patch) | |
| tree | 0fd6f412bcb8636e776d8fd6a514ddbdf4caf764 /mysql-test/r/mysqldump.result | |
| parent | fac3642cc850d86dd927dec456aea19bae706918 (diff) | |
| download | mariadb-git-280dcf42ab236a3df7d9fea5b24fd88e5ac9800c.tar.gz | |
fixed Bug #3361 "mysqldump quotes DECIMAL values"
client/mysqldump.c:
changed quotation mark around DECIMAL field values from " to '
as fix of BUG #3361 "mysqldump quotes DECIMAL values"
mysql-test/r/mysqldump.result:
added test for Bug #3361 "mysqldump quotes DECIMAL values"
mysql-test/t/mysqldump.test:
added test for Bug #3361 "mysqldump quotes DECIMAL values"
Diffstat (limited to 'mysql-test/r/mysqldump.result')
| -rw-r--r-- | mysql-test/r/mysqldump.result | 18 |
1 files changed, 16 insertions, 2 deletions
diff --git a/mysql-test/r/mysqldump.result b/mysql-test/r/mysqldump.result index 837a3627647..714cb42af5e 100644 --- a/mysql-test/r/mysqldump.result +++ b/mysql-test/r/mysqldump.result @@ -22,8 +22,8 @@ CREATE TABLE t1 ( a decimal(240,20) default NULL ) TYPE=MyISAM; -INSERT INTO t1 VALUES ("1234567890123456789012345678901234567890.00000000000000000000"); -INSERT INTO t1 VALUES ("0987654321098765432109876543210987654321.00000000000000000000"); +INSERT INTO t1 VALUES ('1234567890123456789012345678901234567890.00000000000000000000'); +INSERT INTO t1 VALUES ('0987654321098765432109876543210987654321.00000000000000000000'); DROP TABLE t1; CREATE TABLE t1 (a double); @@ -35,3 +35,17 @@ CREATE TABLE t1 ( INSERT INTO t1 VALUES (RES); DROP TABLE t1; +CREATE TABLE t1 (a DECIMAL(10,5), b FLOAT); +INSERT INTO t1 VALUES (1.2345, 2.3456); +INSERT INTO t1 VALUES ('1.2345', 2.3456); +INSERT INTO t1 VALUES ("1.2345", 2.3456); +CREATE TABLE t1 ( + a decimal(10,5) default NULL, + b float default NULL +) TYPE=MyISAM; + +INSERT INTO t1 VALUES ('1.23450',2.3456); +INSERT INTO t1 VALUES ('1.23450',2.3456); +INSERT INTO t1 VALUES ('1.23450',2.3456); + +DROP TABLE t1; |