Typo in "The LIKE Optimization" docs
(1) By Jens Alfke (snej) on 2020-04-20 23:50:40 [link] [source]
At https://sqlite.org/optoverview.html#like_opt :
The LIKE optimization will only be attempted if the right-hand side of the GLOB or LIKE operator is either literal string or a parameter that has been bound to a string literal. The string literal must not begin with a wildcard; if the right-hand side begins with a wildcard character then this optimization is attempted.
I believe that should end "is not attempted."
Although that entire last clause starting with "if the right-hand side..." seems redundant to me; it just restates the previous clause.
--Jens
(2) By Richard Hipp (drh) on 2020-04-21 01:33:25 in reply to 1 [source]
Thanks. Typo fixes and a new copy of the document has been uploaded.