/ Check-in [8b6574cf]
Login

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

Overview
Comment:Partial fix for a problem with LEFT OUTER JOIN. It used to be that the test for the right-hand table not matching the left table occurred after all ON, USING, WHERE clause processing. The test should occur after ON and USING clauses are checked but before the WHERE clause is check. This fix works as long as the total number of "AND" separated terms in the ON, USING, and WHERE clause does not exceed 32. To do: make this work for any number of terms and add test cases. that (CVS 639)
Downloads: Tarball | ZIP archive | SQL archive
Timelines: family | ancestors | descendants | both | trunk
Files: files | file ages | folders
SHA1:8b6574cfa86daaae910f8f3ee3c4723a21fb9e53
User & Date: drh 2002-06-24 22:01:58
Context
2002-06-25
01:09
Added support for the "sqlite_temp_master" table. Increased the version number to 2.5.2. (CVS 640) check-in: 9c1432bf user: drh tags: trunk
2002-06-24
22:01
Partial fix for a problem with LEFT OUTER JOIN. It used to be that the test for the right-hand table not matching the left table occurred after all ON, USING, WHERE clause processing. The test should occur after ON and USING clauses are checked but before the WHERE clause is check. This fix works as long as the total number of "AND" separated terms in the ON, USING, and WHERE clause does not exceed 32. To do: make this work for any number of terms and add test cases. that (CVS 639) check-in: 8b6574cf user: drh tags: trunk
12:20
Fix a VDBE stack leak in LEFT OUTER JOIN. Fix a bug in the code generator for JOIN ... USING(...). (CVS 638) check-in: d861489e user: drh tags: trunk
Changes
Unified Diffs Side-by-Side Diffs Patch

Changes to src/select.c.

Changes to src/sqliteInt.h.

Changes to src/where.c.