[
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)
