[CALCITE-2180] Invalid code generated for negative of byte and short values

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Fix Version/s: 1.16.0
• Assignee: Julian Hyde
• Reporter: Julian Hyde
• Created: 15/Feb/18 20:20
• Updated: 27/Feb/24 22:23
• Resolved: 16/Feb/18 22:40

Description

Invalid code is generated for negative of byte and short values. The reason is that, in Java, if b is a value of type byte, then -b has type int; similarly if b has type short. The code generator needs to accommodate for this.

The query

select -deptno from dept

demonstrates the problem, since deptno has SQL type TINYINT.