177
177
# Bug #29325: create table overwrites .MYD file of other table (datadir)
179
let $MYSQLD_DATADIR= `select @@datadir`;
179
180
SET SESSION keep_files_on_create = TRUE;
180
--write_file $MYSQLTEST_VARDIR/master-data/test/t1.MYD
181
--write_file $MYSQLD_DATADIR/test/t1.MYD
182
183
--disable_abort_on_error
183
184
--error 1,1,ER_TABLE_EXISTS_ERROR
184
185
CREATE TABLE t1 (a INT) ENGINE MYISAM;
186
--remove_file $MYSQLTEST_VARDIR/master-data/test/t1.MYD;
187
--remove_file $MYSQLD_DATADIR/test/t1.MYD;
187
188
--enable_abort_on_error
188
189
SET SESSION keep_files_on_create = FALSE;
189
190
CREATE TABLE t1 (a INT) ENGINE MYISAM;
199
200
# home directory is symlinked, e.g. mysql-test-run --mem.
200
201
# This will be fixed in 6.0 only.
202
--replace_result $MYSQLTEST_VARDIR TEST_DIR
203
--error 0,ER_WRONG_ARGUMENTS
204
eval CREATE TABLE t1(a INT)
205
INDEX DIRECTORY='$MYSQLTEST_VARDIR/master-data/mysql';
207
DROP TABLE IF EXISTS t1;
210
--replace_result $MYSQLTEST_VARDIR TEST_DIR
211
--error 0,ER_WRONG_ARGUMENTS
212
eval CREATE TABLE t1(a INT)
213
DATA DIRECTORY='$MYSQLTEST_VARDIR/master-data/test';
215
DROP TABLE IF EXISTS t1;
218
--replace_result $MYSQLTEST_VARDIR TEST_DIR
219
--error 0,ER_WRONG_ARGUMENTS
220
eval CREATE TABLE t1(a INT)
221
DATA DIRECTORY='$MYSQLTEST_VARDIR/master-data/';
223
DROP TABLE IF EXISTS t1;
226
--replace_result $MYSQLTEST_VARDIR TEST_DIR
227
--error 0,ER_WRONG_ARGUMENTS
228
eval CREATE TABLE t1(a INT)
229
INDEX DIRECTORY='$MYSQLTEST_VARDIR/master-data';
203
let $MYSQLD_DATADIR= `select @@datadir`;
204
--replace_result $MYSQLD_DATADIR MYSQLD_DATADIR
205
--error 0,ER_WRONG_ARGUMENTS
206
eval CREATE TABLE t1(a INT)
207
INDEX DIRECTORY='$MYSQLD_DATADIR/mysql';
209
DROP TABLE IF EXISTS t1;
212
--replace_result $MYSQLD_DATADIR MYSQLD_DATADIR
213
--error 0,ER_WRONG_ARGUMENTS
214
eval CREATE TABLE t1(a INT)
215
DATA DIRECTORY='$MYSQLD_DATADIR/test';
217
DROP TABLE IF EXISTS t1;
220
--replace_result $MYSQLD_DATADIR MYSQLD_DATADIR
221
--error 0,ER_WRONG_ARGUMENTS
222
eval CREATE TABLE t1(a INT)
223
DATA DIRECTORY='$MYSQLD_DATADIR/';
225
DROP TABLE IF EXISTS t1;
228
--replace_result $MYSQLD_DATADIR MYSQLD_DATADIR
229
--error 0,ER_WRONG_ARGUMENTS
230
eval CREATE TABLE t1(a INT)
231
INDEX DIRECTORY='$MYSQLD_DATADIR';
230
232
--disable_warnings
231
233
DROP TABLE IF EXISTS t1;
232
234
--enable_warnings
240
242
# BUG#25677 - With --skip-symbolic-links option on, DATA DIRECTORY clause is
241
243
# silently ignored
243
246
SET @OLD_SQL_MODE=@@SQL_MODE, @@SQL_MODE='NO_DIR_IN_CREATE';
244
247
--replace_result $MYSQLTEST_VARDIR MYSQLTEST_VARDIR
245
248
eval CREATE TABLE t1(a INT) DATA DIRECTORY='$MYSQLTEST_VARDIR/tmp' INDEX DIRECTORY='$MYSQLTEST_VARDIR/tmp';