1
DROP TABLE IF EXISTS t1;
2
CREATE TABLE t1 (a INT) ENGINE=FILESYSTEM,FILE="VARDIR/filesystem_ln/_FILE_NOT_EXISTED_";
3
ERROR HY000: Can't create table 'test.t1' (errno: 2)
4
CREATE TABLE t1 (a INT) ENGINE=FILESYSTEM,FILE="VARDIR/filesystem_ln/basic_create_table.data",COL_SEPARATOR="";
5
ERROR HY000: Unknown table engine option key/pair COL_SEPARATOR = .
6
CREATE TABLE t1 (a INT) ENGINE=FILESYSTEM,FILE="VARDIR/filesystem_ln/basic_create_table.data",ROW_SEPARATOR="";
7
ERROR HY000: Unknown table engine option key/pair ROW_SEPARATOR = .
8
CREATE TABLE t1 (a INT) ENGINE=FILESYSTEM,FILE="VARDIR/filesystem_ln/basic_create_table.data";
9
CREATE TABLE t1 (a INT) ENGINE=FILESYSTEM,FILE="VARDIR/filesystem_ln/basic_create_table.data";
10
ERROR 42S01: Table 'test.t1' already exists
13
t1 CREATE TABLE `t1` (
15
) ENGINE=FILESYSTEM FILE='VARDIR/filesystem_ln/basic_create_table.data' COLLATE = utf8_general_ci