create table t2 (

  fpath varchar(255) NOT NULL flag=1,

  fname varchar(255) NOT NULL flag=2,

  ftype varchar(255) NOT NULL flag=3,

  size double(12,0) NOT NULL flag=5

)engine=CONNECT table_type=DIR file_name='/home/alice/Downloads/*' option_list='subdir=1'

--------------

Query OK, 0 rows affected (0.06 sec)

--------------

select * from t2

--------------

+------------------------+---------------------+-------+------+

| fpath                  | fname               | ftype | size |

+------------------------+---------------------+-------+------+

| /home/alice/Downloads/ | Untitled Document 3 |       |    0 |

| /home/alice/Downloads/ | Untitled Document 2 |       |    0 |

| /home/alice/Downloads/ | Untitled Document   |       |    0 |

+------------------------+---------------------+-------+------+

3 rows in set (0.00 sec)

--------------

SELECT fname, ftype, size FROM t2 ORDER BY fname,ftype

--------------

ERROR 1032 (HY000) at line 15 in file: '/home/alice/t/c.sql': Can't find record in 't2'