[SPARK-29926] interval `1. second` should be invalid as PostgreSQL

• Type: Sub-task
• Status: Resolved
• Priority: Minor
• 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: 16/Nov/19 10:20
• Updated: 29/Dec/19 05:25
• Resolved: 19/Nov/19 13:12

Description

Spark

-- !query 134
select interval '1. second'
-- !query 134 schema
struct<1 seconds:interval>
-- !query 134 output
1 seconds


-- !query 135
select cast('1. second' as interval)
-- !query 135 schema
struct<CAST(1. second AS INTERVAL):interval>
-- !query 135 output
1 seconds

PostgreSQL

ostgres=# select interval '1. seconds';
ERROR:  invalid input syntax for type interval: "1. seconds"
LINE 1: select interval '1. seconds';

Issue Links

• links to: GitHub Pull Request #26573