| From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
|---|---|
| To: | Daniele Orlandi <daniele(at)orlandi(dot)com> |
| Cc: | The Hermit Hacker <scrappy(at)hub(dot)org>, pgsql-hackers(at)hub(dot)org |
| Subject: | Re: [HACKERS] Bug in LIKE ? |
| Date: | 1999-06-07 13:44:07 |
| Message-ID: | 23773.928763047@sss.pgh.pa.us |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
Daniele Orlandi <daniele(at)orlandi(dot)com> writes:
> Uhm.... I think the problem is a little worse:
It's a real bug, and I see the problem: someone changed the handling of
LIKE prefixes in gram.y, without understanding quite what they were
doing. 6.4.2 has:
if (n->val.val.str[pos] == '\\' ||
n->val.val.str[pos] == '%')
pos++;
where 6.5 has:
if (n->val.val.str[pos] == '\\' ||
n->val.val.str[pos+1] == '%')
pos++;
The first one is right and the second is not.
Unless we fix this, LIKE will be completely busted for any string
containing non-leading %. Shall I ... ?
regards, tom lane
| From | Date | Subject | |
|---|---|---|---|
| Next Message | The Hermit Hacker | 1999-06-07 13:50:47 | Re: [HACKERS] Bug in LIKE ? |
| Previous Message | The Hermit Hacker | 1999-06-07 13:40:55 | Re: [HACKERS] postgresql-v6.5beta2.tar.gz ... |