pgx SQL Injection via Line Comment Creation
jackc pgx
Affected versions
| Product | Affected | Fixed in |
|---|---|---|
| github.com/jackc/pgx Go |
|
|
| github.com/jackc/pgx/v4 Go |
|
|
jackc pgx
| Product | Affected | Fixed in |
|---|---|---|
| github.com/jackc/pgx Go |
|
|
| github.com/jackc/pgx/v4 Go |
|
|
pgx is a PostgreSQL driver and toolkit for Go. Prior to version 4.18.2, SQL injection can occur when all of the following conditions are met: the non-default simple protocol is used; a placeholder for a numeric value must be immediately preceded by a minus; there must be a second placeholder for a string value after the first placeholder; both must be on the same line; and both parameter values must be user-controlled. The problem is resolved in v4.18.2. As a workaround, do not use the simple protocol or do not place a minus directly before a placeholder.
From the CVE record · GitHub_M
pgx can allow SQL injection when an application uses the non-default simple protocol and lets users control both a numeric and a string parameter. The numeric placeholder must be immediately preceded by a minus, and the string placeholder must follow it on the same line.
Teams using Go packages github.com/jackc/pgx or github.com/jackc/pgx/v4 before version 4.18.2 should check their applications.