| Lists: | pgsql-bugs |
|---|
| From: | "Andrew Gierth" <andrew(at)tao11(dot)riddles(dot)org(dot)uk> |
|---|---|
| To: | pgsql-bugs(at)postgresql(dot)org |
| Subject: | BUG #4821: LIKE '%_' fails |
| Date: | 2009-05-23 01:01:52 |
| Message-ID: | 200905230101.n4N11qkW047694@wwwmaster.postgresql.org |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Lists: | pgsql-bugs |
The following bug has been logged online:
Bug reference: 4821
Logged by: Andrew Gierth
Email address: andrew(at)tao11(dot)riddles(dot)org(dot)uk
PostgreSQL version: 8.3-8.4
Operating system: all
Description: LIKE '%_' fails
Details:
# select 'foo' like '%_';
?column?
----------
f
(1 row)
correct result would be 't'
8.1 and 8.2 seem to get this one right.
| From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
|---|---|
| To: | "Andrew Gierth" <andrew(at)tao11(dot)riddles(dot)org(dot)uk> |
| Cc: | pgsql-bugs(at)postgresql(dot)org |
| Subject: | Re: BUG #4821: LIKE '%_' fails |
| Date: | 2009-05-24 17:15:20 |
| Message-ID: | 22567.1243185320@sss.pgh.pa.us |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Lists: | pgsql-bugs |
"Andrew Gierth" <andrew(at)tao11(dot)riddles(dot)org(dot)uk> writes:
> # select 'foo' like '%_';
> ?column?
> ----------
> f
> (1 row)
> correct result would be 't'
Hmmm ... there's actually special-case code for '%_' in there,
but it seems to be just plain broken.
regards, tom lane