[SPARK-30189] Interval from year-month/date-time string handling whitespaces

• 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: Kent Yao 2
• Reporter: Kent Yao 2
• Created: 09/Dec/19 12:37
• Updated: 10/Mar/20 14:34
• Resolved: 10/Mar/20 14:34

Description

1. for pg feature parity
2. for consistency with other types and other interval parser

 

ostgres=# select interval E'2-2\t' year to month;
    interval
----------------
 2 years 2 mons
(1 row)

postgres=# select interval E'2-2\t' year to month;
    interval
----------------
 2 years 2 mons
(1 row)

postgres=# select interval E'2-\t2\t' year to month;
ERROR:  invalid input syntax for type interval: "2-	2	"
LINE 1: select interval E'2-\t2\t' year to month;
                        ^
postgres=# select interval '2  00:00:01' day to second;
    interval
-----------------
 2 days 00:00:01
(1 row)

postgres=# select interval '- 2  00:00:01' day to second;
     interval
-------------------
 -2 days +00:00:01
(1 row)

Issue Links

• links to: GitHub Pull Request #26815