[CALCITE-4980] Babel parser support MySQL NULL-safe equal operator '<=>'

• Type: New Feature
• Status: Closed
• Priority: Major
• Resolution: Resolved
• Fix Version/s: 1.30.0
• Component/s: babel, core
• Labels: pull-request-available
• Assignee: Xurenhe
• Reporter: Xurenhe
• Created: 10/Jan/22 08:18
• Updated: 19/Mar/22 09:17
• Resolved: 25/Jan/22 13:02

Description

Babel parser support MySQL equal operator '<=>'.

Mysql link: https://dev.mysql.com/doc/refman/8.0/en/comparison-operators.html#operator_equal-to

 

// test case
@Test void testParseEqual()  {
  final String sql = "select '1' <=> '2' from t";
  final String expected = ""
      + "SELECT 1' <=> '2'\n"
      + "FROM `T`";
  sql(sql).ok(expected);
} 

// exception stack
    java.lang.RuntimeException: Error while parsing SQL: select '1' <=> '2' from t
        at org.apache.calcite.sql.parser.SqlParserTest$TesterImpl.parseStmtAndHandleEx(SqlParserTest.java:9704)
        at org.apache.calcite.sql.parser.SqlParserTest$TesterImpl.check(SqlParserTest.java:9690)
        at org.apache.calcite.sql.parser.SqlParserTest$Sql.ok(SqlParserTest.java:10047)
        at org.apache.calcite.test.BabelParserTest.testParseEqual(BabelParserTest.java:246)
        Caused by: java.lang.RuntimeException: org.apache.calcite.sql.parser.SqlParseException: Encountered "<= >" at line 1, column 12.
        Was expecting one of: 

 

Issue Links

• links to: GitHub Pull Request #2692
• links to: PR