diff options
Diffstat (limited to 'mysql-test/r/function_defaults_innodb.result')
| -rw-r--r-- | mysql-test/r/function_defaults_innodb.result | 4 |
1 files changed, 4 insertions, 0 deletions
diff --git a/mysql-test/r/function_defaults_innodb.result b/mysql-test/r/function_defaults_innodb.result index fe97870ab88..4dc353e2663 100644 --- a/mysql-test/r/function_defaults_innodb.result +++ b/mysql-test/r/function_defaults_innodb.result @@ -6,6 +6,7 @@ set default_storage_engine=innodb; # Function defaults run 1. No microsecond precision. # SET TIME_ZONE = "+00:00"; +SET sql_mode = 'NO_ENGINE_SUBSTITUTION'; # # Test of errors for column data types that dont support function # defaults. @@ -1548,10 +1549,12 @@ a b 1999-12-01 11:22:33 1999-12-01 11:22:33 2001-09-09 04:46:40 2001-09-09 04:46:40 DROP TABLE t1; +SET sql_mode = DEFAULT; # # Function defaults run 2. Six digits scale on seconds precision. # SET TIME_ZONE = "+00:00"; +SET sql_mode = 'NO_ENGINE_SUBSTITUTION'; # # Test of errors for column data types that dont support function # defaults. @@ -3094,3 +3097,4 @@ a b 1999-12-01 11:22:33.000000 1999-12-01 11:22:33.000000 2001-09-09 04:46:40.000000 2001-09-09 04:46:40.000000 DROP TABLE t1; +SET sql_mode = DEFAULT; |