Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Fixed
-
10.3(EOL)
-
Docker mariadb latest
Description
I am unable to get Connect to use a DBF inside a zip archive.
This fails with "#1105 - Cannot get columns from R_ACTE" :
CREATE TABLE R_ACTE engine=CONNECT table_type=DBF CHARSET=cp850 file_name="/tmp/CCAMArchiveLatest/CCAM_DBF.zip" zipped=1 option_list="Accept=1,Entry=R_ACTE.dbf";
As a workaround, unziping the archive in the same location and this would go thru :
CREATE TABLE R_ACTE engine=CONNECT table_type=DBF CHARSET=cp850 file_name="/tmp/CCAMArchiveLatest/R_ACTE.dbf" option_list="Accept=1";
File used is :
https://www.ameli.fr/fileadmin/user_upload/documents/CCAM06300_DBF_PART1.zip
The same issue happens for any DBF file from the same source. Those files are valid as per any other tools I've used to access them.
FYI, option Accept=1 is required to workaround another issue on using this kind of DBF.