[GENERAL] ilike and --enable-multibyte=KOI8

2000-12-12 Thread Juriy Goloveshkin
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

Re: [GENERAL] ilike and --enable-multibyte=KOI8

2000-12-10 Thread Tatsuo Ishii
> On Sun, Dec 10, 2000 at 12:37:52AM +0900, Tatsuo Ishii wrote: > > I found a silly bug with src/backend/utils/adt/like.c. Can you try out > > attached pacthes? > It looks good. pgsql doesn't crash now. thank you. Ok, I will commit the pacthes. -- Tatsuo Ishii

Re: [GENERAL] ilike and --enable-multibyte=KOI8

2000-12-10 Thread Juriy Goloveshkin
On Sun, Dec 10, 2000 at 12:37:52AM +0900, Tatsuo Ishii wrote: > I found a silly bug with src/backend/utils/adt/like.c. Can you try out > attached pacthes? It looks good. pgsql doesn't crash now. thank you. -- Bye Juriy Goloveshkin

Re: [GENERAL] ilike and --enable-multibyte=KOI8

2000-12-08 Thread Tatsuo Ishii
> 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

[GENERAL] ilike and --enable-multibyte=KOI8

2000-12-07 Thread Juriy Goloveshkin
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