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. The same should probably apply to TRIGGERs too! > And a related question: Does anybody really care about ON UPDATE SET > NULL? Has anybody ever actually seen ON UPDATE SET NULL used in > practice? ON UPDATE SET NULL has very few uses, if any. Any use of ON UPDATE SET NULL that I can imagine is contrived (e.g., select for NULL references in t2 as a way to detect past updates to t1). On the other hand, ON DELETE SET NULL is very useful. Nico -- _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
