Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Not a Bug
-
10.2.13
-
None
Description
backup table "test"
result
CREATE TABLE `test` (
`date` datetime NOT NULL `date_format`='YYYY-MM-DD hh:mm:ss'
) ENGINE=CONNECT DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci `TABLE_TYPE`=CSV `FILE_NAME`='text.csv' `HEADER`=1 `SEP_CHAR`=',' `QUOTED`=1;
restore table error
ERROR 1911 (HY000) at line 8097: Unknown option 'date_format'
Not error
CREATE TABLE `test` (
`date` datetime NOT NULL date_format='YYYY-MM-DD hh:mm:ss'
) ENGINE=CONNECT DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci `TABLE_TYPE`=CSV `FILE_NAME`='text.csv' `HEADER`=1 `SEP_CHAR`=',' `QUOTED`=1;