[
https://issues.apache.org/jira/browse/HIVE-16479?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15975380#comment-15975380
]
Remus Rusanu commented on HIVE-16479:
-------------------------------------
Standard says {{<join condition>}} syntax is {{::ON <search condition>}} (SQL99
pg. 238) and {{<search condition>}} is the same as {{<boolean value
expression>}} (SQL99 pg. 322). I guess {{NULL}} does satisfy the criteria,
since is a valid value for a boolean. I think the NULL condition should not
match any rows.
> Non boolean join condition results in runtime error
> ---------------------------------------------------
>
> Key: HIVE-16479
> URL: https://issues.apache.org/jira/browse/HIVE-16479
> Project: Hive
> Issue Type: Bug
> Reporter: Remus Rusanu
> Assignee: Remus Rusanu
>
> Should be captured at compile-time
--
This message was sent by Atlassian JIRA
(v6.3.15#6346)
