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 result.
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 ) VALUES( 2, 3, 4, 5, 6 ); sqlite> INSERT OR IGNORE INTO a_rt ( _id, min_x, max_x, min_y, max_y ) VALUES( 2, 3, 4, 5, 6 ); Error: constraint failed sqlite> Is this a bug, or operating as designed? Thanks, Peter Kolbus _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users