Unable to access Zip table from multiple Zip files

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.