BUG #13747: Like clause ignoring raws with null value

From: dtyshecky(at)gmail(dot)com
To: pgsql-bugs(at)postgresql(dot)org
Subject: BUG #13747: Like clause ignoring raws with null value
Date: 2015-10-29 23:08:46
Message-ID: 20151029230846.931.69856@wrigleys.postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

The following bug has been logged on the website:

Bug reference: 13747
Logged by: Denys Tyshetskyy
Email address: dtyshecky(at)gmail(dot)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.

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message adam.c.scott 2015-10-30 00:39:24 BUG #13748: Syntax error not emitted
Previous Message Michael Paquier 2015-10-29 22:42:43 Re: BUG #13744: Postgresql function auto add 's' character to the end of string