Re: [HACKERS] Bug in LIKE ? - Mailing list pgsql-hackers

From Tom Lane
Subject Re: [HACKERS] Bug in LIKE ?
Date
Msg-id 24661.928766023@sss.pgh.pa.us
Whole thread Raw
In response to Re: [HACKERS] Bug in LIKE ?  (Oleg Bartunov <oleg@sai.msu.su>)
List pgsql-hackers
Oleg Bartunov <oleg@sai.msu.su> writes:
> [ doesn't see a problem ]

I think the particular test case Daniele gave would only fail if you
do not have USE_LOCALE defined.  But it's definitely busted: the parser
was transformingb LIKE 'foo%'
intob LIKE 'foo%' AND b >= 'fo%' AND b <= 'fo%\377'

with the third clause not present if USE_LOCALE is defined.

Anyway, it's fixed now.  I also cleaned up some confusion about whether
"%%" in a LIKE pattern means a literal % (the SQL spec says not, and
some parts of the code knew it, but other parts didn't...)
        regards, tom lane


pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: [HACKERS] Priorities for 6.6
Next
From: ZEUGSWETTER Andreas IZ5
Date:
Subject: Re: [HACKERS] Open 6.5 items