You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@calcite.apache.org by "Mihai Budiu (Jira)" <ji...@apache.org> on 2024/12/11 17:20:00 UTC

[jira] [Resolved] (CALCITE-6726) Add translation for MOD operator in MSSQL

     [ https://issues.apache.org/jira/browse/CALCITE-6726?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Mihai Budiu resolved CALCITE-6726.
----------------------------------
    Fix Version/s: 1.39.0
       Resolution: Fixed

Fixed in https://github.com/apache/calcite/commit/041619f6ea3b2c190ae45cd435c6442f5c54cf40
Thank you for the contribution, [~sreeharsha_r]

> Add translation for MOD operator in MSSQL
> -----------------------------------------
>
>                 Key: CALCITE-6726
>                 URL: https://issues.apache.org/jira/browse/CALCITE-6726
>             Project: Calcite
>          Issue Type: Bug
>            Reporter: Sree Harsha Ramanavarapu
>            Assignee: Sree Harsha Ramanavarapu
>            Priority: Major
>              Labels: pull-request-available
>             Fix For: 1.39.0
>
>
> select mod(11,3)
> 'mod' is not a recognized built-in function name.
>  
> MSSQL doesn't support the MOD keyword. This should be re-written to % (PERCENT_REMAINDER) binary operator.



--
This message was sent by Atlassian Jira
(v8.20.10#820010)