[
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 three case:
# Bad input [throws an
exception|https://github.com/postgres/postgres/blob/REL_12_BETA1/src/test/regress/expected/float4.out#L43-L74].
# Bad special inputs [throws an
exception|https://github.com/postgres/postgres/blob/REL_12_BETA1/src/test/regress/expected/float4.out#L107-L118].
# Divide by zero [throws an
exception|https://github.com/postgres/postgres/blob/REL_12_BETA1/src/test/regress/expected/float4.out#L239-L241].
When porting the
[float8.sql|https://github.com/postgres/postgres/blob/REL_12_BETA1/src/test/regress/sql/float8.sql]
found five case:
# Bad input [throws an
exception|https://github.com/postgres/postgres/blob/REL_12_BETA1/src/test/regress/expected/float8.out#L34-L65].
# Bad special inputs [throws an
exception|https://github.com/postgres/postgres/blob/REL_12_BETA1/src/test/regress/expected/float8.out#L38-L41].
# Cannot take logarithm of zero [throws an
exception|https://github.com/postgres/postgres/blob/REL_12_BETA1/src/test/regress/expected/float8.out#L439-L440].
# Cannot take logarithm of a negative number [throws an
exception|https://github.com/postgres/postgres/blob/REL_12_BETA1/src/test/regress/expected/float8.out#L441-L442].
# Divide by zero [throws an
exception|https://github.com/postgres/postgres/blob/REL_12_BETA1/src/test/regress/expected/float4.out#L445-L446].
When porting the
[numeric.sql|https://github.com/postgres/postgres/blob/REL_12_BETA2/src/test/regress/sql/numeric.sql]
found three case:
# Invalid decimal [throws an
exception|https://github.com/postgres/postgres/blob/REL_12_BETA2/src/test/regress/expected/numeric.out#L689-L696].
# decimal type can not accept [Infinity and
-Infinity|https://github.com/postgres/postgres/blob/REL_12_BETA2/src/test/regress/expected/numeric.out#L718-L731].
# Invalid inputs [throws an
exception|https://github.com/postgres/postgres/blob/REL_12_BETA2/src/test/regress/expected/numeric.out#L1429-L1460].
# Invalid inputs [throws an
exception|https://github.com/postgres/postgres/blob/REL_12_BETA2/src/test/regress/expected/numeric.out#L1883-L1887].
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].
When porting the
[float4.sql|https://github.com/postgres/postgres/blob/REL_12_BETA1/src/test/regress/sql/float4.sql]
found three case:
# Bad input [throws an
exception|https://github.com/postgres/postgres/blob/REL_12_BETA1/src/test/regress/expected/float4.out#L43-L74].
# Bad special inputs [throws an
exception|https://github.com/postgres/postgres/blob/REL_12_BETA1/src/test/regress/expected/float4.out#L107-L118].
# Divide by zero [throws an
exception|https://github.com/postgres/postgres/blob/REL_12_BETA1/src/test/regress/expected/float4.out#L239-L241].
When porting the
[float8.sql|https://github.com/postgres/postgres/blob/REL_12_BETA1/src/test/regress/sql/float8.sql]
found five case:
# Bad input [throws an
exception|https://github.com/postgres/postgres/blob/REL_12_BETA1/src/test/regress/expected/float8.out#L34-L65].
# Bad special inputs [throws an
exception|https://github.com/postgres/postgres/blob/REL_12_BETA1/src/test/regress/expected/float8.out#L38-L41].
# Cannot take logarithm of zero [throws an
exception|https://github.com/postgres/postgres/blob/REL_12_BETA1/src/test/regress/expected/float8.out#L439-L440].
# Cannot take logarithm of a negative number [throws an
exception|https://github.com/postgres/postgres/blob/REL_12_BETA1/src/test/regress/expected/float8.out#L441-L442].
# Divide by zero [throws an
exception|https://github.com/postgres/postgres/blob/REL_12_BETA1/src/test/regress/expected/float4.out#L445-L446].
When porting the
[numeric.sql|https://github.com/postgres/postgres/blob/REL_12_BETA2/src/test/regress/sql/numeric.sql]
found three case:
# Invalid decimal [throws an
exception|https://github.com/postgres/postgres/blob/REL_12_BETA2/src/test/regress/expected/numeric.out#L689-L696].
# decimal type can not accept [Infinity and
-Infinity|https://github.com/postgres/postgres/blob/REL_12_BETA2/src/test/regress/expected/numeric.out#L718-L731].
# Invalid inputs [throws an
exception|https://github.com/postgres/postgres/blob/REL_12_BETA2/src/test/regress/expected/numeric.out#L1429-L1460].
> 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 three case:
> # Bad input [throws an
> exception|https://github.com/postgres/postgres/blob/REL_12_BETA1/src/test/regress/expected/float4.out#L43-L74].
> # Bad special inputs [throws an
> exception|https://github.com/postgres/postgres/blob/REL_12_BETA1/src/test/regress/expected/float4.out#L107-L118].
> # Divide by zero [throws an
> exception|https://github.com/postgres/postgres/blob/REL_12_BETA1/src/test/regress/expected/float4.out#L239-L241].
> When porting the
> [float8.sql|https://github.com/postgres/postgres/blob/REL_12_BETA1/src/test/regress/sql/float8.sql]
> found five case:
> # Bad input [throws an
> exception|https://github.com/postgres/postgres/blob/REL_12_BETA1/src/test/regress/expected/float8.out#L34-L65].
> # Bad special inputs [throws an
> exception|https://github.com/postgres/postgres/blob/REL_12_BETA1/src/test/regress/expected/float8.out#L38-L41].
> # Cannot take logarithm of zero [throws an
> exception|https://github.com/postgres/postgres/blob/REL_12_BETA1/src/test/regress/expected/float8.out#L439-L440].
> # Cannot take logarithm of a negative number [throws an
> exception|https://github.com/postgres/postgres/blob/REL_12_BETA1/src/test/regress/expected/float8.out#L441-L442].
> # Divide by zero [throws an
> exception|https://github.com/postgres/postgres/blob/REL_12_BETA1/src/test/regress/expected/float4.out#L445-L446].
> When porting the
> [numeric.sql|https://github.com/postgres/postgres/blob/REL_12_BETA2/src/test/regress/sql/numeric.sql]
> found three case:
> # Invalid decimal [throws an
> exception|https://github.com/postgres/postgres/blob/REL_12_BETA2/src/test/regress/expected/numeric.out#L689-L696].
> # decimal type can not accept [Infinity and
> -Infinity|https://github.com/postgres/postgres/blob/REL_12_BETA2/src/test/regress/expected/numeric.out#L718-L731].
> # Invalid inputs [throws an
> exception|https://github.com/postgres/postgres/blob/REL_12_BETA2/src/test/regress/expected/numeric.out#L1429-L1460].
> # Invalid inputs [throws an
> exception|https://github.com/postgres/postgres/blob/REL_12_BETA2/src/test/regress/expected/numeric.out#L1883-L1887].
--
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
