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.
Table 1. Type Promotion in Expressions
Largest Type That Appears
in Expression |
Resulting Type of Expression |
DOUBLE PRECISION |
DOUBLE PRECISION |
REAL |
DOUBLE PRECISION |
DECIMAL |
DECIMAL |
BIGINT |
BIGINT |
INTEGER |
INTEGER |
SMALLINT |
INTEGER |