[SPARK-29840] PostgreSQL dialect: cast to integer

• Type: Sub-task
• Status: Open
• Priority: Major
• Resolution: Unresolved
• Affects Version/s: 3.1.0
• Component/s: SQL
• Assignee: Unassigned
• Reporter: jobit mathew
• Created: 11/Nov/19 11:55
• Updated: 29/Mar/20 02:06

Description

Make SparkSQL's cast to integer behavior be consistent with PostgreSQL when

spark.sql.dialect is configured as PostgreSQL.

Example:currently spark sql

spark-sql> select   CAST ('10C' AS INTEGER);
NULL
Time taken: 0.051 seconds, Fetched 1 row(s)
spark-sql>

postgresql

postgresql
select   CAST ('10C' AS INTEGER);
Error(s), warning(s):

22P02: invalid input syntax for integer: "10C"

Issue Links

• links to: GitHub Pull Request #26481