Hi all, I've got an off-list bug report from Alexander Lakhin involving a placeholder variable. Alena and Andrei proposed a fix. It is fairly simple: we just shouldn't remove PHVs during self-join elimination, as they might still be referenced from other parts of a query. The patch is attached. I'm going to fix this if no objections.
------ Regards, Alexander Korotkov Supabase
v1-0001-Disallow-removing-placeholders-during-Self-Join-E.patch
Description: Binary data