diff options
Diffstat (limited to 'mysql-test/r/function_defaults.result')
| -rw-r--r-- | mysql-test/r/function_defaults.result | 4 |
1 files changed, 4 insertions, 0 deletions
diff --git a/mysql-test/r/function_defaults.result b/mysql-test/r/function_defaults.result index 4b8694ec838..a0a8df4ba8f 100644 --- a/mysql-test/r/function_defaults.result +++ b/mysql-test/r/function_defaults.result @@ -5,6 +5,7 @@ # 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. @@ -1547,10 +1548,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. @@ -3093,3 +3096,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; |