Documentation Typo : https://sqlite.org/optoverview.html section 15

[Keith Medcalf]

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
[hidden email]
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

[Richard Hipp-3]

Fixed now.  Tnx.

On 4/12/18, Keith Medcalf <[hidden email]> 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
> [hidden email]
> http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
>

--
D. Richard Hipp
[hidden email]
_______________________________________________
sqlite-users mailing list
[hidden email]
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users