3 Commits

Author	SHA1	Message	Date
drh	a4c4064d28	If a table is the right operand of a LEFT JOIN, then any column of that ... table can be NULL even if that column has a NOT NULL constraint. Fix for ticket [6f2222d550f5b0ee7ed]. FossilOrigin-Name: 5a80957b04d68cc7e0325873a409d83c1f11b52f	2014-12-04 16:29:21 +00:00
drh	0a168377ad	Fix the query optimizer so that it correctly handles constant expressions ... in the ON clause of a LEFT JOIN. Ticket #2403. (CVS 4049) FossilOrigin-Name: 46fdd195483787eef209a9b8ad108eba147be6fa	2007-06-08 00:20:47 +00:00
drh	22d6a53a77	ON-clause terms in a LEFT JOIN that restrict only the left table, should not ... really restrict the left table but instead rows that fail to meet the condition to be joined with NULL rows from the right table. (CVS 2725) FossilOrigin-Name: ea10f9785e3c5248dafcc297f3a2c5465b6e0dba	2005-09-19 21:05:48 +00:00