On Wed, Sep 23, 2009 at 06:12:13PM +0100, Simon Slavin wrote: > > On 23 Sep 2009, at 5:12pm, Nicolas Williams wrote: > > > On Tue, Sep 22, 2009 at 04:45:31PM -0400, D. Richard Hipp wrote: > >> UPDATE t1 SET x=x; -- key line: Is this considered an "update" > >> of t1.x? > > > > Igor pointed to the standards text, which I think is quite reasonable: > > an update is only an update if something changes. > > On this basis, should the results of sqlite3_changes() and PRAGMA > count_changes not agree with those ? Because they don't.
Yes, but pragmas are outside the language -- it might be useful to have a pragma to count no-ops. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
