[CALCITE-3884] Return type for SIGN function is incorrect

• Type: Bug
• Status: Open
• Priority: Minor
• Resolution: Unresolved
• Component/s: core
• Labels: pull-request-available
• Assignee: Unassigned
• Reporter: Juhwan Kim
• Created: 28/Mar/20 05:44
• Updated: 18/Apr/20 04:14

Description

It appears the metadata for the SIGN function in Calcite is incorrect, it uses the input metadata as the output metadata.

 SqlStdOperatorTable.java#L1713 

This works in most cases but for Decimal where prec=scale, this doesn’t work since there can be no whole digits. The return metadata should really be an int, or if you want to match types then DECIMAL(1, 0) if the input metadata is any DECIMAL.

Issue Links

• links to: GitHub Pull Request #1923