From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
---|---|
To: | Oleg Bartunov <oleg(at)sai(dot)msu(dot)su> |
Cc: | Daniele Orlandi <daniele(at)orlandi(dot)com>, pgsql-hackers(at)hub(dot)org, The Hermit Hacker <scrappy(at)hub(dot)org> |
Subject: | Re: [HACKERS] Bug in LIKE ? |
Date: | 1999-06-07 14:33:43 |
Message-ID: | 24661.928766023@sss.pgh.pa.us |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
Oleg Bartunov <oleg(at)sai(dot)msu(dot)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 transforming
b LIKE 'foo%'
into
b 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
From | Date | Subject | |
---|---|---|---|
Next Message | Thomas Lockhart | 1999-06-07 14:41:21 | Re: [COMMITTERS] [WEBMASTER] 'www/html/docs Pg.pm.html faq-dev-english.html faq-english.html faq-hpux.html faq-irix.html faq-linux.html index.html Pg.pm.shtml faq-dev-english.shtml faq-english.shtml faq-hpux.shtml faq-irix.shtml faq-linux.shtml' |
Previous Message | Bruce Momjian | 1999-06-07 14:30:15 | Re: [HACKERS] Open 6.5 items |