BUG #18451: NULL fails to coerce to string when performing string comparison - Mailing list pgsql-bugs

From PG Bug reporting form
Subject BUG #18451: NULL fails to coerce to string when performing string comparison
Date
Msg-id 18451-dc130ad59b7bd7c9@postgresql.org
Whole thread Raw
Responses Re: BUG #18451: NULL fails to coerce to string when performing string comparison
Re: BUG #18451: NULL fails to coerce to string when performing string comparison
List pgsql-bugs
The following bug has been logged on the website:

Bug reference:      18451
Logged by:          Darryl Dixon
Email address:      darryl.dixon@gmail.com
PostgreSQL version: 14.11
Operating system:   Ubuntu 22.04 64Bit
Description:

postdb=# select where 'ab' like '%a%';
--
(1 row)

postdb=# select where 'ab'||NULL like '%a%';
--
(0 rows)

postdb=# select where 'ab'||NULL::text like '%a%';
--
(0 rows)

postdb=# select where 'ab'||format('%s', NULL::text) like '%a%';
--
(1 row)

postdb=# select version();
                                                                version
                                                           

----------------------------------------------------------------------------------------------------------------------------------------
 PostgreSQL 14.11 (Ubuntu 14.11-0ubuntu0.22.04.1) on x86_64-pc-linux-gnu,
compiled by gcc (Ubuntu 11.4.0-1ubuntu1~22.04) 11.4.0, 64-bit
(1 row)


pgsql-bugs by date:

Previous
From: David Rowley
Date:
Subject: Re: BUG #17855: Uninitialised memory used when the name type value processed in binary mode of Memoize
Next
From: Thomas Munro
Date:
Subject: Re: Re: edb installation failed for pgadmin when username is Chinese under c;\user #7432