Re: ILIKE + OR fault - propably a memory leak

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: ILIKE + OR fault - propably a memory leak
Дата
Msg-id 2698.999794874@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: ILIKE + OR fault - propably a memory leak  (Michał Pasternak <doc@lublin.t1.pl>)
Список 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 по дате отправления:

Предыдущее
От: Bruce Momjian
Дата:
Сообщение: Re: Using nulls with earthdistance operator crashes backend
Следующее
От: Larry Rosenman
Дата:
Сообщение: cvs tip: gmake breakage.