Hi,
On Mon, Mar 10, 2014 at 6:37 PM, Dan Kennedy <danielk1...@gmail.com> wrote: > On 03/10/2014 06:49 PM, St. B. wrote: > >> Hi, >> >> I posted this question last year, but did not get any feed back. Is this >> something that can be handled on the ML, or should I ask in another place? >> >> Regards, >> >> ---------- Forwarded message ---------- >> From: St. B. <sbart...@gmail.com> >> Date: Sun, Jan 6, 2013 at 11:45 PM >> Subject: Exception when querying a range index >> To: sqlite-users@sqlite.org >> >> >> Hi All, >> >> I have an application using sqlite to store coast lines (application runs >> on windows and uses the .Net version of sqlite v1.0.83). I use range >> indexes to look-up coast line within range of a given point. >> >> During run time I find that the following exception occurs. >> >> vtable constructor failed: MapLevel_Idx3 >> > > How is virtual table MapLevel_Idx3 created? Is it an rtree table? > The virtual table is created with the following sql statement: CREATE VIRTUAL TABLE MapLevel_Idx4 USING rtree( id, -- Integer primary key minX, maxX, -- Minimum and maximum X coordinate minY, maxY -- Minimum and maximum Y coordinate ); Yes it is an rtree table > > SQLite version? > I am using system.data.SQLite v 1.0.84.0. I guess it includes sqlites in v 3.7.6.3 (but am not sure at all) > > Dan. > > > > > > >> Occurence ratio is about 1 in 10000 queries on the range index. Am I doing >> something wrong, or is this supposed to be so? When the exception occurs, >> I >> just drop the resultset and assume that no data was to be found. Should I >> restart the query? >> >> Regards, >> >> -- >> >> S. Barthes >> _______________________________________________ >> sqlite-users mailing list >> sqlite-users@sqlite.org >> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users >> > > _______________________________________________ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users