Thread: 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.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)


On Fri, Feb 18, 2022 at 9:01 AM PG Bug reporting form <noreply@postgresql.org> wrote:
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..

Duplicate of a pgsql-admin email.

O/S Upgraded, needs to ReIndex.

David J.

Greetings All,

 

Thanks for the support, index rebuild solved the issue .

Sorry for duplicate request.

 

Regards,

 

Satish Chikkathammaiah,

Manager Database Administration

 

NMC Healthcare Ltd (In Administration)

Registered Office: DD#16 - 109 - 001, 16th Floor, WeWork Hub71,

Al Khatem Tower, ADGM Squre, Al Mariya Island, Abu Dhabi, UAE.

T: +971 2 207 6217 Ext: 15086  |  F: +971 2 633 2256  |  M: +971 509148678

9th Floor, Al Ain Tower, Khalidiyah, Abu Dhabi, UAE

 

 

 

From: "David G. Johnston" <david.g.johnston@gmail.com>
Date: Friday, February 18, 2022 at 8:05 PM
To: "Satish Nayak [NMC - IT]" <satish.nayak@nmc.ae>, PostgreSQL mailing lists <pgsql-bugs@lists.postgresql.org>
Subject: Re: BUG #17410: After upgrade to postgresql 12.9 from 12.6 , some of the statements having ”=” operator not returnin

 

***This email was sent from a source outside of NMC***

Do NOT ACT on any instructions given on email unless you recognize the Sender, If in doubt please contact the Sender directly for confirmation.Do not click on links or open attachments unless you recognize the sender.

 

On Fri, Feb 18, 2022 at 9:01 AM PG Bug reporting form <noreply@postgresql.org> wrote:

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..

 

Duplicate of a pgsql-admin email.

 

O/S Upgraded, needs to ReIndex.

 

David J.

 

'Classification: Restricted
On 27 September 2020 a number of the entities of the NMC Healthcare group were placed into administration under Abu Dhabi Global Market Regulations. Richard Fleming and Ben Cairns have been appointed Joint Administrators in this regard to manage the affairs, business and property of the relevant companies in administration as agents without personal liability. In that capacity the Joint Administrators have delegated certain powers to the board of directors to act as agents of the relevant companies. For full information regarding these appointments please redirect to this web page: https://nmc.ae/
This e-mail message including any attachments is intended solely for the addressee(s) and may contain privileged information. If you have received this email by mistake, please notify the sender and delete the message destroying any hard copies of the original message. This message does not contain financial instructions or commitments of any kind. Any views expressed in this message are those of the individual sender. NMC accepts no liability for any damage caused by any virus/worms transmitted by this email..