[CALCITE-1897] Support operator "%" as an alternative to "mod"

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Fix Version/s: 1.14.0
• Component/s: core
• Assignee: sunjincheng
• Reporter: sunjincheng
• Created: 21/Jul/17 02:52
• Updated: 02/Oct/17 14:31
• Resolved: 21/Aug/17 19:02

Description

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

Issue Links

• relates to: CALCITE-1908 Mod function got exception in MOD(34.5,3), MOD(19,6.7) situation.
• relates to: CALCITE-1924 Support operator "+" as string concat operator(enabled in MSSQL library)