summaryrefslogtreecommitdiff
path: root/mysql-test/r/func_sapdb.result
diff options
context:
space:
mode:
Diffstat (limited to 'mysql-test/r/func_sapdb.result')
-rw-r--r--mysql-test/r/func_sapdb.result10
1 files changed, 5 insertions, 5 deletions
diff --git a/mysql-test/r/func_sapdb.result b/mysql-test/r/func_sapdb.result
index e330c73727b..38bd73bca0f 100644
--- a/mysql-test/r/func_sapdb.result
+++ b/mysql-test/r/func_sapdb.result
@@ -159,14 +159,14 @@ time("1997-12-31 23:59:59.000001") as f9;
describe t1;
Field Type Null Key Default Extra
f1 date 0000-00-00
-f2 datetime 0000-00-00 00:00:00
-f3 time 00:00:00
+f2 datetime YES NULL
+f3 time YES NULL
f4 time 00:00:00
f5 time 00:00:00
f6 time 00:00:00
-f7 datetime 0000-00-00 00:00:00
-f8 date 0000-00-00
-f9 time 00:00:00
+f7 datetime YES NULL
+f8 date YES NULL
+f9 time YES NULL
select * from t1;
f1 f2 f3 f4 f5 f6 f7 f8 f9
1997-01-01 1998-01-02 01:01:00 49:01:01 46:58:57 -23:59:59 10:11:12 2001-12-01 01:01:01 1997-12-31 23:59:59