Details
-
Bug
-
Status: Open (View Workflow)
-
Minor
-
Resolution: Unresolved
-
10.1.22
-
None
-
ubuntu 16.04
Description
In DIR CONNECT tables flag=0 is reserved for the disk drive (Windows), but if it is used on Ubuntu, the result is an empty table, without any warnings/errors.
--------------
|
create table t2 ( |
fdr varchar(255) NOT NULL flag=0, |
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.03 sec) |
|
|
--------------
|
select * from t2 |
--------------
|
Empty set (0.00 sec) |
|
|
\! ls -la /home/alice/Downloads/
|
|
|
drwxr-xr-x 3 alice alice 4096 May 1 11:34 .
|
drwxr-xr-x 25 alice alice 4096 May 1 09:55 ..
|
-rw-rw-r-- 1 alice alice 0 May 1 10:34 1 |
drwxrwxr-x 2 alice alice 4096 May 1 11:35 11
|
-rw-rw-r-- 1 alice alice 0 May 1 10:34 2 |
-rw-rw-r-- 1 alice alice 0 May 1 10:34 3 |