[
https://issues.apache.org/jira/browse/PHOENIX-2048?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16090022#comment-16090022
]
Julian Hyde commented on PHOENIX-2048:
--------------------------------------
I don't think you need it to be configurable. If you ask 10 people what is the
least surprising behavior, they'd all say either "I don't care" or "do the same
as oracle". It's probably not documented in oracle, but do some experiments.
> change to_char() function to use HALF_UP rounding mode
> ------------------------------------------------------
>
> Key: PHOENIX-2048
> URL: https://issues.apache.org/jira/browse/PHOENIX-2048
> Project: Phoenix
> Issue Type: Improvement
> Affects Versions: verify
> Reporter: Jonathan Leech
> Priority: Minor
> Fix For: 4.12.0
>
> Attachments: phoenix-2048.patch
>
>
> to_char() function uses the default rounding mode in java DecimalFormat,
> which is a strange one called HALF_EVEN, which rounds a '5' in the last
> position either up or down depending on the preceding digit.
> Change it to HALF_UP so it rounds the same way as the round() function does,
> or provide a way to override the behavior; e.g. globally or as a client
> config, or an argument to the to_char() function.
--
This message was sent by Atlassian JIRA
(v6.4.14#64029)
