diff options
| author | holyfoot@hf-ibm.(none) <> | 2005-05-06 01:01:39 +0500 |
|---|---|---|
| committer | holyfoot@hf-ibm.(none) <> | 2005-05-06 01:01:39 +0500 |
| commit | 8f3647005c253f30825d4e2e560d86783b611f8a (patch) | |
| tree | 2a5b7c2ccfaeb6ea061bc33fe28c66d4988ff336 /mysql-test/r/create.result | |
| parent | 196a87cbd68966012d0b71c7f92846719991b86e (diff) | |
| download | mariadb-git-8f3647005c253f30825d4e2e560d86783b611f8a.tar.gz | |
Tests and results fixed with last precision/decimal related modifications
Diffstat (limited to 'mysql-test/r/create.result')
| -rw-r--r-- | mysql-test/r/create.result | 8 |
1 files changed, 4 insertions, 4 deletions
diff --git a/mysql-test/r/create.result b/mysql-test/r/create.result index 4f4400b4a9b..82c0f4c1ce5 100644 --- a/mysql-test/r/create.result +++ b/mysql-test/r/create.result @@ -115,9 +115,9 @@ Field Type Null Key Default Extra a datetime NO 0000-00-00 00:00:00 b time NO 00:00:00 c date NO 0000-00-00 -d int(2) NO 0 -e decimal(6,1) NO 0.0 -f bigint(18) NO 0 +d int(3) NO 0 +e decimal(3,1) NO 0.0 +f bigint(19) NO 0 drop table t2; create table t2 select CAST("2001-12-29" AS DATE) as d, CAST("20:45:11" AS TIME) as t, CAST("2001-12-29 20:45:11" AS DATETIME) as dt; describe t2; @@ -453,7 +453,7 @@ t2 CREATE TABLE `t2` ( `ifnull(e,e)` bigint(20) default NULL, `ifnull(f,f)` float(3,2) default NULL, `ifnull(g,g)` double(4,3) default NULL, - `ifnull(h,h)` decimal(6,4) default NULL, + `ifnull(h,h)` decimal(5,4) default NULL, `ifnull(i,i)` year(4) default NULL, `ifnull(j,j)` date default NULL, `ifnull(k,k)` datetime NOT NULL default '0000-00-00 00:00:00', |