[jira] [Commented] (TAJO-182) Comparison of primitive values including null value should return NULL.

["Prafulla T (JIRA)" <ji...@apache.org>]

    [ https://issues.apache.org/jira/browse/TAJO-182?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13852000#comment-13852000 ] 

Prafulla T commented on TAJO-182:
---------------------------------

Thanks, I am taking a look at this one.
Does anyone know how to specify literal NULL in query?
Following did not work.

tajo> select id > NULL from table1;
ERROR: syntax error at or near 'NULL'
LINE 1:12 select id > NULL from table1
                                   ^^^^

PS: ^^^^ is below NULL, Jira formatting is putting it at the beginning

> Comparison of primitive values including null value should return NULL.
> -----------------------------------------------------------------------
>
>                 Key: TAJO-182
>                 URL: https://issues.apache.org/jira/browse/TAJO-182
>             Project: Tajo
>          Issue Type: Bug
>          Components: planner/optimizer
>            Reporter: Hyunsik Choi
>            Priority: Critical
>             Fix For: 0.8-incubating
>
>
> -If some domain value is compared to Null value, the current implementation will cause InvalidOperationException. Such cases should result in 'false'.-
> If some domain value is compared to Null value, the current implementation will cause either InvalidOperationException or FALSE. Such cases should result in NULL.



--
This message was sent by Atlassian JIRA
(v6.1.4#6159)