ORDER BY on 2 varchar columns of DIR CONNECT table shows error message
"Can't find record ".
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'
|