Invalid code generated for negative of byte and short values

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.