hive-issues mailing list archives

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


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:
POSTHOOK: query: select 'NaN' < 2.0 from src limit 1
POSTHOOK: query: select 1.0 < 'NaN' from src limit 1

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:
>             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

View raw message