[ 
https://issues.apache.org/jira/browse/SPARK-27923?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
 ]

Yuming Wang updated SPARK-27923:
--------------------------------
    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|https://github.com/postgres/postgres/blob/REL_12_BETA1/src/test/regress/sql/boolean.sql]
 found a case:
# Cast unaccepted value to boolean type throws [invalid input 
syntax|https://github.com/postgres/postgres/blob/REL_12_BETA1/src/test/regress/expected/boolean.out#L45-L47].

When porting the 
[case.sql|https://github.com/postgres/postgres/blob/REL_12_BETA1/src/test/regress/sql/case.sql]
 found a case:
 # Division by zero [throws an 
exception|https://github.com/postgres/postgres/blob/REL_12_BETA1/src/test/regress/expected/case.out#L96-L99].

When porting the 
[date.sql|https://github.com/postgres/postgres/blob/REL_12_BETA1/src/test/regress/sql/date.sql]
 found a case:
 # Invalid date [throws an 
exception|https://github.com/postgres/postgres/blob/REL_12_BETA1/src/test/regress/expected/date.out#L13-L14].

When porting the 
[int2.sql|https://github.com/postgres/postgres/blob/REL_12_BETA1/src/test/regress/sql/int2.sql]
 found a case:
 # Invalid short [throws an 
exception|https://github.com/postgres/postgres/blob/REL_12_BETA1/src/test/regress/expected/int2.out#L9-L10].

When porting the 
[float4.sql|https://github.com/postgres/postgres/blob/REL_12_BETA1/src/test/regress/sql/float4.sql]
 found a case:
 # Bad input [throws an 
exception|https://github.com/postgres/postgres/blob/REL_12_BETA1/src/test/regress/expected/float4.sql#L24-L32].

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


When porting the 
[boolean.sql|https://github.com/postgres/postgres/blob/REL_12_BETA1/src/test/regress/sql/boolean.sql]
 found a case:
# Cast unaccepted value to boolean type throws [invalid input 
syntax|https://github.com/postgres/postgres/blob/REL_12_BETA1/src/test/regress/expected/boolean.out#L45-L47].

When porting the 
[case.sql|https://github.com/postgres/postgres/blob/REL_12_BETA1/src/test/regress/sql/case.sql]
 found a case:
 # Division by zero [throws an 
exception|https://github.com/postgres/postgres/blob/REL_12_BETA1/src/test/regress/expected/case.out#L96-L99].

When porting the 
[date.sql|https://github.com/postgres/postgres/blob/REL_12_BETA1/src/test/regress/sql/date.sql]
 found a case:
 # Invalid date [throws an 
exception|https://github.com/postgres/postgres/blob/REL_12_BETA1/src/test/regress/expected/date.out#L13-L14].

When porting the 
[int2.sql|https://github.com/postgres/postgres/blob/REL_12_BETA1/src/test/regress/sql/int2.sql]
 found a case:
 # Invalid short [throws an 
exception|https://github.com/postgres/postgres/blob/REL_12_BETA1/src/test/regress/expected/int2.out#L9-L10].


> List all cases that PostgreSQL throws an exception but Spark SQL is NULL
> ------------------------------------------------------------------------
>
>                 Key: SPARK-27923
>                 URL: https://issues.apache.org/jira/browse/SPARK-27923
>             Project: Spark
>          Issue Type: Sub-task
>          Components: SQL
>    Affects Versions: 3.0.0
>            Reporter: Yuming Wang
>            Priority: Major
>
> In this ticket, we plan to list all cases that PostgreSQL throws an exception 
> but Spark SQL is NULL.
> When porting the 
> [boolean.sql|https://github.com/postgres/postgres/blob/REL_12_BETA1/src/test/regress/sql/boolean.sql]
>  found a case:
> # Cast unaccepted value to boolean type throws [invalid input 
> syntax|https://github.com/postgres/postgres/blob/REL_12_BETA1/src/test/regress/expected/boolean.out#L45-L47].
> When porting the 
> [case.sql|https://github.com/postgres/postgres/blob/REL_12_BETA1/src/test/regress/sql/case.sql]
>  found a case:
>  # Division by zero [throws an 
> exception|https://github.com/postgres/postgres/blob/REL_12_BETA1/src/test/regress/expected/case.out#L96-L99].
> When porting the 
> [date.sql|https://github.com/postgres/postgres/blob/REL_12_BETA1/src/test/regress/sql/date.sql]
>  found a case:
>  # Invalid date [throws an 
> exception|https://github.com/postgres/postgres/blob/REL_12_BETA1/src/test/regress/expected/date.out#L13-L14].
> When porting the 
> [int2.sql|https://github.com/postgres/postgres/blob/REL_12_BETA1/src/test/regress/sql/int2.sql]
>  found a case:
>  # Invalid short [throws an 
> exception|https://github.com/postgres/postgres/blob/REL_12_BETA1/src/test/regress/expected/int2.out#L9-L10].
> When porting the 
> [float4.sql|https://github.com/postgres/postgres/blob/REL_12_BETA1/src/test/regress/sql/float4.sql]
>  found a case:
>  # Bad input [throws an 
> exception|https://github.com/postgres/postgres/blob/REL_12_BETA1/src/test/regress/expected/float4.sql#L24-L32].



--
This message was sent by Atlassian JIRA
(v7.6.3#76005)

---------------------------------------------------------------------
To unsubscribe, e-mail: issues-unsubscr...@spark.apache.org
For additional commands, e-mail: issues-h...@spark.apache.org

Reply via email to