SQL Injection Affecting com.amazon.redshift:redshift-jdbc42 package, versions [,2.1.0.28)


Severity

Recommended
0.0
critical
0
10

CVSS assessment made by Snyk's Security Team. Learn more

Threat Intelligence

EPSS
0.05% (18th percentile)

Do your applications use this vulnerable package?

In a few clicks we can analyze your entire application and see what components are vulnerable in your application, and suggest you quick fixes.

Test your applications

Snyk Learn

Learn about SQL Injection vulnerabilities in an interactive lesson.

Start learning
  • Snyk IDSNYK-JAVA-COMAMAZONREDSHIFT-6841702
  • published15 May 2024
  • disclosed15 May 2024
  • creditUnknown

Introduced: 15 May 2024

CVE-2024-32888  (opens in a new tab)
CWE-89  (opens in a new tab)

How to fix?

Upgrade com.amazon.redshift:redshift-jdbc42 to version 2.1.0.28 or higher.

Overview

Affected versions of this package are vulnerable to SQL Injection when using PreferQueryMode=SIMPLE, which is not the default setting. By passing in a numeric value placeholder immediately preceded by a minus and followed by a second placeholder for a string value, on the same line, an attacker can construct a payload that alters the parameterized query into which it is interpolated. This effectively bypasses the protections against SQL Injection that parameterized queries offer.

Note:

This vulnerability is similar to the one in Postgres JDBC: CVE-2024-1597

CVSS Scores

version 3.1