[FLINK-22179] Manual test time function changes and new time attributes support

• Type: Sub-task
• Status: Closed
• Priority: Blocker
• Resolution: Resolved
• Affects Version/s: 1.13.0
• Fix Version/s: 1.13.0
• Component/s: Table SQL / API
• Labels: release-testing
• Assignee: Jark Wu
• Reporter: Leonard Xu
• Created: 09/Apr/21 09:43
• Updated: 20/Apr/21 07:29
• Resolved: 20/Apr/21 07:29

Description

• 1. Test time functions return expected value in both batch and streaming mode, we can use Sql-client to test.

• LOCALTIME
• LOCALTIMESTAMP
• CURRENT_DATE
• CURRENT_TIME
• CURRENT_TIMESTAMP
• NOW()
• PROCTIME()

• 2. Test PROCTIME attribute works well in different case, eg(`interval join`, `temporal join(lookup)`, `window`), and check sink.partition-commit.trigger that used proctime is as expected in Hive/FileSystem sink

• 3. Test ROWTIME attribute that use TIMESTAMP_LTZ, cover `interval join`, `temporal join`, `window` scenarios

• 4. Test the `window` result is as expected in DaylightSaving timezone