create table t3 (
|
fpath varchar(255) NOT NULL flag=1,
|
fname varchar(255) NOT NULL flag=2
|
)engine=CONNECT table_type=DIR file_name='/home/alice/Downloads/*' option_list='subdir=1'
|
--------------
|
Query OK, 0 rows affected (0.02 sec)
|
|
--------------
|
select * from t3
|
--------------
|
+------------------------+-------+
|
| fpath | fname |
|
+------------------------+-------+
|
| /home/alice/Downloads/ | xx1 |
|
| /home/alice/Downloads/ | xx1 |
|
| /home/alice/Downloads/ | 1 |
|
+------------------------+-------+
|
3 rows in set (0.00 sec)
|
|
--------------
|
INSERT INTO t3 VALUES ("a","a")
|
--------------
|
ERROR 1296 (HY000) at line 25 in file: '/home/alice/t/c.sql': Got error 174 'COLBLK SetBuffer: undefined Access Method' from CONNECT
|