[
https://issues.apache.org/jira/browse/CALCITE-1897?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16112078#comment-16112078
]
sunjincheng commented on CALCITE-1897:
--------------------------------------
Hi [~julianhyde], I have opened the PR.
https://github.com/apache/calcite/pull/506
In the PR. I have added `%` operator named `REMAINDER`, I'm not sure whether
the name is make sense to you or not. I appreciated if you can review the PR.
Best, Jincheng
> Support operator "%" as an alternative to "mod"
> -----------------------------------------------
>
> Key: CALCITE-1897
> URL: https://issues.apache.org/jira/browse/CALCITE-1897
> Project: Calcite
> Issue Type: Bug
> Components: core
> Reporter: sunjincheng
> Assignee: sunjincheng
>
> Currently the following sql is not supported.
> SELECT a%3 FROM T
> We get the exception:
>
> Caused by: org.apache.calcite.sql.parser.SqlParseException: Lexical
> error at line 1, column 9. Encountered: "%" (37), after : ""
> at
> org.apache.calcite.sql.parser.impl.SqlParserImpl.convertException(SqlParserImpl.java:396)
> at
> org.apache.calcite.sql.parser.impl.SqlParserImpl.normalizeException(SqlParserImpl.java:129)
> In this JIRA. I'll fix this by support operator "%" as an alternative to
> "mod".
> Similar https://issues.apache.org/jira/browse/CALCITE-1374
--
This message was sent by Atlassian JIRA
(v6.4.14#64029)