Uploaded image for project: 'Spark'
  1. Spark
  2. SPARK-27764 Feature Parity between PostgreSQL and Spark
  3. SPARK-30026

Support all whitespaces as delimiter for inside a interval value

    XMLWordPrintableJSON

Details

    • Sub-task
    • Status: Resolved
    • Major
    • Resolution: Fixed
    • 3.0.0
    • 3.0.0
    • SQL
    • None

    Description

       

       
      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)
      

       
      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

      Attachments

        Issue Links

          Activity

            People

              Qin Yao Kent Yao 2
              Qin Yao Kent Yao 2
              Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved: