This is an automated email from the ASF dual-hosted git repository.
yangjie01 pushed a commit to branch branch-4.0
in repository https://gitbox.apache.org/repos/asf/spark.git
The following commit(s) were added to refs/heads/branch-4.0 by this push:
new dd17f263e6d7 [SPARK-51937][SQL][TESTS] Re-generate golden files of
`postgreSQL/float4.sql` and `postgreSQL/int8.sql` for Java 21
dd17f263e6d7 is described below
commit dd17f263e6d7135d815a252c8f4fa5e6110b08b6
Author: yangjie01 <yangji...@baidu.com>
AuthorDate: Mon Apr 28 23:09:01 2025 +0800
[SPARK-51937][SQL][TESTS] Re-generate golden files of
`postgreSQL/float4.sql` and `postgreSQL/int8.sql` for Java 21
### What changes were proposed in this pull request?
This pr aims to Re-generate golden files of `postgreSQL/float4.sql` and
`postgreSQL/int8.sql` for Java 21. https://github.com/apache/spark/pull/50604
forgot to generate them.
### Why are the changes needed?
Restore Java 21 daily test:
- master:
https://github.com/apache/spark/actions/runs/14699959163/job/41247643789
- branch-4.0:
https://github.com/apache/spark/actions/runs/14700610338/job/41249373892
### Does this PR introduce _any_ user-facing change?
No
### How was this patch tested?
- Pass Github Actions
- locally test with Java 21
### Was this patch authored or co-authored using generative AI tooling?
No
Closes #50740 from LuciferYang/SPARK-51817-FOLLOWUP.
Authored-by: yangjie01 <yangji...@baidu.com>
Signed-off-by: yangjie01 <yangji...@baidu.com>
(cherry picked from commit 6c37ee4943e765a93bba44d9d57e51f61a66a4f1)
Signed-off-by: yangjie01 <yangji...@baidu.com>
---
.../resources/sql-tests/results/postgreSQL/float4.sql.out.java21 | 7 +++++++
.../resources/sql-tests/results/postgreSQL/int8.sql.out.java21 | 4 ++++
2 files changed, 11 insertions(+)
diff --git
a/sql/core/src/test/resources/sql-tests/results/postgreSQL/float4.sql.out.java21
b/sql/core/src/test/resources/sql-tests/results/postgreSQL/float4.sql.out.java21
index 3c2189c39963..6126411071bc 100644
---
a/sql/core/src/test/resources/sql-tests/results/postgreSQL/float4.sql.out.java21
+++
b/sql/core/src/test/resources/sql-tests/results/postgreSQL/float4.sql.out.java21
@@ -97,6 +97,7 @@ org.apache.spark.SparkNumberFormatException
"errorClass" : "CAST_INVALID_INPUT",
"sqlState" : "22018",
"messageParameters" : {
+ "ansiConfig" : "\"spark.sql.ansi.enabled\"",
"expression" : "'N A N'",
"sourceType" : "\"STRING\"",
"targetType" : "\"FLOAT\""
@@ -121,6 +122,7 @@ org.apache.spark.SparkNumberFormatException
"errorClass" : "CAST_INVALID_INPUT",
"sqlState" : "22018",
"messageParameters" : {
+ "ansiConfig" : "\"spark.sql.ansi.enabled\"",
"expression" : "'NaN x'",
"sourceType" : "\"STRING\"",
"targetType" : "\"FLOAT\""
@@ -145,6 +147,7 @@ org.apache.spark.SparkNumberFormatException
"errorClass" : "CAST_INVALID_INPUT",
"sqlState" : "22018",
"messageParameters" : {
+ "ansiConfig" : "\"spark.sql.ansi.enabled\"",
"expression" : "' INFINITY x'",
"sourceType" : "\"STRING\"",
"targetType" : "\"FLOAT\""
@@ -193,6 +196,7 @@ org.apache.spark.SparkNumberFormatException
"errorClass" : "CAST_INVALID_INPUT",
"sqlState" : "22018",
"messageParameters" : {
+ "ansiConfig" : "\"spark.sql.ansi.enabled\"",
"expression" : "'nan'",
"sourceType" : "\"STRING\"",
"targetType" : "\"DECIMAL(10,0)\""
@@ -389,6 +393,7 @@ org.apache.spark.SparkArithmeticException
"errorClass" : "CAST_OVERFLOW",
"sqlState" : "22003",
"messageParameters" : {
+ "ansiConfig" : "\"spark.sql.ansi.enabled\"",
"sourceType" : "\"FLOAT\"",
"targetType" : "\"INT\"",
"value" : "2.1474836E9"
@@ -414,6 +419,7 @@ org.apache.spark.SparkArithmeticException
"errorClass" : "CAST_OVERFLOW",
"sqlState" : "22003",
"messageParameters" : {
+ "ansiConfig" : "\"spark.sql.ansi.enabled\"",
"sourceType" : "\"FLOAT\"",
"targetType" : "\"INT\"",
"value" : "-2.147484E9"
@@ -455,6 +461,7 @@ org.apache.spark.SparkArithmeticException
"errorClass" : "CAST_OVERFLOW",
"sqlState" : "22003",
"messageParameters" : {
+ "ansiConfig" : "\"spark.sql.ansi.enabled\"",
"sourceType" : "\"FLOAT\"",
"targetType" : "\"BIGINT\"",
"value" : "-9.22338E18"
diff --git
a/sql/core/src/test/resources/sql-tests/results/postgreSQL/int8.sql.out.java21
b/sql/core/src/test/resources/sql-tests/results/postgreSQL/int8.sql.out.java21
index e7df03dc8cad..ee3f8625da8a 100755
---
a/sql/core/src/test/resources/sql-tests/results/postgreSQL/int8.sql.out.java21
+++
b/sql/core/src/test/resources/sql-tests/results/postgreSQL/int8.sql.out.java21
@@ -737,6 +737,7 @@ org.apache.spark.SparkArithmeticException
"errorClass" : "CAST_OVERFLOW",
"sqlState" : "22003",
"messageParameters" : {
+ "ansiConfig" : "\"spark.sql.ansi.enabled\"",
"sourceType" : "\"BIGINT\"",
"targetType" : "\"INT\"",
"value" : "4567890123456789L"
@@ -762,6 +763,7 @@ org.apache.spark.SparkArithmeticException
"errorClass" : "CAST_OVERFLOW",
"sqlState" : "22003",
"messageParameters" : {
+ "ansiConfig" : "\"spark.sql.ansi.enabled\"",
"sourceType" : "\"BIGINT\"",
"targetType" : "\"SMALLINT\"",
"value" : "4567890123456789L"
@@ -807,6 +809,7 @@ org.apache.spark.SparkArithmeticException
"errorClass" : "CAST_OVERFLOW",
"sqlState" : "22003",
"messageParameters" : {
+ "ansiConfig" : "\"spark.sql.ansi.enabled\"",
"sourceType" : "\"DOUBLE\"",
"targetType" : "\"BIGINT\"",
"value" : "9.223372036854776E20D"
@@ -895,6 +898,7 @@ org.apache.spark.SparkArithmeticException
"errorClass" : "CAST_OVERFLOW",
"sqlState" : "22003",
"messageParameters" : {
+ "ansiConfig" : "\"spark.sql.ansi.enabled\"",
"sourceType" : "\"BIGINT\"",
"targetType" : "\"INT\"",
"value" : "-9223372036854775808L"
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscr...@spark.apache.org
For additional commands, e-mail: commits-h...@spark.apache.org
