SQLite

Timeline
Login

Many hyperlinks are disabled.
Use anonymous login to enable hyperlinks.

6 check-ins using file test/trigger2.test version 7f2b0a9b

2002-05-27
12:24
A SELECT statement inside the body of a TRIGGER uses the SRT_Discard target to discard the query results. Such selects are intended to be used to call user-defined functions for their side-effects. They do not return results. (CVS 594) (check-in: f8041f3d user: drh tags: trunk)
03:25
Fix the "alias.*" bug found by Bernie Cosell and reported on the newsgroup. (CVS 593) (check-in: f562d542 user: drh tags: trunk)
01:04
Bug fixes and additional test cases for the distinct-NULL patch. (CVS 592) (check-in: 0e268d0c user: drh tags: trunk)
2002-05-26
23:24
Require the INSTEAD OF syntax to create triggers on database views. (CVS 591) (check-in: d9e48cd5 user: danielk1977 tags: trunk)
21:34
Change functions to handle NULLs correctly. Added the NULLIF() function. (CVS 590) (check-in: 46ce1a9a user: drh tags: trunk)
20:54
NULL values are distinct. A comparison involving a NULL is always false. Operations on a NULL value yield a NULL result. This change makes SQLite operate more like the SQL spec, but it may break existing applications that assumed the old behavior. All the old tests pass but we still need to add new tests to better verify the new behavior. Fix for ticket #44. (CVS 589) (check-in: 90511737 user: drh tags: trunk)