[jira] [Updated] (SPARK-27923) List all cases that PostgreSQL throws an exception but Spark SQL is NULL
[ https://issues.apache.org/jira/browse/SPARK-27923?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Dongjoon Hyun updated SPARK-27923: -- Affects Version/s: (was: 3.0.0) 3.1.0 > 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.1.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 six 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]. > # Invalid inputs [throws an > exception|https://github.com/postgres/postgres/blob/REL_12_BETA2/src/test/regress/expected/numeric.out#L1940-L1945]. > # Invalid inputs [throws an > exception|https://github.com/postgres/postgres/blob/REL_12_BETA2/src/test/regress/expected/numeric.out#L1987-L1998]. -- This message was sent by Atlassian Jira (v8.3.4#803005) - To unsubscribe, e-mail: issues-unsubscr...@spark.apache.org For additional commands, e-mail: issues-h...@spark.apache.org
[jira] [Updated] (SPARK-27923) List all cases that PostgreSQL throws an exception but Spark SQL is NULL
[ 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 six 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]. # Invalid inputs [throws an exception|https://github.com/postgres/postgres/blob/REL_12_BETA2/src/test/regress/expected/numeric.out#L1940-L1945]. # Invalid inputs [throws an exception|https://github.com/postgres/postgres/blob/REL_12_BETA2/src/test/regress/expected/numeric.out#L1987-L1998]. 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
[jira] [Updated] (SPARK-27923) List all cases that PostgreSQL throws an exception but Spark SQL is NULL
[ 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 five 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]. # Invalid inputs [throws an exception|https://github.com/postgres/postgres/blob/REL_12_BETA2/src/test/regress/expected/numeric.out#L1940-L1945]. 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
[jira] [Updated] (SPARK-27923) List all cases that PostgreSQL throws an exception but Spark SQL is NULL
[ 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
[jira] [Updated] (SPARK-27923) List all cases that PostgreSQL throws an exception but Spark SQL is NULL
[ 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 four 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
[jira] [Updated] (SPARK-27923) List all cases that PostgreSQL throws an exception but Spark SQL is NULL
[ 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]. 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].
[jira] [Updated] (SPARK-27923) List all cases that PostgreSQL throws an exception but Spark SQL is NULL
[ 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 a 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]. 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]. #
[jira] [Updated] (SPARK-27923) List all cases that PostgreSQL throws an exception but Spark SQL is NULL
[ 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 a 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]. 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]. #
[jira] [Updated] (SPARK-27923) List all cases that PostgreSQL throws an exception but Spark SQL is NULL
[ 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 a case: # Invalid decimal [throws an exception|https://github.com/postgres/postgres/blob/REL_12_BETA2/src/test/regress/expected/numeric.out#L689-L696]. 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
[jira] [Updated] (SPARK-27923) List all cases that PostgreSQL throws an exception but Spark SQL is NULL
[ 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]. 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]. > 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 >
[jira] [Updated] (SPARK-27923) List all cases that PostgreSQL throws an exception but Spark SQL is NULL
[ 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]. 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.sql#L24-L32]. # Bad special inputs [throws an exception|https://github.com/postgres/postgres/blob/REL_12_BETA1/src/test/regress/expected/float4.sql#L40-L43]. # Divide by zero [throws an exception|https://github.com/postgres/postgres/blob/REL_12_BETA1/src/test/regress/expected/float4.sql#L76-L77]. > 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 >
[jira] [Updated] (SPARK-27923) List all cases that PostgreSQL throws an exception but Spark SQL is NULL
[ 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.sql#L24-L32]. # Bad special inputs [throws an exception|https://github.com/postgres/postgres/blob/REL_12_BETA1/src/test/regress/expected/float4.sql#L40-L43]. # Divide by zero [throws an exception|https://github.com/postgres/postgres/blob/REL_12_BETA1/src/test/regress/expected/float4.sql#L76-L77]. 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 two case: # Bad input [throws an exception|https://github.com/postgres/postgres/blob/REL_12_BETA1/src/test/regress/expected/float4.sql#L24-L32]. # Bad special inputs [throws an exception|https://github.com/postgres/postgres/blob/REL_12_BETA1/src/test/regress/expected/float4.sql#L40-L43]. > 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 >
[jira] [Updated] (SPARK-27923) List all cases that PostgreSQL throws an exception but Spark SQL is NULL
[ 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 two case: # Bad input [throws an exception|https://github.com/postgres/postgres/blob/REL_12_BETA1/src/test/regress/expected/float4.sql#L24-L32]. # Bad special inputs [throws an exception|https://github.com/postgres/postgres/blob/REL_12_BETA1/src/test/regress/expected/float4.sql#L40-L43]. 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 a case: # Bad input [throws an exception|https://github.com/postgres/postgres/blob/REL_12_BETA1/src/test/regress/expected/float4.sql#L24-L32]. > 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 >
[jira] [Updated] (SPARK-27923) List all cases that PostgreSQL throws an exception but Spark SQL is NULL
[ 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)
[jira] [Updated] (SPARK-27923) List all cases that PostgreSQL throws an exception but Spark SQL is NULL
[ 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]. 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]. > 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]. -- 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
[jira] [Updated] (SPARK-27923) List all cases that PostgreSQL throws an exception but Spark SQL is NULL
[ 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 [case.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]. 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]. > 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 > [case.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]. -- 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
[jira] [Updated] (SPARK-27923) List all cases that PostgreSQL throws an exception but Spark SQL is NULL
[ 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]. 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 [case.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]. > 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]. -- 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
[jira] [Updated] (SPARK-27923) List all cases that PostgreSQL throws an exception but Spark SQL is NULL
[
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].
was:
# {{SELECT bool 'test' AS error;}}
[link|https://github.com/postgres/postgres/blob/REL_12_BETA1/src/test/regress/expected/boolean.out#L45-L47].
# {{SELECT 1/0 AS error;}}
[link|https://github.com/postgres/postgres/blob/REL_12_BETA1/src/test/regress/expected/case.out#L96-L99].
> 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].
--
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
[jira] [Updated] (SPARK-27923) List all cases that PostgreSQL throws an exception but Spark SQL is NULL
[
https://issues.apache.org/jira/browse/SPARK-27923?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Yuming Wang updated SPARK-27923:
Description:
# {{SELECT bool 'test' AS error;}}
[link|https://github.com/postgres/postgres/blob/REL_12_BETA1/src/test/regress/expected/boolean.out#L45-L47].
# {{SELECT 1/0 AS error;}}
[link|https://github.com/postgres/postgres/blob/REL_12_BETA1/src/test/regress/expected/case.out#L96-L99].
was:# {{SELECT bool 'test' AS error;}}
[link|https://github.com/postgres/postgres/blob/REL_12_BETA1/src/test/regress/expected/boolean.out#L45-L47].
> 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
>
> # {{SELECT bool 'test' AS error;}}
> [link|https://github.com/postgres/postgres/blob/REL_12_BETA1/src/test/regress/expected/boolean.out#L45-L47].
> # {{SELECT 1/0 AS error;}}
> [link|https://github.com/postgres/postgres/blob/REL_12_BETA1/src/test/regress/expected/case.out#L96-L99].
--
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
[jira] [Updated] (SPARK-27923) List all cases that PostgreSQL throws an exception but Spark SQL is NULL
[
https://issues.apache.org/jira/browse/SPARK-27923?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Yuming Wang updated SPARK-27923:
Description: # {{SELECT bool 'test' AS error;}}
[link|https://github.com/postgres/postgres/blob/REL_12_BETA1/src/test/regress/expected/boolean.out#L45-L47].
> 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
>
> # {{SELECT bool 'test' AS error;}}
> [link|https://github.com/postgres/postgres/blob/REL_12_BETA1/src/test/regress/expected/boolean.out#L45-L47].
--
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
