Postgres Pro
Downloads
Home   >   mailing lists

Re: BUG #17986: Inconsistent results of SELECT affected by btree index - Mailing list pgsql-bugs

From Zu-Ming Jiang
Subject Re: BUG #17986: Inconsistent results of SELECT affected by btree index
Date
Msg-id 5095c4dd-dcce-1af2-0be3-9fba11db6c96@inf.ethz.ch
Whole thread Raw
In response to Re: BUG #17986: Inconsistent results of SELECT affected by btree index  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: BUG #17986: Inconsistent results of SELECT affected by btree index  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-bugs
Tree view
Thanks for your information! I checked it again. Seems this bug can be reproduced when I used "quick-fix-for-bug-17985.patch" for bug 17985, but cannot be reproduced after I used "better-fix-for-bug-17985.patch". So it was fixed by the patch "better-fix-for-bug-17985.patch".

Best wishes,
Zuming

From: Tom Lane [mailto:tgl@sss.pgh.pa.us]
Sent: Wednesday, June 21, 2023 at 6:11 AM
To: Tomas Vondra
Subject: BUG #17986: Inconsistent results of SELECT affected by btree index

Tomas Vondra <tomas.vondra@enterprisedb.com> writes:

On 6/20/23 22:54, PG Bug reporting form wrote:

My fuzzer finds a correctness bug in Postgres, which makes Postgres return
inconsistent results.

I can't reproduce this with current master - perhaps one of the commits
since efeb12ef0b fixes this too?

It looks like this is another manifestation of the hashjoin bug
fixed in 45392626c.
			regards, tom lane



		
	


	

					

					





	

	pgsql-bugs by date:
	
	

	
	

		
			

	        	

	       			Previous
	    		

	    		
	From:
	Richard Guo

	Date:
	



	Subject:
	Re: BUG #17978: Unexpected error: "wrong varnullingrels (b) (expected (b 5)) for Var 6/2" triggered by JOIN
 

	    	

	    
	    
	    
			

	        	

	       			Next
	    		

	    		
	From:
	Dmitry Dolgov

	Date:
	



	Subject:
	Re: BUG #17949: Adding an index introduces serialisation anomalies.