Postgresql 12.9 = Operator issue

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



Greeting All,

 

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)

 

 

Request your help to know wtr this is a bug or not. If bug , is there any work around ?

 

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

 

 

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

[Index of Archives]     [Postgresql Home]     [Postgresql General]     [Postgresql Performance]     [Postgresql PHP]     [Postgresql Jobs]     [PHP Users]     [PHP Databases]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Databases]     [Yosemite Forum]

  Powered by Linux