BUG #17410: After upgrade to postgresql 12.9 from 12.6 , some of the statements having ”=” operator not returnin

The following bug has been logged on the website:

Bug reference: 17410
Logged by: satish nayak
Email address: satish(dot)nayak(at)nmc(dot)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)