PyAthena SQL Injection via DefaultParameterFormatter DELETE/CTAS
Default status is the baseline for the product, each version can override it (e.g. patched versions marked unaffected).
| Vendor | Product | Default status | Versions | |||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| laughingman7743 | PyAthena | affected |
|
No data.
No data.
| Vendor | Product | Versions | ||||||||
|---|---|---|---|---|---|---|---|---|---|---|
| Laughingman7743 | Pyathena |
|
No CVSS v3.0
No CVSS v2
This CVE is not in the KEV list.
Exploit prediction score: < 1% (0.767% probability within 30 days)
| Type | Values Removed | Values Added |
|---|---|---|
| References |
|
| Type | Values Removed | Values Added |
|---|---|---|
| Title | PyAthena 3.35.4 SQL Injection via DefaultParameterFormatter DELETE/CTAS | PyAthena SQL Injection via DefaultParameterFormatter DELETE/CTAS |
| Metrics |
ssvc
|
| Type | Values Removed | Values Added |
|---|---|---|
| First Time appeared |
Laughingman7743
Laughingman7743 pyathena |
|
| Vendors & Products |
Laughingman7743
Laughingman7743 pyathena |
| Type | Values Removed | Values Added |
|---|---|---|
| Description | PyAthena prior to 3.35.4 contains a sql injection vulnerability that allows unauthenticated attackers to inject arbitrary SQL by exploiting improper quote-escaping in DefaultParameterFormatter.format(), which routes DELETE and CTAS statements to the _escape_hive function that backslash-escapes single quotes rather than doubling them. Because Athena and Trino do not treat backslashes as escape characters inside string literals, attacker-supplied input such as a single quote followed by SQL syntax causes the parser to terminate the string literal prematurely, enabling data exfiltration via UNION SELECT, execution of destructive statements, and attacker-controlled CTAS destination and content. | |
| Title | PyAthena 3.35.4 SQL Injection via DefaultParameterFormatter DELETE/CTAS | |
| Weaknesses | CWE-89 | |
| References |
|
|
| Metrics |
cvssV3_1
|