Uploaded image for project: 'MariaDB Server'
  1. MariaDB Server
  2. MDEV-12587

MariaDB CONNECT DIR Type - Subfolder Option: SELECT Query Never Ends

    Details

      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

        Attachments

          Activity

            People

            • Assignee:
              bertrandop Olivier Bertrand
              Reporter:
              Juan Juan Telleria
            • Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: