On 07-09-2013 03:27, James K. Lowden wrote:
On Fri, 6 Sep 2013 11:07:27 -0400
Richard Hipp <[email protected]> wrote:
The effect of early row updates might be visible in later row updates
if you contrive a *sufficiently* complex example. But you really have
to go out of your way to do that.
sqlite> create table i ( i int primary key );
sqlite> insert into i values (1);
sqlite> insert into i values (2);
sqlite> update i set i = i + 1;
SQL error: column i is not unique
sqlite> drop table i;
sqlite> create table i ( i int primary key );
sqlite> insert into i values (2);
sqlite> insert into i values (1);
sqlite> update i set i = i + 1;
sqlite>
;)
_______________________________________________
sqlite-users mailing list
[email protected]
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
