The behavior is correct. I have adjusted the documentation to try to avoid ambiguity. See https://www.sqlite.org/docsrc/info/f6e2eab4e71644b1 for the documentation update.
On 2/2/17, Keith Medcalf <kmedc...@dessus.com> wrote: > > sqlite> create table x (key integer primary key, value text); > sqlite> insert into x values (null, 'test'); > sqlite> update x set key=10000 where value='test'; > sqlite> select * from x; > 10000|test > sqlite> delete from x; > sqlite> insert into x values (null, 'again'); > sqlite> select * from x; > 1|again > sqlite> drop table x; > sqlite> create table x (key integer primary key autoincrement, value text); > sqlite> insert into x values (null, 'test'); > sqlite> update x set key=10000 where value='test'; > sqlite> select * from x; > 10000|test > sqlite> delete from x; > sqlite> insert into x values (null, 'again'); > sqlite> select * from x; > 2|again > sqlite> drop table x; > sqlite> create table x (key integer primary key autoincrement, value text); > sqlite> insert into x values (null, 'test'); > sqlite> update x set key=10000 where value='test'; > sqlite> select * from x; > 10000|test > sqlite> insert into x values (null, 'again'); > sqlite> select * from x; > 10000|test > 10001|again > sqlite> > > Question is: when the rowid alias is declared autoincrement, Should the > "update" update the hi-level mark for the key field? > > --- > Life should not be a journey to the grave with the intention of arriving > safely in a pretty and well preserved body, but rather to skid in broadside > in a cloud of smoke, thoroughly used up, totally worn out, and loudly > proclaiming "Wow! What a Ride!" > -- Hunter S. Thompson > > > > > _______________________________________________ > sqlite-users mailing list > sqlite-users@mailinglists.sqlite.org > http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users > -- D. Richard Hipp d...@sqlite.org _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
