Re: [sqlite] Returning NULL or empty values when the SELECT does not satisfy all of the query

On Fri, 5 Apr 2019 18:54:18 + Jose Isaias Cabrera wrote: > Why does this work I don't know what "work" means, but I can explain the difference. With an outer join, JOIN and WHERE are not the same. In analyzing the query, we consider JOIN before WHERE. > select > a.*, b.* from t as a LE

[sqlite] Reporting two more interesting queries with performance regression

Hello, We are submitting the third report with two more interesting cases with bisecting result using "SQL-Perf-Fuzzer". This is the timeline of our activities: [Apr 1, 2019] Submitted 1st report (3 queries, 1 bisected commits) ( http://mailinglists.sqlite.org/cgi-bin/mailman/private/sqlite-