>> 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?
Virtual tables (like r-tree and fts3) ignore ON CONFLICT clauses. Just the way it is unfortunately. Dan. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
