[MDEV-12587] MariaDB CONNECT DIR Type - Subfolder Option: SELECT Query Never Ends Created: 2017-04-25  Updated: 2017-05-03  Resolved: 2017-05-02

Status: Closed
Project: MariaDB Server
Component/s: Storage Engine - Connect
Affects Version/s: 10.1.22
Fix Version/s: 10.1.23, 10.0.31

Type: Bug Priority: Trivial
Reporter: Juan Telleria Assignee: Olivier Bertrand
Resolution: Fixed Votes: 0
Labels: CONNECT
Environment:

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


Generated at Thu Feb 08 07:58:53 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.