[CALCITE-6343] Ensure that AS operator (column alias) doesn't change return type of measures

• 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: Barry Kelly
• Created: 26/Mar/24 20:21
• Updated: 17/Oct/24 22:41
• Resolved: 17/Oct/24 22:41

Description

CALCITE-5869 introduced a change which removes MEASURE when inferring the return type when an operator is applied.

The AS keyword for aliases is implemented as an operator in the SQL AST. Using AS removes MEASURE when typing expressions that have an alias in the SELECT clause.

Thus, the type of SELECT m and SELECT m AS m are different when m is a measure. This is not desirable.

Proposed fix: don't change type when using the AS operator.

Issue Links

• links to: GitHub Pull Request #3741