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