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]

Reply via email to