summaryrefslogtreecommitdiff
path: root/storage/connect/mysql-test/connect/t/secure_file_priv.test
blob: f7792536892aef5f84e48f49a780dc9d233063e8 (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 $MYSQL_TMP_DIR/t1.dbf