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