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

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

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

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