5 Commits

Author	SHA1	Message	Date
drh	805e7d5b42	Min() and max() ignore NULL values. Ticket #800. (CVS 1803) ... FossilOrigin-Name: 223521c04e8ad39e06fee455f7dbb31ace2d3800	2004-07-18 21:14:05 +00:00
drh	ca69323478	The MIN() aggregate function returns NULL if any element in the result ... was NULL. This makes MIN() consistent with ORDER BY which sorts NULL first. Ticket #777. (CVS 1679) FossilOrigin-Name: 78ced6e3092d69e7cb77c5c2acff70f3c92e6523	2004-06-23 21:16:51 +00:00
drh	562528c480	Do all WHERE clauses tests, even if an index is used for lookup so that ... we know the test cannot be FALSE. The test might end up being NULL in which case it would need to be treated as false. Ticket #461. (CVS 1103) FossilOrigin-Name: 5aea81488b2d3bcdc009ccf0f0ffcda046e38d79	2003-09-27 00:41:27 +00:00
drh	1288c9561d	Multiplying NULL by zero gives NULL, not zero. I misread the test data ... and coded it wrong. This check-in fixes the problem. (CVS 601) FossilOrigin-Name: df9cc852ad02dbec5558d3915a0303f7e7b79b2b	2002-06-01 21:41:10 +00:00
drh	f570f011eb	Refinements to NULL processing: NULLs are indistinct for DISTINCT and UNION. ... Multiplying a NULL by zero yields zero. In a CASE expression, a NULL comparison is considered false, not NULL. With these changes, NULLs in SQLite now work the same as in PostgreSQL and in Oracle. (CVS 600) FossilOrigin-Name: da61aa1d238539dff9c43fd9f464d311e28d669f	2002-05-31 15:51:25 +00:00