Fixed now. Tnx. On 4/12/18, Keith Medcalf <kmedc...@dessus.com> wrote: > > https://sqlite.org/optoverview.html > > 15, the push down optimization. The BETWEEN clause is in error? > > SELECT x, y, b > FROM t2 > JOIN (SELECT DISTINCT a, b FROM t1 WHERE b BETWEEN 10 AND 20) > WHERE b BETWEEN 10 AND 10; > > should probably be BETWEEN 10 AND 20; > > --- > The fact that there's a Highway to Hell but only a Stairway to Heaven says a > lot about anticipated traffic volume. > > > > > > _______________________________________________ > sqlite-users mailing list > sqlite-users@mailinglists.sqlite.org > http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users >
-- D. Richard Hipp d...@sqlite.org _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users