[SPARK-26653] Use Proleptic Gregorian calendar in parsing JDBC lower/upper bounds

• Type: Sub-task
• Status: Resolved
• Priority: Minor
• Resolution: Fixed
• Affects Version/s: 2.4.0
• Fix Version/s: 3.0.0
• Component/s: SQL
• Assignee: Maxim Gekk
• Reporter: Maxim Gekk
• Created: 17/Jan/19 21:00
• Updated: 23/Jan/19 12:24
• Resolved: 23/Jan/19 12:24

Description

JDBCRelation should use java.time classes to convert textual representation of TimestampType and DateType to bound values. In particular, the method should be re-implemented:
https://github.com/apache/spark/blob/115fecfd840d58ce3211bf1dd7b130cb862730a5/sql/core/src/main/scala/org/apache/spark/sql/execution/datasources/jdbc/JDBCRelation.scala#L177-L181
Ideally the method should be able to support at least the same patterns as Cast expression.

Issue Links

• links to: GitHub Pull Request #23597