[
https://issues.apache.org/jira/browse/CALCITE-3435?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16962925#comment-16962925
]
Danny Chen edited comment on CALCITE-3435 at 10/30/19 10:58 AM:
----------------------------------------------------------------
I have tested MySQL 5.6, PostgreSQL 9.6 and MS-SQL 2017, for query:
{code:sql}
select mod(12.34, 3) from t; -- select 12.34 % 3 from t; for MS-SQL
{code}
They all returns 0.34, i'm inclined to keep sync with them.
was (Author: danny0405):
I have tested MySQL 5.6, PostgreSQL 9.6 and MS-SQL 2017, for query:
{code:sql}
select mod(12.34, 3) from t; -- select 12.34 % 3 from t; for MY-SQL
{code}
They all returns 0.34, i'm inclined to keep sync with them.
> floor(mod(33.5,7)) wrongly returns 5.5
> --------------------------------------
>
> Key: CALCITE-3435
> URL: https://issues.apache.org/jira/browse/CALCITE-3435
> Project: Calcite
> Issue Type: Bug
> Affects Versions: 1.16.0, 1.21.0
> Reporter: jiezouSH
> Assignee: Feng Zhu
> Priority: Minor
>
> mod's return type is
> chain(DECIMAL_MOD_NULLABLE, ARG1_NULLABLE),
> but mod(33.5,7)'s result is 5.5, not in line with ARG1_NULLABLE.
> This causes floor(mod(33.5,7)) wrongly returns 5.5
--
This message was sent by Atlassian Jira
(v8.3.4#803005)
