On Thu, 2 Jan 2014 01:29:52 +0000 Simon Slavin <slav...@bigfraud.org> wrote:
> Hmm. Even > > update t set i = i + 1 - 1 > > with i being UNIQUE might be a good test case. Well, that actually works: sqlite> create table t (t int primary key); sqlite> insert into t values (1); sqlite> insert into t values (2); sqlite> update t set t = t + 1 - 1; sqlite> select * from t; t ---------- 1 2 presumably because "t + 1 - 1" is fully evaluated before it is applied to the row. Another example I used off-list: sqlite> delete from t; sqlite> insert into t values (-1); sqlite> insert into t values ( 1); sqlite> update t set t = -t; Error: column t is not unique --jkl _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users