summaryrefslogtreecommitdiff
path: root/storage/connect/mysql-test/connect/t/secure_file_priv.test
blob: 466335020341beddaa53bb3793516b34498fe144 (plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
let $DATADIR= `select @@datadir`;
let $SECUREDIR= `select @@secure_file_priv`;

--replace_result $DATADIR DATADIR
--error ER_OPTION_PREVENTS_STATEMENT
--eval CREATE TABLE t1 (a INT NOT NULL) ENGINE=CONNECT TABLE_TYPE=DBF FILE_NAME='$DATADIR/t1.dbf'

--replace_result $SECUREDIR SECUREDATADIR
--eval CREATE TABLE t1 (a INT NOT NULL) ENGINE=CONNECT TABLE_TYPE=DBF FILE_NAME='$SECUREDIR/t1.dbf'
INSERT INTO t1 VALUES (10);
SELECT * FROM t1;
DROP TABLE t1;
--remove_file $SECUREDIR/t1.dbf