[CALCITE-1884] DateTimeUtils produces incorrect results for days before Gregorian cutovers

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 1.13.0
• Fix Version/s: avatica-1.12.0
• Component/s: avatica
• Assignee: Haohui Mai
• Reporter: Haohui Mai
• Created: 12/Jul/17 00:13
• Updated: 01/Mar/23 19:17
• Resolved: 01/Jun/18 22:56

Description

dateStringToUnixDate() / unixDateToString() do not return consistent result.

The following test fails:

  @Test public void testUnixDate() {
    int days = DateTimeUtils.dateStringToUnixDate("1500-04-30");
    assertEquals("1500-04-30", DateTimeUtils.unixDateToString(days));
  }

Issue Links

• blocks: FLINK-6429 Bump up Calcite version to 1.13
• is depended upon by: CALCITE-2330 Release Avatica 1.12
• is related to: CALCITE-1832 DateTimeUtils dateString to Unix translation error
• is related to: CALCITE-2182 Release Avatica 1.11
• relates to: CALCITE-2989 Use ISO-8601 calendar when converting between java.sql types and UNIX timestamps
• links to: GitHub Pull Request #11
• links to: GitHub Pull Request #52