[
https://issues.apache.org/jira/browse/PHOENIX-3479?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15709492#comment-15709492
]
Kevin Liew commented on PHOENIX-3479:
-------------------------------------
I was thinking that if other databases commonly supported it, there might be
applications that rely on it. However I did some manual tests on Postgres and
MySQL. MySQL will perform modulus on double columns but the return type is
unspecified in their docs. Postgres does not support modulus on double despite
their docs at https://www.postgresql.org/docs/9.6/static/functions-math.html
{noformat}
The bitwise operators work only on integral data types, whereas the others are
available for all numeric data types.
{noformat}
I will remove DoubleModulusExpression and work on test coverage for
DecimalModulusExpression.
> Modulo support for non integer-types
> ------------------------------------
>
> Key: PHOENIX-3479
> URL: https://issues.apache.org/jira/browse/PHOENIX-3479
> Project: Phoenix
> Issue Type: Bug
> Affects Versions: 4.8.0
> Reporter: Kevin Liew
> Assignee: Kevin Liew
> Priority: Minor
> Attachments: PHOENIX-3479.2.patch, PHOENIX-3479.3.patch,
> PHOENIX-3479.patch
>
>
> MOD should be applicable to all numeric types
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
