Re: BUG #18429: Inconsistent results on similar queries with join lateral - Mailing list pgsql-bugs

From Benoit Ryder
Subject Re: BUG #18429: Inconsistent results on similar queries with join lateral
Date
Msg-id MR1P264MB1971C01DA74122691EBBEE9FF9042@MR1P264MB1971.FRAP264.PROD.OUTLOOK.COM
Whole thread Raw
In response to Re: BUG #18429: Inconsistent results on similar queries with join lateral  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: BUG #18429: Inconsistent results on similar queries with join lateral
List pgsql-bugs
> This is kind of exciting for me, as IIRC it's the first field-detected
> bug that that work fixes.  However, I'm not real sure right now how
> we might fix it in the back branches ...

Thanks for the insight! And I'm glad this report can be help. :)

Would you know a way to avoid this bug? I could probably tweak the query
until the result is looking good, but I would prefer to make sure the
bug won't reappear if the query is used with different data or context.



pgsql-bugs by date:

Previous
From: Tom Lane
Date:
Subject: Re: BUG #18429: Inconsistent results on similar queries with join lateral
Next
From: Tom Lane
Date:
Subject: Re: BUG #18429: Inconsistent results on similar queries with join lateral