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

[Dan Kennedy]

>> 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

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

[Peter Kolbus]

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 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

[sqlite] INSERT OR IGNORE with rtree virtual tables

[Peter Kolbus]

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