Uploaded image for project: 'Calcite'
  1. Calcite
  2. CALCITE-1897

Support operator "%" as an alternative to "mod"

VotersWatch issueWatchersLinkCloneUpdate Comment AuthorReplace String in CommentUpdate Comment VisibilityDelete Comments
    XMLWordPrintableJSON

Details

    • Bug
    • Status: Closed
    • Major
    • Resolution: Fixed
    • None
    • 1.14.0
    • core
    • None

    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

        Activity

          This comment will be Viewable by All Users Viewable by All Users
          Cancel

          People

            sunjincheng121 sunjincheng
            sunjincheng121 sunjincheng
            Votes:
            0 Vote for this issue
            Watchers:
            4 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved:

              Slack

                Issue deployment