SQLite Forum

Typo in "The LIKE Optimization" docs
Login

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.