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

[Dan Kennedy]

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 database and see if that
> clears
> the issue?

On the off chance that it doesn't completely clear the issue but does 
change the error message to one that makes more sense, can you post the 
new error here? Thanks.

Dan.

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

[Joe Mistachkin]

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 Mistachkin

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

[Jason Doherty]

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, running in x86 mode in Visual Studio 2013.

   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

This only fails on Windows.  We saw this message on iOS when we didn?t
compile with the -DSQLITE_ENABLE_RTREE=1 option, but there is no such
option for the ADO.NET provider. Is it not compiled for rtree on Windows?

Thanks for any help!
Jason