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

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

    XMLWordPrintable

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

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

            Dates

              Created:
              Updated:
              Resolved:

              Git Integration

                Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.