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.
