Potential SQL injection via QuerySet.order_by and FilteredRelation
djangoproject Django
Affected versions
| Product | Affected | Fixed in |
|---|---|---|
| django PyPI |
|
|
djangoproject Django
| Product | Affected | Fixed in |
|---|---|---|
| django PyPI |
|
|
4.2.28An issue was discovered in 6.0 before 6.0.2, 5.2 before 5.2.11, and 4.2 before 4.2.28. `.QuerySet.order_by()` is subject to SQL injection in column aliases containing periods when the same alias is, using a suitably crafted dictionary, with dictionary expansion, used in `FilteredRelation`. Earlier, unsupported Django series (such as 5.0.x, 4.1.x, and 3.2.x) were not evaluated and may also be affected. Django would like to thank Solomon Kebede for reporting this issue.
From the CVE record · DSF
Django's QuerySet.order_by() is vulnerable to SQL injection when a column alias containing a period is also used in FilteredRelation through expansion of a suitably crafted dictionary. Exploitation requires control over those inputs; the report does not specify network access, authentication requirements, or user interaction.
Teams running PyPI django 6.0a1 through versions before 6.0.2, 5.2a1 through versions before 5.2.11, or 4.2a1 through versions before 4.2.28 should check their installations; earlier unsupported series were not evaluated and may also be affected.