summaryrefslogtreecommitdiff
path: root/mysql-test/r/type_float.result
diff options
context:
space:
mode:
Diffstat (limited to 'mysql-test/r/type_float.result')
-rw-r--r--mysql-test/r/type_float.result8
1 files changed, 4 insertions, 4 deletions
diff --git a/mysql-test/r/type_float.result b/mysql-test/r/type_float.result
index 57e2660750b..6cc07cd2549 100644
--- a/mysql-test/r/type_float.result
+++ b/mysql-test/r/type_float.result
@@ -245,22 +245,22 @@ show warnings;
Level Code Message
desc t1;
Field Type Null Key Default Extra
-x decimal(21,2) NO 0.00
+x decimal(21,2) NO NULL
drop table t1;
create table t1 select 0.0 x;
desc t1;
Field Type Null Key Default Extra
-x decimal(2,1) NO 0.0
+x decimal(2,1) NO NULL
create table t2 select 105213674794682365.00 y;
desc t2;
Field Type Null Key Default Extra
-y decimal(20,2) NO 0.00
+y decimal(20,2) NO NULL
create table t3 select x+y a from t1,t2;
show warnings;
Level Code Message
desc t3;
Field Type Null Key Default Extra
-a decimal(21,2) NO 0.00
+a decimal(21,2) NO NULL
drop table t1,t2,t3;
select 1e-308, 1.00000001e-300, 100000000e-300;
1e-308 1.00000001e-300 100000000e-300