Details
-
Improvement
-
Status: Resolved
-
Major
-
Resolution: Fixed
-
None
-
None
-
None
Description
This document should describe the implicit casting rules in different operations: joins, "union all" and functions.
For example,
if t1.a1 is defined as an INTEGER and t2.a2 is defined as BIGINT, using these two columns in a join predicate will result in t1.a1 to be converted to BIGINT implicitly and explicit cast will not be needed:
select * from t1, t2 where t1.a1 = t2.a2;