Failed to prepare query "PRAGMA table_info('SpatialIndex')": no such module: VirtualSpatialIndex

[marklit]

What happens?

I'm trying to attach a SQLite3 database which uses their spatial extension in some of the tables. I'm using DuckDB v1.5.1 (Variegata) on WSL2.

ATTACH 'spatialite_nasr.sqlite' AS nasr (TYPE sqlite, READ_ONLY);
USE nasr;
.tables

Invalid Error:
Failed to prepare query "PRAGMA table_info('SpatialIndex')": no such module: VirtualSpatialIndex

I'm not seeing anything related to DuckDB searching google for "VirtualSpatialIndex" and there hasn't been any issues raised in this GitHub repo with that string either.

Any idea what step(s) I'm missing?

The SQLite3 spatial extension was installed via:

$ sudo apt-get install libsqlite3-mod-spatialite

To Reproduce

n/a

OS:

WSL2

DuckDB Version:

v1.5.1 (Variegata)

DuckDB Client:

CLI

Hardware:

No response

Full Name:

Mark Litwintschik

Affiliation:

Green Idea OU

Did you include all relevant configuration (e.g., CPU architecture, Linux distribution) to reproduce the issue?

• Yes, I have

Did you include all code required to reproduce the issue?

• Yes, I have

Did you include all relevant data sets for reproducing the issue?

Not applicable - the reproduction does not require a data set

[staticlibs]

Hi, thanks for opening the issue! This looks like a duplicate of #140. Basically we currently do not support native SQlite extensions, I cannot immediately tell whether it is feasible to add this, going to follow up in #140.

[marklit]

Understood. I'll close this ticket and keep an eye on the other one.