summaryrefslogtreecommitdiff
path: root/mysql-test/r/func_default.result
diff options
context:
space:
mode:
authorSergei Golubchik <serg@mariadb.org>2016-07-22 13:44:58 +0200
committerSergei Golubchik <serg@mariadb.org>2016-08-27 16:59:12 +0200
commit266563ad775fca38dbb5c76a5100fef49515ffda (patch)
treee94b6621fbdde62b2ab9dd1d3af48db866468a9a /mysql-test/r/func_default.result
parent73a220aac3842da0ab8d51fa9961a18b03c45001 (diff)
downloadmariadb-git-266563ad775fca38dbb5c76a5100fef49515ffda.tar.gz
fix: CREATE TABLE (col TIMESTAMP(6) DEFAULT NOW(2))
That is, when the precision of DEFAULT NOW() is less than the precision of the column, do not convert it to unireg_check, use the new approach where DEFAULT is tryly an expression.
Diffstat (limited to 'mysql-test/r/func_default.result')
-rw-r--r--mysql-test/r/func_default.result4
1 files changed, 2 insertions, 2 deletions
diff --git a/mysql-test/r/func_default.result b/mysql-test/r/func_default.result
index aac5f4942a7..535be10da86 100644
--- a/mysql-test/r/func_default.result
+++ b/mysql-test/r/func_default.result
@@ -29,6 +29,6 @@ insert t1 () values ();
insert t1 (a) values (10);
select default(a),default(b),default(c),default(d),default(e),default(f) from t1;
default(a) default(b) default(c) default(d) default(e) default(f)
-1 2 foo bar 2001-01-01 10:20:30 2001-01-01 10:20:30.123456
-1 11 foo bar 2001-01-01 10:20:30 2001-01-01 10:20:30.123456
+1 2 foo bar 2001-01-01 10:20:30 2001-01-01 10:20:30.120000
+1 11 foo bar 2001-01-01 10:20:30 2001-01-01 10:20:30.120000
drop table t1;