Re: [sqlite] Bug report: Incorrect output of a LEFT JOIN with row-values in expression

2016-10-26 Thread Richard Hipp
On 10/26/16, Ján Hric wrote: > Hello > I would like to report a bug in the latest version of SQLite (3.15.0). Thanks for a very clear and succinct bug report. Well done! The ticket is here: https://www.sqlite.org/src/tktview/fef4bb4bd9185ec8f18d9912abb444da61d02ff2 > > Description: > If compa

[sqlite] Bug report: Incorrect output of a LEFT JOIN with row-values in expression

2016-10-26 Thread Ján Hric
Hello I would like to report a bug in the latest version of SQLite (3.15.0). Description: If comparison of row-values is used in the expression of a LEFT JOIN clause and no mach is found, instead of one row with values from the left-hand table, no rows are returned. Example code: CREATE TABLE t1