[SPARK-28060] Float/Double type can not accept some special inputs

• Type: Sub-task
• Status: Resolved
• Priority: Major
• Resolution: Duplicate
• Affects Version/s: 3.0.0
• Component/s: SQL
• Assignee: Unassigned
• Reporter: Yuming Wang
• Created: 15/Jun/19 03:34
• Updated: 23/Jun/19 03:31
• Resolved: 23/Jun/19 03:31

Description

Query	Spark SQL	PostgreSQL
SELECT float('nan');	NULL	NaN
SELECT float('   NAN  ');	NULL	NaN
SELECT float('infinity');	NULL	Infinity
SELECT float('          -INFINiTY   ');	NULL	-Infinity

Query	Spark SQL	PostgreSQL
SELECT double('nan');	NULL	NaN
SELECT double('   NAN  ');	NULL	NaN
SELECT double('infinity');	NULL	Infinity
SELECT double('          -INFINiTY   ');	NULL	-Infinity

Issue Links

• duplicates: SPARK-27768 Infinity, -Infinity, NaN should be recognized in a case insensitive manner