2
DROP TABLE IF EXISTS t1;
5
# test file not existed
6
--error ER_CANT_CREATE_TABLE
7
CREATE TABLE t1 (a INT) ENGINE=FILESYSTEM,FILE="../../filesystem_ln/_FILE_NOT_EXISTED_";
9
# test col separator not empty
10
--error ER_UNKNOWN_ENGINE_OPTION
11
CREATE TABLE t1 (a INT) ENGINE=FILESYSTEM,FILE="../../filesystem_ln/basic_create_table.data",COL_SEPARATOR="";
13
# test row separator not empty
14
--error ER_UNKNOWN_ENGINE_OPTION
15
CREATE TABLE t1 (a INT) ENGINE=FILESYSTEM,FILE="../../filesystem_ln/basic_create_table.data",ROW_SEPARATOR="";
17
CREATE TABLE t1 (a INT) ENGINE=FILESYSTEM,FILE="../../filesystem_ln/basic_create_table.data";
20
--error ER_TABLE_EXISTS_ERROR
21
CREATE TABLE t1 (a INT) ENGINE=FILESYSTEM,FILE="../../filesystem_ln/basic_create_table.data";