summaryrefslogtreecommitdiff
path: root/mysql-test/r/variables.result
diff options
context:
space:
mode:
authorhf@deer.(none) <>2005-02-09 02:50:45 +0400
committerhf@deer.(none) <>2005-02-09 02:50:45 +0400
commitb94a482ee9fdc45b64eb001a908f52784dfabcc1 (patch)
tree9631c72d46b0fd08479ad02de00e5846cd339cda /mysql-test/r/variables.result
parent6e6daf818943e34d72017f64e496d6d94c90134f (diff)
downloadmariadb-git-b94a482ee9fdc45b64eb001a908f52784dfabcc1.tar.gz
Precision Math implementation
Diffstat (limited to 'mysql-test/r/variables.result')
-rw-r--r--mysql-test/r/variables.result9
1 files changed, 5 insertions, 4 deletions
diff --git a/mysql-test/r/variables.result b/mysql-test/r/variables.result
index 1659a9dddb5..57b73a0515e 100644
--- a/mysql-test/r/variables.result
+++ b/mysql-test/r/variables.result
@@ -500,14 +500,15 @@ t1 CREATE TABLE `t1` (
`c5` bigint(20) default NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1
drop table t1;
-set @arg00= 8, @arg01= 8.8, @arg02= 'a string';
-create table t1 as select @arg00 as c1, @arg01 as c2, @arg02 as c3;
+set @arg00= 8, @arg01= 8.8, @arg02= 'a string', @arg03= 0.2e0;
+create table t1 as select @arg00 as c1, @arg01 as c2, @arg02 as c3, @arg03 as c4;
show create table t1;
Table Create Table
t1 CREATE TABLE `t1` (
`c1` bigint(20) default NULL,
- `c2` double default NULL,
- `c3` longtext
+ `c2` decimal(64,30) default NULL,
+ `c3` longtext,
+ `c4` double default NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1
drop table t1;
SET GLOBAL MYISAM_DATA_POINTER_SIZE= 8;