[
https://issues.apache.org/jira/browse/IMPALA-5839?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16572366#comment-16572366
]
ASF subversion and git services commented on IMPALA-5839:
---------------------------------------------------------
Commit 22f167f542edb6a73e4c4e5350e788f6bf2683cb in impala's branch
refs/heads/master from [~arodoni_cloudera]
[ https://git-wip-us.apache.org/repos/asf?p=impala.git;h=22f167f ]
IMPALA-5839: [DOCS] Corrected the return types for NULLIFZERO and NULLIFZERO
Change-Id: Ia7927a5caf1d200a1f4d04d3729c29391c7f43cd
Reviewed-on: http://gerrit.cloudera.org:8080/11024
Reviewed-by: Impala Public Jenkins <[email protected]>
Tested-by: Impala Public Jenkins <[email protected]>
> nullifzero and zeroifnull documentation about return type doesn't match
> implementation
> --------------------------------------------------------------------------------------
>
> Key: IMPALA-5839
> URL: https://issues.apache.org/jira/browse/IMPALA-5839
> Project: IMPALA
> Issue Type: Bug
> Components: Docs
> Reporter: Philip Zeyliger
> Assignee: Alex Rodoni
> Priority: Major
> Fix For: Impala 3.1.0
>
>
> https://impala.incubator.apache.org/docs/build/html/topics/impala_conditional_functions.html
> mentions return types of {{nullifzero}} and {{zeroifnull}}:
> {quote}
> nullifzero(numeric_expr)
> Return type: same as the initial argument value, except that integer values
> are promoted to BIGINT and floating-point values are promoted to DOUBLE; use
> CAST() when inserting into a smaller numeric column
> zeroifnull(numeric_expr)
> Return type: same as the initial argument value, except that integer values
> are promoted to BIGINT and floating-point values are promoted to DOUBLE; use
> CAST() when inserting into a smaller numeric column
> {quote}
> However, I see it returning the underlying type without promotion.
> {code}
> [...:21000] > select typeof(nullifzero(1)), typeof(zeroifnull(cast(1 as
> integer)));
> ...
> +-----------------------+------------------------------------+
> | typeof(nullifzero(1)) | typeof(zeroifnull(cast(1 as int))) |
> +-----------------------+------------------------------------+
> | TINYINT | INT |
> +-----------------------+------------------------------------+
> Fetched 1 row(s) in 0.02s
> {code}
> I suspect the docs are wrong here.
--
This message was sent by Atlassian JIRA
(v7.6.3#76005)
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
