pgx: SQL Injection via placeholder confusion with dollar quoted string literals
jackc pgx
Affected versions
| Product | Affected | Fixed in |
|---|---|---|
| github.com/jackc/pgx/v5 Go |
|
|
| github.com/jackc/pgx/v4 Go |
| No fix yet |
| github.com/jackc/pgx Go |
jackc pgx
| Product | Affected | Fixed in |
|---|---|---|
| github.com/jackc/pgx/v5 Go |
|
|
| github.com/jackc/pgx/v4 Go |
| No fix yet |
| github.com/jackc/pgx Go |
≤ 3.6.2all versions| No fix yet |
pgx is a PostgreSQL driver and toolkit for Go. Prior to version 5.9.2, SQL injection can occur when the non-default simple protocol is used, a dollar quoted string literal is used in the SQL query, that string literal contains text that would be would be interpreted as a placeholder outside of a string literal, and the value of that placeholder is controllable by the attacker. This issue has been patched in version 5.9.2.
From the CVE record · GitHub_M
pgx can allow SQL injection when an application uses the non-default simple protocol and a dollar-quoted string contains text that would be interpreted as a placeholder outside the string. Exploitation requires an attacker to control that placeholder's value.
Check Go applications using github.com/jackc/pgx/v5 before 5.9.2, github.com/jackc/pgx/v4 through 4.18.3, or github.com/jackc/pgx through 3.6.2.