1let $MYSQLD_DATADIR= `select @@datadir`; 2 3 4CREATE TABLE t1 ( 5 path VARCHAR(256) NOT NULL flag=1, 6 fname VARCHAR(256) NOT NULL, 7 ftype CHAR(4) NOT NULL, 8 size DOUBLE(12,0) NOT NULL flag=5 9) ENGINE=CONNECT TABLE_TYPE=DIR FILE_NAME='*.txt' 10 OPTION_LIST='subdir=1'; 11 12--replace_result $MYSQLD_DATADIR DATADIR/ 13SELECT * FROM t1; 14 15--copy_file $MTR_SUITE_DIR/std_data/boys.txt $MYSQLD_DATADIR/test/boys.txt 16--copy_file $MTR_SUITE_DIR/std_data/boyswin.txt $MYSQLD_DATADIR/test/boyswin.txt 17 18--mkdir $MYSQLD_DATADIR/test/subdir/ 19--copy_file $MYSQLD_DATADIR/test/boys.txt $MYSQLD_DATADIR/test/subdir/boys2.txt 20--replace_result $MYSQLD_DATADIR DATADIR/ 21SELECT fname, ftype, size FROM t1 ORDER BY fname, ftype, size; 22ALTER TABLE t1 OPTION_LIST='subdir=0'; 23SHOW CREATE TABLE t1; 24--replace_result $MYSQLD_DATADIR DATADIR/ 25SELECT fname, ftype, size FROM t1 ORDER BY fname, ftype, size; 26--error ER_TRUNCATED_WRONG_VALUE_FOR_FIELD 27INSERT INTO t1 VALUES ('','','',''); 28 29DROP TABLE t1; 30 31# TODO: automatically add columns 32--error ER_UNKNOWN_ERROR 33CREATE TABLE t1 ENGINE=CONNECT TABLE_TYPE=DIR FILE_NAME='*.txt'; 34 35 36# 37# TODO: this fails on Linux 38# 39#CREATE TABLE t1 t1 ( 40# DRIVE CHAR(2), 41# PATH VARCHAR(256), 42# FNAME VARCHAR(256), 43# FTYPE CHAR(4), 44# SIZE DOUBLE(12,0) flag=5, 45# MODIFIED datetime 46#) engine=CONNECT table_type=DIR file_name='*.txt'; 47#SELECT * FROM t1; 48#DROP TABLE t1; 49 50--remove_file $MYSQLD_DATADIR/test/subdir/boys2.txt 51--rmdir $MYSQLD_DATADIR/test/subdir/ 52--remove_file $MYSQLD_DATADIR/test/boys.txt 53--remove_file $MYSQLD_DATADIR/test/boyswin.txt 54