Re: [sqlite] Issue with LEFT JOIN, index, and literal in ON clause

Daniel Ring wrote: > The following behavior when using LEFT OUTER JOIN with an indexed column > and literals in the ON clause is, I'm pretty sure, wrong. SQLite seems > to convert the join to an INNER JOIN in some cases. > > The capture is from SQLite 3.4.2, but I get the same results with 3.5.7.

[sqlite] Issue with LEFT JOIN, index, and literal in ON clause

The following behavior when using LEFT OUTER JOIN with an indexed column and literals in the ON clause is, I'm pretty sure, wrong. SQLite seems to convert the join to an INNER JOIN in some cases. The capture is from SQLite 3.4.2, but I get the same results with 3.5.7. I also copied the raw SQL