Hello, When I build duckdb_fdw with duckdb version 0.6.0 or 0.6.1, e

btw，please refer this to simplify the job. <a href="https://github.c

Error when loading extension with duckdb 0.6.x: undefined symbol: sqlite3_bind_int64 about duckdb_fdw HOT 5 CLOSED

alitrack commented on August 14, 2024

Error when loading extension with duckdb 0.6.x: undefined symbol: sqlite3_bind_int64

from duckdb_fdw.

Comments (5)

alitrack commented on August 14, 2024

I am still working on it.

from duckdb_fdw.

elysabethpc commented on August 14, 2024

Hello,

I tried myaniu's solution, but it doesn't work for me.
I can load the extension and create server but failed when I try to read from duckdb file with "unable to open database file":

db1=# create extension duckdb_fdw;
CREATE EXTENSION
db1=# \dx
                   List of installed extensions
    Name    | Version |   Schema   |         Description          
------------+---------+------------+------------------------------
 duckdb_fdw | 1.1     | public     | DuckDB Foreign Data Wrapper
 plpgsql    | 1.0     | pg_catalog | PL/pgSQL procedural language
(2 rows)

db1=# create server duckdb_srv foreign data wrapper duckdb_fdw options (database '/tmp/db1.duckdb', read_only 'true');
CREATE SERVER
db1=# 

db1=# import foreign schema public from server duckdb_srv into public;
ERROR:  SQL error during prepare: unable to open database file SELECT name FROM sqlite_master WHERE type in('table', 'view') AND name NOT LIKE 'sqlite_%'

I also tried the myaniu's dockfile on issue thread "duckdb_fdw.so: undefined symbol: sqlite3_limit", but failed.

Thank you

from duckdb_fdw.

alitrack commented on August 14, 2024

fixed,
from DuckDB 0.6, sqlite3_api_wrapper has an extra include, so I have to include it too.