[CALCITE-6030] DATE_PART is not handled by the RexToLixTranslator

• Type: Bug
• Status: Closed
• Priority: Minor
• Resolution: Fixed
• Affects Version/s: 1.35.0
• Fix Version/s: 1.36.0
• Component/s: core
• Labels: pull-request-available
• Assignee: Mihai Budiu
• Reporter: Mihai Budiu
• Created: 27/Sep/23 23:12
• Updated: 10/Nov/23 11:34
• Resolved: 20/Oct/23 03:49

Description

The following test, when added to SqlOperatorTest, causes a RuntimeException:

@Test void testDatePart() {
    final SqlOperatorFixture f = fixture().withLibrary(SqlLibrary.POSTGRESQL)
        .withParserConfig(p -> p.withParserFactory(SqlBabelParserImpl.FACTORY));
    f.checkScalar("DATE_PART(second, TIME '10:10:10')",
        "10", "BIGINT NOT NULL");
  }

Note that this needs https://github.com/apache/calcite/pull/3445 to execute correctly.

The stack trace is:

Suppressed: java.lang.RuntimeException: cannot translate call DATE_PART($t1, $t2)
		at org.apache.calcite.adapter.enumerable.RexToLixTranslator.visitCall(RexToLixTranslator.java:1160)
		at org.apache.calcite.adapter.enumerable.RexToLixTranslator.visitCall(RexToLixTranslator.java:101)
		at org.apache.calcite.rex.RexCall.accept(RexCall.java:189)

According to the documentation DATE_PART is just an alias for EXTRACT, which is (mostly) implemented, so this should work.

Issue Links

• links to: GitHub Pull Request #3446