From: PG Bug reporting form <noreply@postgresql.org>
To: pgsql-bugs@lists.postgresql.org
Cc: satish.nayak@nmc.ae
Subject: BUG #17410: After upgrade to postgresql 12.9 from 12.6 , some of the statements having ”=” operator not returnin
Date: Fri, 18 Feb 2022 15:04:20 +0000
Message-ID: <17410-71d069d3f9dbb637@postgresql.org> (raw)
The following bug has been logged on the website:
Bug reference: 17410
Logged by: satish nayak
Email address: satish.nayak@nmc.ae
PostgreSQL version: 12.9
Operating system: Ubuntu 9.3.0-17ubuntu1~20.04 9.3.0, 64-bit
Description:
After upgrade to postgresql 12.9 from 12.6 , some of the statements having
”=” operator not returning any rows..
Eg :
----------------------------------------------------------------------------------------------------------------------------------
PostgreSQL 12.9 (Ubuntu 12.9-2.pgdg20.04+1) on x86_64-pc-linux-gnu,
compiled by gcc (Ubuntu 9.3.0-17ubuntu1~20.04) 9.3.0, 64-bit
(1 row)
=> \x
Expanded display is on.
=> select * from store_item_details where medicine_name ='DEXTROSE 10% :500
ML';
(0 rows)
Where as in 12.6 version , we are able to see the row.
-[ RECORD 1
]----------------------------------------------------------------------------------------------------------------------------------------
version | PostgreSQL 12.6 (Ubuntu 12.6-1.pgdg16.04+1) on
x86_64-pc-linux-gnu, compiled by gcc (Ubuntu 5.4.0-6ubuntu1~16.04.12) 5.4.0
20160609, 64-bit
hmsuat=# \x
Expanded display is off.
hmsuat=# select * from store_item_details where medicine_name ='DEXTROSE
10% :500 ML';
hmsuat=# select count(1) from store_item_details where medicine_name
='DEXTROSE 10% :500 ML';
count
-------
1
(1 row)
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-bugs@postgresql.org
Cc: noreply@postgresql.org, pgsql-bugs@lists.postgresql.org, satish.nayak@nmc.ae
Subject: Re: BUG #17410: After upgrade to postgresql 12.9 from 12.6 , some of the statements having ”=” operator not returnin
In-Reply-To: <17410-71d069d3f9dbb637@postgresql.org>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox