This is an automated email from the ASF dual-hosted git repository.
yao pushed a commit to branch master
in repository https://gitbox.apache.org/repos/asf/spark.git
The following commit(s) were added to refs/heads/master by this push:
new d7f0c8fca7bd [SPARK-49314][BUILD][TESTS] Upgrade `h2` to 2.3.232,
`postgresql` to 42.7.4 and `mssql` to 12.8.1.jre11
d7f0c8fca7bd is described below
commit d7f0c8fca7bda2a08325a30242f6dacf0902faec
Author: Wei Guo <[email protected]>
AuthorDate: Mon Aug 26 16:58:36 2024 +0800
[SPARK-49314][BUILD][TESTS] Upgrade `h2` to 2.3.232, `postgresql` to 42.7.4
and `mssql` to 12.8.1.jre11
### What changes were proposed in this pull request?
This PR aims to upgrade `h2` to 2.3.232, `postgresql` to 42.7.4 and `mssql`
to 12.8.1.jre11.
### Why are the changes needed?
1. For `h2`, there are some issues fixed in version 2.3.232(full release
notes: https://www.h2database.com/html/changelog.html):
- [Issue #3945](https://github.com/h2database/h2database/issues/3945):
Column not found in correlated subquery, when referencing outer column from
LEFT JOIN .. ON clause
- [Issue #4097](https://github.com/h2database/h2database/issues/4097):
StackOverflowException when using multiple SELECT statements in one query
(2.3.230)
- [Issue #3982](https://github.com/h2database/h2database/issues/3982):
Potential issue when using ROUND
- [Issue #3894](https://github.com/h2database/h2database/issues/3894):
Race condition causing stale data in query last result cache
- [Issue #4075](https://github.com/h2database/h2database/issues/4075):
infinite loop in compact
- [Issue #4091](https://github.com/h2database/h2database/issues/4091):
Wrong case with linked table to postgresql
- [Issue #4088](https://github.com/h2database/h2database/issues/4088):
BadGrammarException when the same alias is used within two different CTEs
2. For `postgresql`, there are some issues fixed and improvements in
version 42.7.4(full release notes:
https://jdbc.postgresql.org/changelogs/2024-08-22-42.7.4-release/):
- fix: PgInterval ignores case for represented interval string [PR
#3344](https://github.com/pgjdbc/pgjdbc/pull/3344)
- perf: Avoid extra copies when receiving int4 and int2 in PGStream [PR
#3295](https://github.com/pgjdbc/pgjdbc/pull/3295)
- fix: Add support for Infinity::numeric values in ResultSet.getObject
[PR #3304](https://github.com/pgjdbc/pgjdbc/pull/3304)
- fix: Ensure order of results for getDouble [PR
#3301](https://github.com/pgjdbc/pgjdbc/pull/3301)
- perf: Replace BufferedOutputStream with unsynchronized
PgBufferedOutputStream, allow configuring different Java and SO_SNDBUF buffer
sizes [PR #3248](https://github.com/pgjdbc/pgjdbc/pull/3248)
- fix: Fix SSL tests [PR
#3260](https://github.com/pgjdbc/pgjdbc/pull/3260)
- fix: Support bytea in preferQueryMode=simple [PR
#3243](https://github.com/pgjdbc/pgjdbc/pull/3243)
- fix: Fix [Issue #3234](https://github.com/pgjdbc/pgjdbc/issues/3234)
- Return -1 as update count for stored procedure calls [PR
#3235](https://github.com/pgjdbc/pgjdbc/pull/3235)
- fix: Fix [Issue #3224](https://github.com/pgjdbc/pgjdbc/issues/3224)
- conversion for TIME ‘24:00’ to LocalTime breaks in binary-mode [PR
#3225](https://github.com/pgjdbc/pgjdbc/pull/3225)
3. For `mssql`, there are some issues fixed in 12.8.1.jre11(full release
notes: https://github.com/microsoft/mssql-jdbc/releases/tag/v12.8.1):
- Adjusted DESTINATION_COL_METADATA_LOCK, in SQLServerBulkCopy, so that
is properly released in all cases [PR
#2492](https://github.com/microsoft/mssql-jdbc/pull/2492)
- Reverted "Execute Stored Procedures Directly" feature, as well as
subsequent changes related to the feature [PR
#2493](https://github.com/microsoft/mssql-jdbc/pull/2493)
- Changed driver behavior to allow prepared statement objects to be
reused, preventing a "multiple queries are not allowed" error [PR
#2494](https://github.com/microsoft/mssql-jdbc/pull/2494)
### Does this PR introduce _any_ user-facing change?
No.
### How was this patch tested?
Pass GA.
### Was this patch authored or co-authored using generative AI tooling?
No.
Closes #47810 from wayneguow/ug_h2.
Authored-by: Wei Guo <[email protected]>
Signed-off-by: Kent Yao <[email protected]>
---
pom.xml | 4 ++--
sql/connect/server/pom.xml | 2 +-
sql/core/pom.xml | 2 +-
3 files changed, 4 insertions(+), 4 deletions(-)
diff --git a/pom.xml b/pom.xml
index 38311b68ac7b..4717c4479186 100644
--- a/pom.xml
+++ b/pom.xml
@@ -325,9 +325,9 @@
</extraJavaTestArgs>
<mariadb.java.client.version>2.7.12</mariadb.java.client.version>
<mysql.connector.version>9.0.0</mysql.connector.version>
- <postgresql.version>42.7.3</postgresql.version>
+ <postgresql.version>42.7.4</postgresql.version>
<db2.jcc.version>11.5.9.0</db2.jcc.version>
- <mssql.jdbc.version>12.8.0.jre11</mssql.jdbc.version>
+ <mssql.jdbc.version>12.8.1.jre11</mssql.jdbc.version>
<ojdbc11.version>23.5.0.24.07</ojdbc11.version>
<!-- Used for SBT build to retrieve the Spark version -->
<spark.version>${project.version}</spark.version>
diff --git a/sql/connect/server/pom.xml b/sql/connect/server/pom.xml
index 3afd0f2cbf07..2e7c3f81aa1d 100644
--- a/sql/connect/server/pom.xml
+++ b/sql/connect/server/pom.xml
@@ -243,7 +243,7 @@
<dependency>
<groupId>com.h2database</groupId>
<artifactId>h2</artifactId>
- <version>2.3.230</version>
+ <version>2.3.232</version>
<scope>test</scope>
</dependency>
<dependency>
diff --git a/sql/core/pom.xml b/sql/core/pom.xml
index 6ecc11745249..9eb5decb3b51 100644
--- a/sql/core/pom.xml
+++ b/sql/core/pom.xml
@@ -167,7 +167,7 @@
<dependency>
<groupId>com.h2database</groupId>
<artifactId>h2</artifactId>
- <version>2.3.230</version>
+ <version>2.3.232</version>
<scope>test</scope>
</dependency>
<dependency>
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
