[SPARK-22359] Improve the test coverage of window functions

• Type: Test
• Status: Resolved
• Priority: Major
• Resolution: Incomplete
• Affects Version/s: 2.3.0
• Component/s: SQL
• Labels: bulk-closed
• Assignee: Unassigned
• Reporter: Xingbo Jiang
• Created: 26/Oct/17 11:52
• Updated: 17/Aug/20 07:45
• Resolved: 08/Oct/19 05:41

Description

There are already quite a few integration tests using window functions, but the unit tests coverage for window funtions is not ideal.
We'd like to test the following aspects:

• Specifications
  • different partition clauses (none, one, multiple)
  • different order clauses (none, one, multiple, asc/desc, nulls first/last)
• Frames and their combinations
  • OffsetWindowFunctionFrame
  • UnboundedWindowFunctionFrame
  • SlidingWindowFunctionFrame
  • UnboundedPrecedingWindowFunctionFrame
  • UnboundedFollowingWindowFunctionFrame
• Aggregate function types
  • Declarative
  • Imperative
  • UDAF
• Spilling
  • Cover the conditions that WindowExec should spill at least once