sqlite

database/sqlite

Fork 0

mirror of https://github.com/sqlite/sqlite.git synced 2026-10-25 09:59:22 +03:00

Commit Graph

Author	SHA1	Message	Date
drh	72e8fa42f9	Correctly handle NULLs in IN operators. Ticket #2273 . The changes in where.c and in the WhereLevel.aInLoop structure are not strictly necessary to fix this problem - they just make the code easier to read. Only the change in OP_Next/OP_Prev operator of vdbe.c is required. (CVS 3735) FossilOrigin-Name: 26348556d824c032851e409ac510cddb55c200bf	2007-03-28 14:30:06 +00:00
drh	f2d315d0c2	Fix an additional problem with the IS NULL optimization on LEFT JOINs. Ticket #2189. See also ticket #2177. (CVS 3602) FossilOrigin-Name: 358dd82d3a921228155e2cf9e22aedd2b651ca9c	2007-01-25 16:56:06 +00:00
drh	c49de5d98c	Make sure the IS NULL optimization introduced by check-in (3494) correctly handles a LEFT JOIN where the a term from the right table of the join uses an IS NULL constraint. Ticket #2177. This check-in also adds the new test cases that were suppose to have been added with (3494) but which were mistakenly omitted. (CVS 3595) FossilOrigin-Name: 335863e4d16113fb9ecebce35d2db043771d98b1	2007-01-19 01:06:01 +00:00

Author

SHA1

Message

Date

drh

72e8fa42f9

Correctly handle NULLs in IN operators. Ticket #2273 .

The changes in where.c and in the WhereLevel.aInLoop structure are
not strictly necessary to fix this problem - they just make the code
easier to read.  Only the change in OP_Next/OP_Prev operator of vdbe.c
is required. (CVS 3735)

FossilOrigin-Name: 26348556d824c032851e409ac510cddb55c200bf

2007-03-28 14:30:06 +00:00

drh

f2d315d0c2

Fix an additional problem with the IS NULL optimization on LEFT JOINs.

Ticket #2189.  See also ticket #2177. (CVS 3602)

FossilOrigin-Name: 358dd82d3a921228155e2cf9e22aedd2b651ca9c

2007-01-25 16:56:06 +00:00

drh

c49de5d98c

Make sure the IS NULL optimization introduced by check-in (3494) correctly

handles a LEFT JOIN where the a term from the right table of the join uses
an IS NULL constraint.  Ticket #2177.  This check-in also adds the new test
cases that were suppose to have been added with (3494) but which were
mistakenly omitted. (CVS 3595)

FossilOrigin-Name: 335863e4d16113fb9ecebce35d2db043771d98b1

2007-01-19 01:06:01 +00:00

3 Commits