Re: ilike and --enable-multibyte=KOI8 - Mailing list pgsql-general

From Tatsuo Ishii
Subject Re: ilike and --enable-multibyte=KOI8
Date
Msg-id 20001208202326A.t-ishii@sra.co.jp
Whole thread Raw
In response to ilike and --enable-multibyte=KOI8  (Juriy Goloveshkin <juriy@avias.com>)
Responses Re: ilike and --enable-multibyte=KOI8  (Juriy Goloveshkin <juriy@avias.com>)
List pgsql-general
> Hello, Can anybody check and confirm(or not) this:
>
> if pgsql(DEVEL, from cvs-server) is built with locale and multibyte then
>
> "select * from table where row ilike '%a%'" crashes pgsql.
> "select * from table where row ilike 'a%'" doesn't craches.
> "select * from table where row  like '%a%'" doesn't craches.
>
> If pgsql is built only with locale, pgsql isn't crashed...
>
> please, give me an advice for solving this problemm. I need pgsql with both
> this options...

Not reproduced here. It might be a bug depending on particular
data. Can you show me gdb backtrace?
--
Ttsuo Ishii

pgsql-general by date:

Previous
From: "Francis Solomon"
Date:
Subject: RE: Index question
Next
From: "Jonathan Ellis"
Date:
Subject: Re: Oracle-compatible lpad/rpad behavior