[jira] [Created] (SPARK-30026) Support all whitespaces as delimiter for inside a interval value

["Kent Yao (Jira)" <ji...@apache.org>]

Kent Yao created SPARK-30026:
--------------------------------

             Summary: Support all whitespaces as delimiter for inside a interval value
                 Key: SPARK-30026
                 URL: https://issues.apache.org/jira/browse/SPARK-30026
             Project: Spark
          Issue Type: Sub-task
          Components: SQL
    Affects Versions: 3.0.0
            Reporter: Kent Yao


 
{code:sql}
 
postgres=# select interval E'1 \t day';
 interval
----------
 1 day
(1 row)

postgres=# select interval E'1\t' day;
 interval
----------
 1 day
(1 row)

postgres=# select interval '1 ' day;
 interval
----------
 1 day
(1 row)
{code}
 
We are now able to handle whitespaces for integral and fractional types, and the leading or trailing whitespaces for interval, date, and timestamps. But the current interval parser is not able to identify whitespaces as separates as PostgreSQL can do 



--
This message was sent by Atlassian Jira
(v8.3.4#803005)

---------------------------------------------------------------------
To unsubscribe, e-mail: issues-unsubscribe@spark.apache.org
For additional commands, e-mail: issues-help@spark.apache.org