Re: [sqlite] [patch] Re: Potential bug: insert into X select * from Y ignores the ON CONFLICT REPLACE conflict-clause

2011-11-04 Thread Yuriy Kaminskiy
Yuriy Kaminskiy wrote: Yuriy Kaminskiy wrote: David wrote: Simon L wrote 2011-10-25 06:20: To reproduce this problem, enter the following 5 SQL statements at the SQLite command line. create table X(id INTEGER primary key ON CONFLICT REPLACE); create table Y(id INTEGER primary key ON

Re: [sqlite] [patch] Re: Potential bug: insert into X select * from Y ignores the ON CONFLICT REPLACE conflict-clause

2011-11-03 Thread Yuriy Kaminskiy
Yuriy Kaminskiy wrote: David wrote: Simon L wrote 2011-10-25 06:20: To reproduce this problem, enter the following 5 SQL statements at the SQLite command line. create table X(id INTEGER primary key ON CONFLICT REPLACE); create table Y(id INTEGER primary key ON CONFLICT REPLACE); insert

[sqlite] [patch] Re: Potential bug: insert into X select * from Y ignores the ON CONFLICT REPLACE conflict-clause

2011-10-25 Thread Yuriy Kaminskiy
David wrote: Simon L wrote 2011-10-25 06:20: To reproduce this problem, enter the following 5 SQL statements at the SQLite command line. create table X(id INTEGER primary key ON CONFLICT REPLACE); create table Y(id INTEGER primary key ON CONFLICT REPLACE); insert into X values (1); insert