1let $DATADIR= `select @@datadir`;
2let $SECUREDIR= `select @@secure_file_priv`;
3
4--replace_result $DATADIR DATADIR
5--error ER_OPTION_PREVENTS_STATEMENT
6--eval CREATE TABLE t1 (a INT NOT NULL) ENGINE=CONNECT TABLE_TYPE=DBF FILE_NAME='$DATADIR/t1.dbf'
7
8--replace_result $SECUREDIR SECUREDATADIR
9--eval CREATE TABLE t1 (a INT NOT NULL) ENGINE=CONNECT TABLE_TYPE=DBF FILE_NAME='$SECUREDIR/t1.dbf'
10INSERT INTO t1 VALUES (10);
11SELECT * FROM t1;
12DROP TABLE t1;
13--remove_file $MYSQL_TMP_DIR/t1.dbf
14