[
https://issues.apache.org/jira/browse/CALCITE-1007?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15045407#comment-15045407
]
Laljo John Pullokkaran commented on CALCITE-1007:
-------------------------------------------------
No I believe this is independent of "on clause" type safety.
So this should apply for any user of calcite that invokes transitive inference.
BTW, Hive does make sure that al of the comparisons are casted correctly so
that they are type safe.
> Transitive Inference on Join Condition is not type safe
> -------------------------------------------------------
>
> Key: CALCITE-1007
> URL: https://issues.apache.org/jira/browse/CALCITE-1007
> Project: Calcite
> Issue Type: Bug
> Components: core
> Affects Versions: 1.5.0
> Reporter: Laljo John Pullokkaran
> Assignee: Laljo John Pullokkaran
>
> select * from (select 1 as x from t1) t1 join (select stroll as x from t2)t2
> join t1.x=t2.x;
> While transferring x=1 from t1 to t2, we don't use the correct type for 'x'
> on t2.
> This could result in data correctness.
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
