CVE-2024-32888
Amazon JDBC Driver for Redshift SQL Injection via line comment generation
Reported by github_m · Published May 15, 2024
redshift-jdbc42 is fixed in 2.1.0.28 (Maven Central)
The Amazon JDBC Driver for Redshift is a Type 4 JDBC driver that provides database connectivity through the standard JDBC application program interfaces (APIs) available in the Java Platform, Enterprise Editions. Prior to version 2.1.0.28, SQL injection is possible when using the non-default connection property `preferQueryMode=simple` in combination with application code which has a vulnerable SQL that negates a parameter value. There is no vulnerability in the driver when using the default, extended query mode. Note that `preferQueryMode` is not a supported parameter in Redshift JDBC driver, and is inherited code from Postgres JDBC driver. Users who do not override default settings to utilize this unsupported query mode are not affected. This issue is patched in driver version 2.1.0.28. As a workaround, do not use the connection property `preferQueryMode=simple`. (NOTE: Those who do not explicitly specify a query mode use the default of extended query mode and are not affected by this issue.)
Fixed versions
Upgrade to a fixed version or later. Language registries are listed first, then Linux distributions, then vendor products.
| Package | Ecosystem | Fixed in |
|---|---|---|
| com.amazon.redshift:redshift-jdbc42 | Maven Central | 2.1.0.28 |
Risk scores
Affected products
| Vendor | Product | Versions |
|---|---|---|
| aws | amazon-redshift-jdbc-driver | < 2.1.0.28 |
| aws | amazon-redshift-jdbc-driver | 0 |
| chainguard | trino | 0 |
| wolfi | trino | 0 |
| Maven | com.amazon.redshift:redshift-jdbc42 | 0 |
| aws | amazon-redshift-jdbc-driver | * |
Timeline
- May 15, 2024 CVE Published
- May 15, 2024 EPSS Score (30 in total, the first dated here)
- May 17, 2024 PoC Published
- Oct 4, 2024 Coalition ESS Score (10 in total, the first dated here)
- Dec 5, 2025 CVE Updated
- Jan 12, 2026 Security Advisory
Query this with the API
The same record, from the CLI:
vulnetix vdb vuln CVE-2024-32888
vulnetix vdb fixes CVE-2024-32888
Or with curl, using the org id and key from your account page:
curl -s -H "Authorization: ApiKey ${VULNETIX_ORG_ID}:${VULNETIX_API_KEY}" \
"https://api.vdb.vulnetix.com/v2/vuln/CVE-2024-32888/fixes/registry"
The Community plan is free and allows 50 queries a day. Get a free API key · API quickstart
References
- https://github.com/aws/amazon-redshift-jdbc-driver/security/advisories/GHSA-x3wm-hffr-chwm x_refsource_CONFIRM
- https://github.com/pgjdbc/pgjdbc/security/advisories/GHSA-24rp-q3w6-vc56 x_refsource_MISC
- https://github.com/aws/amazon-redshift-jdbc-driver/commit/0d354a5f26ca23f7cac4e800e3b8734220230319 x_refsource_MISC
- https://github.com/aws/amazon-redshift-jdbc-driver/commit/12a5e8ecfbb44c8154fc66041cca2e20ecd7b339 x_refsource_MISC
- https://github.com/aws/amazon-redshift-jdbc-driver/commit/bc93694201a291493778ce5369a72befeca5ba7d x_refsource_MISC
- https://nvd.nist.gov/vuln/detail/CVE-2024-32888 advisory
- https://github.com/advisories/GHSA-x3wm-hffr-chwm advisory
- https://github.com/aws/amazon-redshift-jdbc-driver url
- https://www.sonarsource.com/blog/double-dash-double-trouble-a-subtle-sql-injection-flaw url
- https://www.sonarsource.com/blog/double-dash-double-trouble-a-subtle-sql-injection-flaw/ url