diff options
author | unknown <msvensson@neptunus.(none)> | 2006-06-12 10:53:14 +0200 |
---|---|---|
committer | unknown <msvensson@neptunus.(none)> | 2006-06-12 10:53:14 +0200 |
commit | 2fbebfec1df2c72bfd33516b9da20181124b22f5 (patch) | |
tree | 80e1cd69d392fefaed1665328433ea107b6d91e7 /mysql-test/r/type_float.result | |
parent | 2dd1dc62462a9b7348d1c815acacddedb5a62d88 (diff) | |
parent | f3c9a47517147dd447f7e668fd1d97c22e2d737a (diff) | |
download | mariadb-git-2fbebfec1df2c72bfd33516b9da20181124b22f5.tar.gz |
Merge neptunus.(none):/home/msvensson/mysql/bug11589/my50-bug11589
into neptunus.(none):/home/msvensson/mysql/bug11589/my50-test_latest
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 61482ab282c..f2392681601 100644 --- a/mysql-test/r/type_float.result +++ b/mysql-test/r/type_float.result @@ -266,3 +266,19 @@ 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; |