Re: [sqlite] INSERT OR IGNORE with rtree virtual tables

>> In the shell: >> >> SQLite version 3.7.3 >> Enter ".help" for instructions >> Enter SQL statements terminated with a ";" >> sqlite> CREATE VIRTUAL TABLE a_rt USING rtree( _id, min_x, max_x, >> min_y, max_y ); >> sqlite> INSERT OR IGNORE INTO a_rt ( _id, min_x, max_x, min_y, >> max_y ) >>

Re: [sqlite] INSERT OR IGNORE with rtree virtual tables

Any thoughts on this? Thanks, Peter Kolbus On Sat, Oct 30, 2010 at 8:27 PM, Peter Kolbus wrote: > Hi, > > It seems that the OR IGNORE clause is not working with an RTREE > virtual table.  The documentation (http://sqlite.org/rtree.html, > section 3.2) implies that this

[sqlite] INSERT OR IGNORE with rtree virtual tables

Hi, It seems that the OR IGNORE clause is not working with an RTREE virtual table. The documentation (http://sqlite.org/rtree.html, section 3.2) implies that this should work, but is not absolutely clear on the point of conflict handling. I've tried this with both 3.6.19 and 3.7.3 with the same