Details
-
Bug
-
Status: Open
-
Major
-
Resolution: Unresolved
-
None
-
None
-
None
Description
When a join predicate contains a function, the evaluation result of the join predicate is invalid like below.
tpch> select char_length(l_shipdate) from lineitem; ?char_length ------------------------------- 10 10 10 ... tpch> select char_length(o_orderdate) from orders; ?char_length ------------------------------- 10 10 10 ... tpch> select l_linenumber from lineitem, orders where char_length(l_shipdate) + 1 = char_length(o_orderdate) + 1; l_linenumber -------------------------------