> > Not reproduced here. It might be a bug depending on particular
> > data. Can you show me gdb backtrace?
> I will try to make the easiest situation with this bug,
> for now, I know only this:
>
> 1. FreeBSD 4.2-STABLE, 5-CURRENT.
> 2. the freshest pgsql from cvs
> 3. I use locale, ru_RU.KOI8-R (Russian charset)
> 4. ./configure --enable-locale --enable-multibyte=KOI8
> 5. the query is(if in query remove following %, pg doesn't crash):
> ---
> select distinct films.* from films
> left join music_titles using(id_f)
> left join mt_authors using (id_mt)
> left join authors using(id_a)
> where
> music_titles.mus_name iLike '%asd%' and
> (films.director iLike '%qwe%' or authors.family iLike 'zxc%');
> ---
>
> 6. gdb shows:
[snip]
I found a silly bug with src/backend/utils/adt/like.c. Can you try out
attached pacthes?
--
Tatsuo Ishii