[CALCITE-2843] Babel parser should parse PostgreSQL-style '::' cast operator

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 1.18.0
• Fix Version/s: 1.21.0
• Component/s: babel
• Labels: postgresql pull-request-available
• Assignee: Mohamed Mohsen
• Reporter: Mohamed Mohsen
• Created: 12/Feb/19 15:04
• Updated: 19/Jan/22 12:27
• Resolved: 09/Aug/19 20:48

Description

Code to reproduce the problem

public static void main(String[] args) throws Exception {
    Config parserConfig = configBuilder().setConformance(SqlConformanceEnum.BABEL).setParserFactory(SqlBabelParserImpl.FACTORY).build();
    FrameworkConfig frameworkConfig = Frameworks.newConfigBuilder().parserConfig(parserConfig).build();

    Planner planner = Frameworks.getPlanner(frameworkConfig);
    String pg = "SELECT 'array_in'::regproc, typtype FROM pg_catalog.pg_type";
    planner.parse(pg);
}

 

Thrown exception

Exception in thread "main" org.apache.calcite.sql.parser.SqlParseException: Encountered ":" at line 1, column 18.
Was expecting one of:
    <EOF> 
    "ORDER" ...
    "LIMIT" ...
    "OFFSET" ...
    "FETCH" ...
    "FROM" ...
    "," ...
    <IDENTIFIER> ...
    <QUOTED_IDENTIFIER> ...
    <BACK_QUOTED_IDENTIFIER> ...
    <BRACKET_QUOTED_IDENTIFIER> ...
    <UNICODE_QUOTED_IDENTIFIER> ...
    <QUOTED_STRING> ...
    "." ...
    "IN" ...
    "<" ...
    "<=" ...
    ">" ...
    ">=" ...
    "=" ...
    "<>" ...
    "!=" ...
    "+" ...
    "-" ...
    "*" ...
    "/" ...
    "%" ...
    "||" ...
    "[" ...
    "UNION" ...
    "INTERSECT" ...
    "EXCEPT" ...
    "MINUS" ...
    
	at org.apache.calcite.sql.parser.babel.SqlBabelParserImpl.convertException(SqlBabelParserImpl.java:354)
	at org.apache.calcite.sql.parser.babel.SqlBabelParserImpl.normalizeException(SqlBabelParserImpl.java:142)
	at org.apache.calcite.sql.parser.SqlParser.parseQuery(SqlParser.java:156)
	at org.apache.calcite.sql.parser.SqlParser.parseStmt(SqlParser.java:181)
	at org.apache.calcite.prepare.PlannerImpl.parse(PlannerImpl.java:174)
	at org.apache.calcite.tools.Planner.parse(Planner.java:50)
	at com.lab.calcite.App2.main(App2.java:23)
Caused by: org.apache.calcite.sql.parser.babel.ParseException: Encountered ":" at line 1, column 18.
Was expecting one of:
    <EOF> 
    "ORDER" ...
    "LIMIT" ...
    "OFFSET" ...
    "FETCH" ...
    "FROM" ...
    "," ...
    <IDENTIFIER> ...
    <QUOTED_IDENTIFIER> ...
    <BACK_QUOTED_IDENTIFIER> ...
    <BRACKET_QUOTED_IDENTIFIER> ...
    <UNICODE_QUOTED_IDENTIFIER> ...
    <QUOTED_STRING> ...
    "." ...
    "IN" ...
    "<" ...
    "<=" ...
    ">" ...
    ">=" ...
    "=" ...
    "<>" ...
    "!=" ...
    "+" ...
    "-" ...
    "*" ...
    "/" ...
    "%" ...
    "||" ...
    "[" ...
    "UNION" ...
    "INTERSECT" ...
    "EXCEPT" ...
    "MINUS" ...
    
	at org.apache.calcite.sql.parser.babel.SqlBabelParserImpl.generateParseException(SqlBabelParserImpl.java:31191)
	at org.apache.calcite.sql.parser.babel.SqlBabelParserImpl.jj_consume_token(SqlBabelParserImpl.java:31008)
	at org.apache.calcite.sql.parser.babel.SqlBabelParserImpl.SqlStmtEof(SqlBabelParserImpl.java:877)
	at org.apache.calcite.sql.parser.babel.SqlBabelParserImpl.parseSqlStmtEof(SqlBabelParserImpl.java:198)
	at org.apache.calcite.sql.parser.SqlParser.parseQuery(SqlParser.java:148)
	... 4 more

Issue Links

• duplicates: CALCITE-1432 Add support for double colon cast e.g. '1'::INTEGER
• links to: GitHub Pull Request #1066