Re: BUG #14512: Backslashes in LIKE

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "David G(dot) Johnston" <david(dot)g(dot)johnston(at)gmail(dot)com>
Cc: Vojtěch Rylko <vojta(dot)rylko(at)gmail(dot)com>, "pgsql-bugs(at)postgresql(dot)org" <pgsql-bugs(at)postgresql(dot)org>
Subject: Re: BUG #14512: Backslashes in LIKE
Date: 2017-01-24 19:32:14
Message-ID: 10287.1485286334@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

"David G. Johnston" <david(dot)g(dot)johnston(at)gmail(dot)com> writes:
> Then consider a feature request that a malformed pattern be detected and
> fail independent of the data being checked. Such non-deterministic failure
> is at least a POLA violation and makes what should be a basically
> compile-time error into a run-time one.

Meh. We could do something like the attached, but I think it would be a
net performance drag in practically all cases, and I doubt it is worth it.

regards, tom lane

Attachment Content-Type Size
check-all-of-LIKE-pattern.patch text/x-diff 4.0 KB

In response to

Browse pgsql-bugs by date

  From Date Subject
Next Message shawn.inder 2017-01-24 19:48:30 BUG #14513: Missing column names when viewing tables
Previous Message David G. Johnston 2017-01-24 18:15:08 Re: BUG #14512: Backslashes in LIKE