[FLINK-34348] Release Testing: Verify FLINK-20281 Window aggregation supports changelog stream input

• Type: Sub-task
• Status: Closed
• Priority: Blocker
• Resolution: Fixed
• Affects Version/s: 1.19.0
• Fix Version/s: 1.19.0
• Component/s: Table SQL / API
• Labels: release-testing
• Assignee: Feng Jin
• Reporter: xuyang
• Created: 04/Feb/24 03:28
• Updated: 20/Feb/24 07:37
• Resolved: 20/Feb/24 07:37

Description

Window TVF aggregation supports changelog stream  is ready for testing. User can add a window tvf aggregation as a down stream after CDC source or some nodes that will produce cdc records.

Someone can verify this feature with:

1. Prepare a mysql table, and insert some data at first.
2. Start sql-client and prepare ddl for this mysql table as a cdc source.
3. You can verify the plan by `EXPLAIN PLAN_ADVICE` to check if there is a window aggregate node and the changelog contains "UA" or "UB" or "D" in its upstream. 
4. Use different kinds of window tvf to test window tvf aggregation while updating the source data to check the data correctness.

Issue Links

• is a clone of: FLINK-34301 Release Testing Instructions: Verify FLINK-20281 Window aggregation supports changelog stream input