victrvondoom commented on issue #27566: URL: https://github.com/apache/datafusion/issues/27566#issuecomment-7004278394
Thanks for the minimal repro. I traced `DecorrelateLateralJoin`: correlated filters are pulled up and columns are requalified against the inner schema/alias. Because this query has two visible `a` fields before `COUNT(*)`, a useful regression in the lateral/decorrelation SQLLogicTests would preserve field identity (not just the bare name): assert exactly three outer rows with count 3, then add a control that renames one `a` to show the duplicate-name collision is what matters. If resolution cannot be preserved, returning an ambiguity error is preferable to silently producing nine rows. Could you assign this to me? I can investigate and send a fix. -- This is an automated message from the Apache Git Service. To respond to the message, please log on to GitHub and use the URL above to go to the specific comment. To unsubscribe, e-mail: [email protected] For queries about this service, please contact Infrastructure at: [email protected] --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
