CVE-2026-104129
High 8.1No known exploitationFix status unknownpREST _groupby function-expression SQL injection (incomplete fix of CVE-2025-58450)
Vendor advisory: GHSA-v9v2-98xq-627c
Record last updated
CVSS score
High on a 0 to 10 scale
EPSS, chance of exploitation in 30 days
Higher than 28% of scored CVEs. A prediction, not evidence.
CISA remediation deadline
Not in the KEV catalog
Description
pREST (PostgreSQL REST) is an API that delivers an application on top of a Postgres database. Prior to 2.4.0, the vulnerable parameter is _groupby, handled by GroupByClause in adapters/postgres/postgres.go. adapters/postgres/postgres.go uses the weaker isSafeSQLExpression check for this function-expression branch instead of the stricter single-field validator used for _select. That check validates only the outer function name against a 13-function allowlist and permits nested subqueries, trailing UNION syntax, and inner pg_ functions. controllers/crud.go concatenates the GROUP BY expression while parameterizing only WHERE values, allowing attacker-controlled SQL structure into the clause. Default configuration permits unauthenticated access; a restricted installation may require a low-privilege table reader. UNION-based extraction requires compatible column counts and types and was not verified end to end, but a delay-producing function can cause denial of service without that alignment. This issue is fixed in 2.4.0.
Weakness: CWE-89
Patching and mitigation
- Patch status
- Unknown: no source documents a fix
- Mitigation
- None documented
- Vendor guidance
- github.com (opens in a new tab)
Affected products
| Vendor | Product | Affected versions | Fixed in | Per |
|---|---|---|---|---|
| go | github.com/prest/prest | all versions up to and including 1.5.5 | Not documented | GitHub Advisory Database |
| go | github.com/prest/prest/v2 | all versions up to and including 2.3.0 | 2.4.0 | GitHub Advisory Database |
| prest | prest | < 2.4.0 | Not documented | CVE Program |
Timeline
Disclosure
CVE record published by GitHub_M
Source: CVE Program (opens in a new tab)
Vendor guidance and references
- GitHub Advisory GHSA-v9v2-98xq-627c (opens in a new tab)github-advisory
- https://github.com/prest/prest/commit/084348fa82701b098492fc520557ff290b7691e2 (opens in a new tab)x_refsource_misc
- https://github.com/prest/prest/commit/73e4b2aea81e2dbd33942efcb1a313fe3b151a41 (opens in a new tab)x_refsource_misc
- https://github.com/prest/prest/pull/1014 (opens in a new tab)x_refsource_misc
- https://github.com/prest/prest/releases/tag/v2.4.0 (opens in a new tab)x_refsource_misc
- https://github.com/prest/prest/security/advisories/GHSA-v9v2-98xq-627c (opens in a new tab)x_refsource_confirm