Because it is not part of the the specification, the PartiQL reference implementation has made some decisions regarding automatic type coercion during expression evaluation. For example, for arithmetic operations involving numeric types, the following conversions apply:
Type 1
Type 2
Result Type
FLOAT
FLOAT
FLOAT
FLOAT
DECIMAL
DECIMAL
FLOAT
INT
FLOAT
DECIMAL
DECIMAL
DECIMAL
DECIMAL
INT
DECIMAL
INT
DECIMAL
DECIMAL
We should decide if this is what is best for PartiQL and include it in the specification.
Because it is not part of the the specification, the PartiQL reference implementation has made some decisions regarding automatic type coercion during expression evaluation. For example, for arithmetic operations involving numeric types, the following conversions apply:
We should decide if this is what is best for PartiQL and include it in the specification.