BUG #13747: Like clause ignoring raws with null value

Поиск
Список
Период
Сортировка
От dtyshecky@gmail.com
Тема BUG #13747: Like clause ignoring raws with null value
Дата
Msg-id 20151029230846.931.69856@wrigleys.postgresql.org
обсуждение исходный текст
Ответы Re: BUG #13747: Like clause ignoring raws with null value  ("Shulgin, Oleksandr" <oleksandr.shulgin@zalando.de>)
Re: BUG #13747: Like clause ignoring raws with null value  (Félix GERZAGUET <felix.gerzaguet@gmail.com>)
Список pgsql-bugs
Дерево обсуждения 
The following bug has been logged on the website:

Bug reference:      13747
Logged by:          Denys Tyshetskyy
Email address:      dtyshecky@gmail.com
PostgreSQL version: 9.2.0
Operating system:   ubuntu
Description:

I am executing select with like clause on the field X (select * from table
where x like '%ABC%')

In result I don't receive the raws with null in X column so I have to
manually state (where X is null or X like ...)

I would expect to receive columns with null.

В списке pgsql-bugs по дате отправления:

Предыдущее
От: David Gould
Дата:
Сообщение: Re: BUG #13750: Autovacuum slows down with large numbers of tables. More workers makes it slower.
Следующее
От: digoal@126.com
Дата:
Сообщение: BUG #13749: PostgreSQL cann't compress random data?