From 8a27426fcdac4f2422f83cec2928004fd9074962 Mon Sep 17 00:00:00 2001 From: unknown Date: Fri, 6 May 2005 01:01:39 +0500 Subject: Tests and results fixed with last precision/decimal related modifications mysql-test/r/case.result: test result fixed mysql-test/r/create.result: test result fixed mysql-test/r/distinct.result: test result fixed mysql-test/r/func_group.result: test result fixed mysql-test/r/func_op.result: test result fixed mysql-test/r/group_by.result: test result fixed mysql-test/r/metadata.result: test result fixed mysql-test/r/olap.result: test result fixed mysql-test/r/ps_2myisam.result: test result fixed mysql-test/r/ps_3innodb.result: test result fixed mysql-test/r/ps_4heap.result: test result fixed mysql-test/r/ps_5merge.result: test result fixed mysql-test/r/ps_6bdb.result: test result fixed mysql-test/r/ps_7ndb.result: test result fixed mysql-test/r/select.result: test result fixed mysql-test/r/sp.result: test result fixed mysql-test/r/type_decimal.result: test result fixed mysql-test/r/type_newdecimal.result: test result fixed mysql-test/r/union.result: test result fixed mysql-test/r/variables.result: test result fixed mysql-test/t/func_group.test: test modified mysql-test/t/olap.test: test modified mysql-test/t/type_decimal.test: test modified --- mysql-test/r/case.result | 10 +++++----- 1 file changed, 5 insertions(+), 5 deletions(-) (limited to 'mysql-test/r/case.result') diff --git a/mysql-test/r/case.result b/mysql-test/r/case.result index 1ca913e1259..5fb21004469 100644 --- a/mysql-test/r/case.result +++ b/mysql-test/r/case.result @@ -105,9 +105,9 @@ t1 CREATE TABLE `t1` ( `c4` varbinary(1) NOT NULL default '', `c5` varbinary(4) NOT NULL default '', `c6` varbinary(4) NOT NULL default '', - `c7` decimal(5,1) NOT NULL default '0.0', - `c8` decimal(5,1) NOT NULL default '0.0', - `c9` decimal(5,1) default NULL, + `c7` decimal(2,1) NOT NULL default '0.0', + `c8` decimal(2,1) NOT NULL default '0.0', + `c9` decimal(2,1) default NULL, `c10` double NOT NULL default '0', `c11` double NOT NULL default '0', `c12` varbinary(5) NOT NULL default '' @@ -152,9 +152,9 @@ SHOW CREATE TABLE t1; Table Create Table t1 CREATE TABLE `t1` ( `COALESCE(1)` int(1) NOT NULL default '0', - `COALESCE(1.0)` decimal(5,1) NOT NULL default '0.0', + `COALESCE(1.0)` decimal(2,1) NOT NULL default '0.0', `COALESCE('a')` varchar(1) NOT NULL default '', - `COALESCE(1,1.0)` decimal(5,1) NOT NULL default '0.0', + `COALESCE(1,1.0)` decimal(2,1) NOT NULL default '0.0', `COALESCE(1,'1')` varbinary(1) NOT NULL default '', `COALESCE(1.1,'1')` varbinary(4) NOT NULL default '', `COALESCE('a' COLLATE latin1_bin,'b')` varchar(1) character set latin1 collate latin1_bin NOT NULL default '' -- cgit v1.2.1