Postgres Pro
Downloads
Home   >   mailing lists

BUG #13747: Like clause ignoring raws with null value - Mailing list pgsql-bugs

From dtyshecky@gmail.com
Subject BUG #13747: Like clause ignoring raws with null value
Date
Msg-id 20151029230846.931.69856@wrigleys.postgresql.org
Whole thread Raw
Responses 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>)
List pgsql-bugs
Tree view 
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 by date:

Previous
From: David Gould
Date:
Subject: Re: BUG #13750: Autovacuum slows down with large numbers of tables. More workers makes it slower.
Next
From: digoal@126.com
Date:
Subject: BUG #13749: PostgreSQL cann't compress random data?