Omega359 commented on PR #22161:
URL: https://github.com/apache/datafusion/pull/22161#issuecomment-4527182691

   ```
   SELECT id
   FROM (
       SELECT id, UNNEST(UNNEST(make_array(arrow_cast(make_array(), 
'List(Int64)')))) AS elem
       FROM unused_unnest_pruning
   )
   GROUP BY id
   ORDER BY id;
   ```
   
   Expected result is empty, because the outer list is non-empty but the inner 
list is empty, so recursive UNNEST removes all rows before grouping.
   
   main returns no results, this PR returns 
   1
   2
   3


-- 
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