Re: [sqlite] Documentation bug: it's ESCAPE not EXCEPT that limit LIKE optimisation

On 1/7/15, Dima Tisnek wrote: > Documentation states: > > The LIKE optimization is not attempted if there is an EXCEPT phrase on > the LIKE operator. > > However you can't really slap EXCEPT (a kind of set difference join) > on top of LIKE. > Thanks for bring that to my

[sqlite] Documentation bug: it's ESCAPE not EXCEPT that limit LIKE optimisation

Documentation states: The LIKE optimization is not attempted if there is an EXCEPT phrase on the LIKE operator. However you can't really slap EXCEPT (a kind of set difference join) on top of LIKE. Instead, what is meant is that ESCAPE modifier disables LIKE optimisation. And that's really the