I've been trying to get the percentile module to work as an extension. The pre-4.7 version works, but everything after 4.7 causes a segmentation fault on .load.

To duplicate, I downloaded: sqlite.org/2024/sqlite-autoconf-3470000.tar.gz

build using:

gcc shell.c sqlite3.c -lpthread -ldl -lm -o sqlite3

Build percentile.c

gcc -g -fPIC -shared percentile.c -o percentile.so

try to load

$ sqlite3
> .load /path/to/percentile.so
Segmentation fault (core dumped)

I've tried both the latest percentile.c, sqlite.org/src/file?name=ext/misc/percentile.c and also the one from sqlite.org/2024/sqlite-src-3470000.zip, at ext/misc/percentile.c

The 3.46 version of percentile.c does build and load.

The 3.47 version also works fine with no segmentation fault, if I compile it into the shell, using:

gcc -DSQLITE_STATIC_PERCENTILE=1 \
  shell.c sqlite3.c -lpthread -ldl -lm -o sqlite3

The extension-related code seems to match the definitions in the load extension documentation, so I'm not sure why it doesn't work as an extension but does work when compiled into the sqlite3 binary?

This is on arch linux (6.11.4-arch2-1).