Re: ILIKE + OR fault - propably a memory leak - Mailing list pgsql-bugs

From Tom Lane
Subject Re: ILIKE + OR fault - propably a memory leak
Date
Msg-id 2698.999794874@sss.pgh.pa.us
Whole thread Raw
In response to Re: ILIKE + OR fault - propably a memory leak  (Michał Pasternak <doc@lublin.t1.pl>)
List pgsql-bugs
Michał Pasternak <doc@lublin.t1.pl> writes:
> Micha� Pasternak [Thu, Sep 06, 2001 at 12:25:24PM +0200]:
>> But this doesn't (and I need it to work):
>>
>> TYTUL_OR ILIKE 'Ocena%' OR TITLE LIKE 'Ocena%';
>> TYTUL_OR LIKE 'Ocena%' or TITLE LIKE 'Ocena%';

> Uh, I forgot: server starts to output something, which looks like a one row,
> one-field result with infinite length. It contains trashed values of normal
> output columns.

I don't see any such problem here, and I really doubt that the LIKE has
anything to do with it.  Possibly you've got corrupted data in a row
of that table that is selected by this query and not other queries?
        regards, tom lane


pgsql-bugs by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: Using nulls with earthdistance operator crashes backend
Next
From: Larry Rosenman
Date:
Subject: cvs tip: gmake breakage.