[SPARK-45584] Execution fails when there are subqueries in TakeOrderedAndProjectExec

• Type: Bug
• Status: Resolved
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 3.5.0
• Fix Version/s: 4.0.0, 3.5.1
• Component/s: SQL
• Labels: pull-request-available
• Assignee: Allison Wang
• Reporter: Allison Wang
• Created: 18/Oct/23 03:49
• Updated: 20/Oct/23 00:39
• Resolved: 20/Oct/23 00:39

Description

When there are subqueries in TakeOrderedAndProjectExec, the query can throw this exception:

 java.lang.IllegalArgumentException: requirement failed: Subquery subquery#242, id=#109 has not finished 

This is because TakeOrderedAndProjectExec does not wait for subquery execution.

Issue Links

• links to: GitHub Pull Request #43419