Toni Mueller created CALCITE-4751: ------------------------------------- Summary: SqlParserImpl.FACTORY does not support infix cast operator ('10'::INT) Key: CALCITE-4751 URL: https://issues.apache.org/jira/browse/CALCITE-4751 Project: Calcite Issue Type: Bug Reporter: Toni Mueller
Since I'm struggling with [CALCITE-4746|https://issues.apache.org/jira/browse/CALCITE-4746] I tried to use the SqlBabelParserImpl.FACTORY instead. Which works fine but then I found another problem. It seems that there is no support for the Postgres Infix Cast operator in this ParserImplementation? So trying to run: {code:java} SqlParser.Config c = SqlParser.config() .withParserFactory(SqlParserImpl.FACTORY); SqlParser parser = SqlParser.create("SELECT bar::INT FROM foo", c); parser.parseQuery(); {code} gives {code:java} org.apache.calcite.sql.parser.SqlParseException: Encountered ":" at line 1, column 13. Was expecting one of: <EOF> "AS" ... "EXCEPT" ... "FETCH" ... "FROM" ... "INTERSECT" ... "LIMIT" ... "OFFSET" ... "ORDER" ... "MINUS" ... "UNION" ... <QUOTED_STRING> ... "," ... <BRACKET_QUOTED_IDENTIFIER> ... <QUOTED_IDENTIFIER> ... <BACK_QUOTED_IDENTIFIER> ... <HYPHENATED_IDENTIFIER> ... <IDENTIFIER> ... <UNICODE_QUOTED_IDENTIFIER> ... "." ... "NOT" ... "IN" ... "<" ... "<=" ... ">" ... ">=" ... "=" ... "<>" ... "!=" ... "BETWEEN" ... "LIKE" ... "SIMILAR" ... "+" ... "-" ... "*" ... "/" ... "%" ... "||" ... "AND" ... "OR" ... "IS" ... "MEMBER" ... "SUBMULTISET" ... "CONTAINS" ... "OVERLAPS" ... "EQUALS" ... "PRECEDES" ... "SUCCEEDS" ... "MULTISET" ... "[" ... "(" ... {code} Is this intentional or is this a bug? -- This message was sent by Atlassian Jira (v8.3.4#803005)