On 13 Apr 2014 at 11:55, Richard Hipp <d...@sqlite.org> wrote: > The UPDATE OR REPLACE also seems to be an essential component. The > following simplified test case causes an assertion fault: > > CREATE TABLE t1(a,b); > CREATE UNIQUE INDEX t1ab ON t1(a,b); > CREATE INDEX t1b ON t1(b) WHERE b=1;
I get no assertion fault but rather a syntax error here on "where". > INSERT INTO t1(a,b) VALUES(123,456); > UPDATE OR REPLACE t1 SET b=789; Using SQLite version 3.7.13 2012-07-17 17:46:21 in the sqlite3 shell. -- Cheers -- Tim
_______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users