[SPARK-27923] List all cases that PostgreSQL throws an exception but Spark SQL is NULL

• Type: Sub-task
• Status: Open
• Priority: Major
• Resolution: Unresolved
• Affects Version/s: 3.1.0
• Component/s: SQL
• Assignee: Unassigned
• Reporter: Yuming Wang
• Created: 03/Jun/19 08:03
• Updated: 29/Mar/20 02:31

Description

In this ticket, we plan to list all cases that PostgreSQL throws an exception but Spark SQL is NULL.

When porting the boolean.sql found a case:

1. Cast unaccepted value to boolean type throws invalid input syntax.

When porting the case.sql found a case:

1. Division by zero throws an exception.

When porting the date.sql found a case:

1. Invalid date throws an exception.

When porting the int2.sql found a case:

1. Invalid short throws an exception.

When porting the float4.sql found three case:

1. Bad input throws an exception.
2. Bad special inputs throws an exception.
3. Divide by zero throws an exception.

When porting the float8.sql found five case:

1. Bad input throws an exception.
2. Bad special inputs throws an exception.
3. Cannot take logarithm of zero throws an exception.
4. Cannot take logarithm of a negative number throws an exception.
5. Divide by zero throws an exception.

When porting the numeric.sql found six case:

1. Invalid decimal throws an exception.
2. decimal type can not accept Infinity and -Infinity.
3. Invalid inputs throws an exception.
4. Invalid inputs throws an exception.
5. Invalid inputs throws an exception.
6. Invalid inputs throws an exception.