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