Details
-
Bug
-
Status: Closed (View Workflow)
-
Trivial
-
Resolution: Fixed
-
10.1.22
-
Windows
Description
If I execute the following code:
create table Table_Name
|
(
|
PATH varchar(256) NOT NULL flag=1, |
FNAME varchar(256) NOT NULL, |
FTYPE char(4) NOT NULL, |
SIZE double(12,0) NOT NULL flag=5 |
)
|
ENGINE=CONNECT
|
TABLE_TYPE=DIR
|
FILE_NAME='C:\Folder\Subfolder\*.zip' |
OPTION_LIST='subdir=1'; |
With a folder that contains 31 subfolders, and a total of 30.000 .zip files:
- The SELECT query never ends, as I left it running for more than half an hour without obtaining any results.
- Without the subfolder option (that is, all files in the main folder) works perfectly, obtaining all results in few seconds.
Also I obtain error which does not allow me to start my development server after using this CONNECT ENGINE option:
2017-04-25 16:04:23 9124 [ERROR] mysqld.exe: Got an error writing communication packets
However, it is trivial bug, so it does not have to be considered prioritary.
Thank you a lot for your excellent work!
Juan