This is an automated email from the ASF dual-hosted git repository.
wenchen 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 5397e12eb150 [SPARK-50894][SQL] Postgres driver version bump to 42.7.5
5397e12eb150 is described below
commit 5397e12eb1501eaaab222914c3babeb9c9049af9
Author: Vladan Vasić <[email protected]>
AuthorDate: Tue Jan 21 11:54:13 2025 +0800
[SPARK-50894][SQL] Postgres driver version bump to 42.7.5
### What changes were proposed in this pull request?
In this PR, I propose upgrading the version of `PostgreSQL` driver version
to `42.7.5`. More specifically, in this
[PR](https://github.com/apache/spark/pull/47810), the following regression was
introduced:
`Postgres` driver was not compatible for connection to the `Redshift` Data
Source. This happened because the `42.7.4` driver version unnecessarily sent
`SET extra_float_digits = 3` queries to the destination data source when
establishing the connection. However, the upper limit for `extra_float_digits`
parameter in `Redshift` is 2.
Regarding the release notes of version
[42.7.5](https://github.com/pgjdbc/pgjdbc/releases/tag/REL42.7.5), I propose to
upgrade the version of the driver, because the behavior of sending queries
which set `extra_flow_digits` when establishing connection was fixed in this
version.
### Why are the changes needed?
This changes are essential when trying to properly connect to the Redshift
instance from OSS.
### Does this PR introduce _any_ user-facing change?
No.
### How was this patch tested?
N/A.
### Was this patch authored or co-authored using generative AI tooling?
No.
Closes #49575 from vladanvasi-db/vladanvasi-db/postrgesql-driver-fix.
Authored-by: Vladan Vasić <[email protected]>
Signed-off-by: Wenchen Fan <[email protected]>
(cherry picked from commit 1cdb9181f91b87b3b2ada1b2e308a3598b4868a4)
Signed-off-by: Wenchen Fan <[email protected]>
---
pom.xml | 2 +-
1 file changed, 1 insertion(+), 1 deletion(-)
diff --git a/pom.xml b/pom.xml
index 757f74011c70..eabab50e8d34 100644
--- a/pom.xml
+++ b/pom.xml
@@ -330,7 +330,7 @@
</extraJavaTestArgs>
<mariadb.java.client.version>2.7.12</mariadb.java.client.version>
<mysql.connector.version>9.1.0</mysql.connector.version>
- <postgresql.version>42.7.4</postgresql.version>
+ <postgresql.version>42.7.5</postgresql.version>
<db2.jcc.version>11.5.9.0</db2.jcc.version>
<mssql.jdbc.version>12.8.1.jre11</mssql.jdbc.version>
<ojdbc17.version>23.6.0.24.10</ojdbc17.version>
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
