duckdb.query doesn't work

[nasoblu5]

I run a query with duckdb.raw_query without problems in Postgresql 17.6 with pg_duckdb installed 1.0 and duckdb 1.4.1 but I try with duckdb.query there is forever an internal error:

SELECT * FROM duckdb.query('FROM range(10) as a(a) SELECT [a for i in generate_series(0, a)] as arr');
ERROR: (PGDuckDB/Duckdb_ExplainCustomScan_Cpp) INTERNAL Error: Attempted to access index 1 within vector of size 1
This error signals an assertion failure within DuckDB. This usually occurs due to unexpected conditions or errors in the program's logic.
For more information, see https://duckdb.org/docs/stable/dev/internal_errors

Stack Trace:

/usr/lib/postgresql/17/lib/libduckdb.so(duckdb::Exception::ToJSON(duckdb::ExceptionType, std::__cxx11::basic_string<char, std::char_traits, std::allocator > const&)+0x56) [0x7fc02004ff56]
/usr/lib/postgresql/17/lib/libduckdb.so(duckdb::Exception::Exception(duckdb::ExceptionType, std::__cxx11::basic_string<char, std::char_traits, std::allocator > const&)+0x14) [0x7fc020050014]
/usr/lib/postgresql/17/lib/libduckdb.so(duckdb::InternalException::InternalException(std::__cxx11::basic_string<char, std::char_traits, std::allocator > const&)+0x11) [0x7fc020053081]
/usr/lib/postgresql/17/lib/libduckdb.so(+0xbc4e2c) [0x7fc01f575e2c]
/usr/lib/postgresql/17/lib/libduckdb.so(+0x9662c4) [0x7fc01f3172c4]
/usr/lib/postgresql/17/lib/pg_duckdb.so(+0x41bd7) [0x7fc0220a2bd7]
/usr/lib/postgresql/17/lib/pg_duckdb.so(+0x42130) [0x7fc0220a3130]
postgres: postgres nmv21 10.89.0.27(37392) SELECT(+0x2b8878) [0x563e32483878]
postgres: postgres nmv21 10.89.0.27(37392) SELECT(ExplainPrintPlan+0x9b) [0x563e32485a9b]
/usr/lib/postgresql/17/lib/pg_show_plans.so(+0x2a3a) [0x7fc01e803a3a]
postgres: postgres nmv21 10.89.0.27(37392) SELECT(PortalStart+0x2dc) [0x563e326a292c]
postgres: postgres nmv21 10.89.0.27(37392) SELECT(+0x4d4427) [0x563e3269f427]
postgres: postgres nmv21 10.89.0.27(37392) SELECT(PostgresMain+0xf5d) [0x563e326a082d]
postgres: postgres nmv21 10.89.0.27(37392) SELECT(+0x4d0a3f) [0x563e3269ba3f]
postgres: postgres nmv21 10.89.0.27(37392) SELECT(postmaster_child_launch+0x9a) [0x563e326092aa]
postgres: postgres nmv21 10.89.0.27(37392) SELECT(+0x441db9) [0x563e3260cdb9]
postgres: postgres nmv21 10.89.0.27(37392) SELECT(PostmasterMain+0xdc8) [0x563e3260ecc8]
postgres: postgres nmv21 10.89.0.27(37392) SELECT(main+0x211) [0x563e32330a11]
/lib/x86_64-linux-gnu/libc.so.6(+0x2724a) [0x7fc024e6b24a]
/lib/x86_64-linux-gnu/libc.so.6(__libc_start_main+0x85) [0x7fc024e6b305]
postgres: postgres nmv21 10.89.0.27(37392) SELECT(_start+0x21) [0x563e32330fd1]

nmv21=# SELECT * FROM duckdb.raw_query('FROM range(10) as a(a) SELECT [a for i in generate_series(0, a)] as arr');
NOTICE: result: arr
BIGINT[]
[ Rows: 10]
[0]
[1, 1]
[2, 2, 2]
[3, 3, 3, 3]
[4, 4, 4, 4, 4]
[5, 5, 5, 5, 5, 5]
[6, 6, 6, 6, 6, 6, 6]
[7, 7, 7, 7, 7, 7, 7, 7]
[8, 8, 8, 8, 8, 8, 8, 8, 8]
[9, 9, 9, 9, 9, 9, 9, 9, 9, 9]

raw_query

(1 row)

[JelteF]

I cannot reproduce this on the main branch. So I think this is either fixed, or it was some setup issue (i.e. I see you mention duckdb 1.4.1, but pg_duckdb 1.0 only supports 1.3.2)

[nasoblu5]

Hi,

I solved the issue I disabled the extension pg_show_plans that affects the internal Postgresql planner structures, so pg_duckdb didn't interpret rightly.

Now I use proficiently duckdb.query with ducklake catalog.