diff options
| author | unknown <msvensson@pilot.mysql.com> | 2007-10-15 10:59:01 +0200 |
|---|---|---|
| committer | unknown <msvensson@pilot.mysql.com> | 2007-10-15 10:59:01 +0200 |
| commit | 70ee3aa75fada72b193797e26496c91906f4cbf8 (patch) | |
| tree | 5451670f8a7266ace1ef9b98c103daf46604a28b /mysql-test/r/type_float.result | |
| parent | 8b7ee0d67aa1d43b229b10b56c5a9362571c5802 (diff) | |
| parent | 13afffd03b80ab73d813158f3d0a1ebf63a5ef31 (diff) | |
| download | mariadb-git-70ee3aa75fada72b193797e26496c91906f4cbf8.tar.gz | |
Merge pilot.mysql.com:/data/msvensson/mysql/mysql-5.0-maint
into pilot.mysql.com:/data/msvensson/mysql/mysql-5.1-new-maint
libmysql/libmysql.c:
Auto merged
mysql-test/r/type_float.result:
Auto merged
mysql-test/t/type_float.test:
Auto merged
Diffstat (limited to 'mysql-test/r/type_float.result')
| -rw-r--r-- | mysql-test/r/type_float.result | 16 |
1 files changed, 16 insertions, 0 deletions
diff --git a/mysql-test/r/type_float.result b/mysql-test/r/type_float.result index 33ad3928835..6fbc8268a64 100644 --- a/mysql-test/r/type_float.result +++ b/mysql-test/r/type_float.result @@ -344,6 +344,22 @@ create table t1 (s1 float(0,2)); ERROR 42000: For float(M,D), double(M,D) or decimal(M,D), M must be >= D (column 's1'). create table t1 (s1 float(1,2)); ERROR 42000: For float(M,D), double(M,D) or decimal(M,D), M must be >= D (column 's1'). +CREATE TABLE t1 ( +f1 real zerofill, +f2 double zerofill, +f3 float zerofill); +INSERT INTO t1 VALUES ( 0.314152e+1, 0.314152e+1, 0.314152e+1); +PREPARE stmt1 FROM 'select f1, f2, f3 FROM t1'; +select f1, f2, f3 FROM t1; +f1 f2 f3 +0000000000000003.14152 0000000000000003.14152 000003.14152 +select f1, f2, f3 FROM t1; +f1 f2 f3 +0000000000000003.14152 0000000000000003.14152 000003.14152 +EXECUTE stmt1; +f1 f2 f3 +0000000000000003.14152 0000000000000003.14152 000003.14152 +DROP TABLE t1; create table t1 (f1 double(200, 0)); insert into t1 values (1e199), (-1e199); insert into t1 values (1e200), (-1e200); |