Re: BUG #18765: Inconsistent behaviour and errors with LIKE

On 06.01.25 20:25, David G. Johnston wrote:
> On Mon, Jan 6, 2025 at 12:07 PM Anmol Mohanty 
> <anmol.mohanty@salesforce.com <mailto:anmol.mohanty@salesforce.com>> wrote:
> 
>     This is a violation of the SQL standard.
> 
> We do discuss where we vary from the SQL Standard in the 
> documentation for LIKE so a sentence covering this deviation seems 
> warranted.

I have also come across this issue recently, and I think we should 
actually fix it.  It makes sense to verify that the pattern is 
syntactically correct before trying to use it, instead of just using it 
incrementally and then erroring when you happen to hit the problematic bits.