Fixed now. Tnx.
On 4/12/18, Keith Medcalf 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