[sqlite] System.Data.SQLite fails on rtree index creation (NuGet install)

On 05/24/2016 01:16 AM, Joe Mistachkin wrote: > Jason Doherty wrote: >> CREATE VIRTUAL TABLE IF NOT EXISTS TASK_SPX USING rtree(id, minx, maxx, >> miny, maxy); >> >> fails with >> >> SQLite error (1); no such table: main.sqlite_stat1 >> > Could you run the SQL query "ANALYZE;" on the databa

[sqlite] System.Data.SQLite fails on rtree index creation (NuGet install)

Jason Doherty wrote: > >CREATE VIRTUAL TABLE IF NOT EXISTS TASK_SPX USING rtree(id, minx, maxx, > miny, maxy); > > fails with > >SQLite error (1); no such table: main.sqlite_stat1 > Could you run the SQL query "ANALYZE;" on the database and see if that clears the issue? -- Joe Mistach

[sqlite] System.Data.SQLite fails on rtree index creation (NuGet install)

Hi We?ve used SQLite rtree indexes successfully on iOS and Android for creating spatial indexes in the past. We can?t seem to make them work on Windows. We are using the System.Data.SQLite ADO.NET library that was downloaded using the NuGet package manager (version 1.0.101) per the instructions,