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
Attachments
Issue Links
- relates to
-
CALCITE-1908 Mod function got exception in MOD(34.5,3), MOD(19,6.7) situation.
-
- Open
-
-
CALCITE-1924 Support operator "+" as string concat operator(enabled in MSSQL library)
-
- Open
-