[CALCITE-4282] Promote the window table functions window attribute data type with precision 3

• Type: Improvement
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 1.25.0
• Fix Version/s: 1.26.0
• Component/s: core
• Labels: pull-request-available
• Assignee: Danny Chen
• Reporter: Danny Chen
• Created: 26/Sep/20 09:08
• Updated: 06/Oct/20 17:16
• Resolved: 29/Sep/20 02:08

Description

Now the window_start and window_end has a type of a Timestamp with default system precision. But, actually, many DB vendors has default precision as 6 (which is also defined in the SQL standard).

We better promote the precision to 3 because:
1. For windowing, time unit as millisecond is enough
2. Make the precision deterministic instead of overriding by each engine's default one

Issue Links

• links to: GitHub Pull Request #2176