| From: | Peter Eisentraut <peter(at)eisentraut(dot)org> |
|---|---|
| To: | "David G(dot) Johnston" <david(dot)g(dot)johnston(at)gmail(dot)com>, Anmol Mohanty <anmol(dot)mohanty(at)salesforce(dot)com> |
| Cc: | pgsql-bugs(at)lists(dot)postgresql(dot)org |
| Subject: | Re: BUG #18765: Inconsistent behaviour and errors with LIKE |
| Date: | 2025-01-08 20:52:29 |
| Message-ID: | 83c66908-ff3e-4aa1-8d90-1647d8dc8baa@eisentraut.org |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-bugs |
On 06.01.25 20:25, David G. Johnston wrote:
> On Mon, Jan 6, 2025 at 12:07 PM Anmol Mohanty
> <anmol(dot)mohanty(at)salesforce(dot)com <mailto:anmol(dot)mohanty(at)salesforce(dot)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.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2025-01-08 21:12:32 | Re: BUG #18765: Inconsistent behaviour and errors with LIKE |
| Previous Message | Andrew Dunstan | 2025-01-08 14:45:19 | Re: pg_rewind fails on Windows where tablespaces are used |