hive-issues mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Sergey Shelukhin (JIRA)" <j...@apache.org>
Subject [jira] [Commented] (HIVE-14189) backport HIVE-13945 to branch-1
Date Thu, 17 Nov 2016 02:54:58 GMT

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

Sergey Shelukhin commented on HIVE-14189:
-----------------------------------------

[~cartershanklin] [~jcamachorodriguez] [~ashutoshc] do you have access to the text of a later
SQL standard than 99? That one is pretty vague.
Seems like there's implicit cast to string in these cases on master:
{noformat}
POSTHOOK: query: select 'NaN' < 2.0 from src limit 1
false
POSTHOOK: query: select 1.0 < 'NaN' from src limit 1
true
{noformat}

branch-1 with this patch returns null by happenstance (because something else inserts a cast
to decimal from string), so the operation returns null.
I wonder if SQL standard has anything to say on this... 99 doesn't seem to.

> backport HIVE-13945 to branch-1
> -------------------------------
>
>                 Key: HIVE-14189
>                 URL: https://issues.apache.org/jira/browse/HIVE-14189
>             Project: Hive
>          Issue Type: Bug
>            Reporter: Sergey Shelukhin
>            Assignee: Sergey Shelukhin
>              Labels: TODOC1.3
>         Attachments: HIVE-14189-branch-1.patch, HIVE-14189.01-branch-1.patch, HIVE-14189.02-branch-1.patch,
HIVE-14189.03-branch-1.patch, HIVE-14189.04-branch-1.patch, HIVE-14189.05-branch-1.patch,
HIVE-14189.06-branch-1.patch, HIVE-14189.07-branch-1.patch, HIVE-14189.08-branch-1.patch
>
>




--
This message was sent by Atlassian JIRA
(v6.3.4#6332)

Mime
View raw message