Re: BUG #13349: Recheck logic with index mixed up when used with LATERAL - Mailing list pgsql-bugs

On 05/25/2015 08:25 AM, lr@pcorp.us wrote:
> The following bug has been logged on the website:
>
> Bug reference:      13349
> Logged by:          Regina Obe
> Email address:      lr@pcorp.us
> PostgreSQL version: Unsupported/Unknown
> Operating system:   Debian, Mingw-64 Postgresql 9.5 Recheck logic
> Description:
>
> We are finding issues in our PostGIS KNN distance recheck, and think the
> issue is with PostgreSQL since we can replicate with PostgreSQL built-in
> geometry types
>
> This issue only seems to happen if the LATERAL clause works against multiple
> records.

Thanks, fixed! I forgot to reset the new "reached end" flag when the
node is rescanned.

- Heikki