[SPARK-29855] typed literals with negative sign with proper result or exception

• Type: Improvement
• 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: 12/Nov/19 05:47
• Updated: 12/Dec/22 18:11
• Resolved: 12/Nov/19 14:53

Description

-- !query 83
select -integer '7'
-- !query 83 schema
struct<7:int>
-- !query 83 output
7

-- !query 86
select -date '1999-01-01'
-- !query 86 schema
struct<DATE '1999-01-01':date>
-- !query 86 output
1999-01-01

-- !query 87
select -timestamp '1999-01-01'
-- !query 87 schema
struct<TIMESTAMP('1999-01-01 00:00:00'):timestamp>
-- !query 87 output
1999-01-01 00:00:00

the integer should be -7 and the date and timestamp results are confusing which should throw exception.

Issue Links

• is related to: SPARK-29408 Support interval literal with negative sign `-`
• links to: GitHub Pull Request #26479