Motherduck compatibility

[JichaoS]

I'm running into an issue querying from motherduck with the url md:?motherduck_token=XXXXXX

Invalid Input Error: Initialization function \"motherduck_init\" from file \"/Users/jichao/.duckdb/extensions/v0.9.2/osx_arm64/motherduck.duckdb_extension\" threw an exception: \"IO Error: Extension \"/Users/jichao/.duckdb/extensions/v0.9.2/osx_arm64/motherduck.v1.15.5.duckdb_extension\" could not be loaded: dlopen(/Users/jichao/.duckdb/extensions/v0.9.2/osx_arm64/motherduck.v1.15.5.duckdb_extension, 0x0006): symbol not found in flat namespace '__ZN6duckdb24LogicalExtensionOperator21ResolveColumnBindingsERNS_21ColumnBindingResolverERNS_6vectorINS_13ColumnBindingELb1EEE

Any idea what could be causing this? CLI is working so I suspect some build issues with libduckdb-sys

[sgrebnov]

I've encountered with the same issue when using duckdb-rs version 0.9.2 and md extension:

DuckDBError: Invalid Input Error: Initialization function "motherduck_init" from file "/Users/sg/.duckdb/extensions/v0.9.2/osx_arm64/motherduck.duckdb_extension" threw an exception: "IO Error: Extension "/Users/sg/.duckdb/extensions/v0.9.2/osx_arm64/motherduck.v1.15.25.duckdb_extension" could not be loaded: dlopen(/Users/sg/.duckdb/extensions/v0.9.2/osx_arm64/motherduck.v1.15.25.duckdb_extension, 0x0006): symbol not found in flat namespace '__ZN6duckdb24LogicalExtensionOperator21ResolveColumnBindingsERNS_21ColumnBindingResolverERNS_6vectorINS_13ColumnBindingELb1EEE'"

@JichaoS - were you able to resolve the issue?

[JichaoS]

I did get a response but haven't tried it out. Reposting from MD slack channel here

Sorry for the delay! We investigated and the issue is that the Rust compiler optimizes away unused code in the bundled DuckDB binary provided by duckdb-rs on which the MotherDuck extension depends. A workaround is to disable dead code elimination with RUSTFLAGS="-C link-dead-code" cargo run A pretty big hammer and results in a larger binary but AFAIK there isn’t a more granular way to preserve the DuckDB binary only.

[sgrebnov]

@JichaoS - thank you a lot!