On Sun, 13 Apr 2014 06:55:09 -0400 Richard Hipp <d...@sqlite.org> wrote:
> 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; > INSERT INTO t1(a,b) VALUES(123,456); > UPDATE OR REPLACE t1 SET b=789; Not here, although I had to remove WHERE on t1b, SQLite version 3.7.13 2012-06-11 02:05:22 Enter ".help" for instructions Enter SQL statements terminated with a ";" sqlite> CREATE TABLE t1(a,b); sqlite> CREATE UNIQUE INDEX t1ab ON t1(a,b); sqlite> CREATE INDEX t1b ON t1(b) ; sqlite> INSERT INTO t1(a,b) VALUES(123,456); sqlite> UPDATE OR REPLACE t1 SET b=789; sqlite> --jkl _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
