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

Unable to access Zip table from multiple Zip files

    XMLWordPrintable

    Details

      Description

      I am not able to get the zip table of multiple zip. This is required when references are split into multiple .zip files to limit the size or group files in functional domains.

      Creation of TestZip2 table will be fine :

      {{create table TestZip2 (
      fn varchar(256)not null,
      cmpsize bigint not null flag=1,
      uncsize bigint not null flag=2,
      method int not null flag=3,
      date datetime not null flag=4)
      engine=connect table_type=ZIP multiple=1 file_name='/tmp/CCAMArchiveLatest/CCAM06300_DBF_PART*.zip'
      }}

      But trying to access the created table will result in an error like :
      " #1296 - Got error 174 'Zipfile open error' from CONNECT"

      Example of file used in the tmp folder is :
      https://www.ameli.fr/fileadmin/user_upload/documents/CCAM06300_DBF_PART1.zip
      https://www.ameli.fr/fileadmin/user_upload/documents/CCAM06300_DBF_PART2.zip
      https://www.ameli.fr/fileadmin/user_upload/documents/CCAM06300_DBF_PART3.zip

      FYI, Fixing this would help to implement the "Self Referencing Zip Table" Epic as well.

        Attachments

          Activity

            People

            Assignee:
            bertrandop Olivier Bertrand
            Reporter:
            bjb Jean-Baptiste BUGEAUD
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

              Dates

              Created:
              Updated:
              Resolved: