let $MYSQLD_DATADIR= `select @@datadir`;


CREATE TABLE t1 (
  path VARCHAR(256) NOT NULL flag=1,
  fname VARCHAR(256) NOT NULL,
  ftype CHAR(4) NOT NULL,
  size DOUBLE(12,0) NOT NULL flag=5
) ENGINE=CONNECT TABLE_TYPE=DIR FILE_NAME='*.txt'
  OPTION_LIST='subdir=1';

--replace_result $MYSQLD_DATADIR DATADIR/
SELECT * FROM t1;

--copy_file $MTR_SUITE_DIR/std_data/boys.txt $MYSQLD_DATADIR/test/boys.txt
--copy_file $MTR_SUITE_DIR/std_data/boyswin.txt $MYSQLD_DATADIR/test/boyswin.txt

--mkdir $MYSQLD_DATADIR/test/subdir/
--copy_file $MYSQLD_DATADIR/test/boys.txt  $MYSQLD_DATADIR/test/subdir/boys2.txt
--replace_result $MYSQLD_DATADIR DATADIR/
SELECT fname, ftype, size FROM t1 ORDER BY fname, ftype, size;
ALTER TABLE t1 OPTION_LIST='subdir=0';
SHOW CREATE TABLE t1;
--replace_result $MYSQLD_DATADIR DATADIR/
SELECT fname, ftype, size FROM t1 ORDER BY fname, ftype, size;
--error ER_TRUNCATED_WRONG_VALUE_FOR_FIELD
INSERT INTO t1 VALUES ('','','','');

DROP TABLE t1;

# TODO: automatically add columns
--error ER_UNKNOWN_ERROR
CREATE TABLE t1 ENGINE=CONNECT TABLE_TYPE=DIR FILE_NAME='*.txt';


#
# TODO: this fails on Linux
#
#CREATE TABLE t1 t1 (
#  DRIVE CHAR(2),
#  PATH VARCHAR(256),
#  FNAME VARCHAR(256),
#  FTYPE CHAR(4),
#  SIZE DOUBLE(12,0) flag=5,
#  MODIFIED datetime
#) engine=CONNECT table_type=DIR file_name='*.txt';
#SELECT * FROM t1;
#DROP TABLE t1;

--remove_file $MYSQLD_DATADIR/test/subdir/boys2.txt
--rmdir $MYSQLD_DATADIR/test/subdir/
--remove_file $MYSQLD_DATADIR/test/boys.txt
--remove_file $MYSQLD_DATADIR/test/boyswin.txt