Numeric type promotion in expressions

In expressions that use only integer types, Derby promotes
the type of the result to at least INTEGER. In expressions that mix integer
with non-integer types, Derby promotes
the result of the expression to the highest type in the expression. Type Promotion in Expressions shows the promotion of data types in expressions.