Cannot load extension for non-static build

[hkulyc]

I have been using the flags -DBUILD_MAIN_DUCKDB_LIBRARY=0 -DEXTENSION_STATIC_BUILD=0 when making the extension which can save a lot of building time during development in duckdb v0.9. I will first build once with -DBUILD_MAIN_DUCKDB_LIBRARY=1 to make sure the library and DuckDB binary is in place.

However, after upgrading to v0.10, when loading the extension in the CLI, it gives me this error:

Exception: IO Error: Extension ".... /build/release/extension/udf1/udf1.duckdb_extension" could not be loaded: undefined symbol: _ZTIN6duckdb9ExceptionE ....

Platform:
Ubuntu 20.04.6 LTS

Btw, I also tested on MacOS 14.3.1 M1 Chip and it is working fine.