nalgeon / sqlean

The ultimate set of SQLite extensions
MIT License
3.65k stars 115 forks source link

`Runtime error: out of memory (7)` for any selection using vsv #108

Closed astral-l closed 7 months ago

astral-l commented 7 months ago

When using the vsv extension, creating a table from a csv file and attempting to select any data from it fails immediately in an out-of-memory error, regardless of the size of the query.

SQLite version: 3.45.0

To reproduce:

CREATE VIRTUAL TABLE example USING vsv( filename=example.csv, schema="CREATE TABLE example(id INTEGER, data TEXT)" );

SELECT * FROM example;

nalgeon commented 7 months ago

Thanks for providing all the details! The columns parameter is required:

create virtual table example using vsv(
    filename=example.csv,
    schema="create table example(id integer, data text)",
    columns=2,
);

I'll fix the doc.