[SPARK-31402] Incorrect rebasing of BCE dates

• Type: Sub-task
• Status: Resolved
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 3.0.0
• Fix Version/s: 3.0.0
• Component/s: SQL
• Assignee: Max Gekk
• Reporter: Max Gekk
• Created: 09/Apr/20 20:18
• Updated: 14/Apr/20 08:07
• Resolved: 13/Apr/20 06:18

Description

Dates of before common era are rebased incorrectly, see https://amplab.cs.berkeley.edu/jenkins/job/SparkPullRequestBuilder/120679/testReport/org.apache.spark.sql/SQLQueryTestSuite/sql/

sbt.ForkMain$ForkError: org.scalatest.exceptions.TestFailedException: postgreSQL/date.sql
Expected "[-0044]-03-15", but got "[0045]-03-15" Result did not match for query #93
select make_date(-44, 3, 15)

Even such dates are out of the valid range of dates supported by the DATE type, there is a test in postgreSQL/date.sql for a negative year, and it would be nice to fix the issue.

Issue Links

• links to: GitHub Pull Request #28172
• links to: GitHub Pull Request #28199