[CALCITE-6382] Type inference for SqlLeadLagAggFunction is incorrect

• Type: Bug
• Status: Closed
• Priority: Minor
• Resolution: Fixed
• Affects Version/s: 1.36.0
• Fix Version/s: 1.38.0
• Component/s: core
• Labels: pull-request-available
• Assignee: Unassigned
• Reporter: Mihai Budiu
• Created: 23/Apr/24 21:32
• Updated: 17/Oct/24 22:41
• Resolved: 17/Oct/24 22:41

Description

Currently the LeadLag operator does not use the default value when inferring the type of a column.

For the following example:

SELECT lead(c * 2, 1, -1.4) OVER (PARTITION BY x ORDER BY c) FROM t

The column 'c' has type INTEGER, and Calcite infers a type of INTEGER for the result. However, the default value for the lead is -1.4, which is DECIMAL, so the result type should be DECIMAL.

Currently Calcite only uses the nullability of the default value, but not its type in the result type inference.

Issue Links

• links to: GitHub Pull Request #3769