[CALCITE-4555] Invalid zero literal value is used for TIMESTAMP WITH LOCAL TIME ZONE type in RexBuilder

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Fix Version/s: 1.35.0
• Labels: pull-request-available
• Assignee: Sergey Nuyanzin
• Reporter: Leonard Xu
• Created: 27/Mar/21 08:27
• Updated: 27/Jul/23 10:22
• Resolved: 03/Jun/23 09:07

Description

The zero literal value for TIMESTAMP WITH LOCAL TIME ZONE type is used in `org.apache.calcite.rex.RexBuilder`

    case TIMESTAMP_WITH_LOCAL_TIME_ZONE:
      return new TimestampString(0, 0, 0, 0, 0, 0);
   //TimestampString(int year, int month, int day, int h, int m, int s)

the month and day should never be zero, I think the zero value should be '1970-01-01 00:00:00'(epoch 0 second).

Issue Links

• is related to: CALCITE-1947 Add time/timestamp with local time zone types to optimizer
• links to: GitHub Pull Request #3208
• links to: PR#3208