Vulnerability advisory

GHSA-hmr4-m2h5-33qx

SQL injection in Django

Published Feb 11, 2020Updated Feb 21, 2025OSV record ↗

Also known as BIT-django-2020-7471CVE-2020-7471PYSEC-2020-35

Severity

CVSS 3.xCVSS:3.1/AV:N/AC:L/PR:N/UI:N/S:U/C:H/I:H/A:H
CVSS 4.0CVSS:4.0/AV:N/AC:L/AT:N/PR:N/UI:N/VC:H/VI:H/VA:H/SC:N/SI:N/SA:N

Affected versions

django PyPI

All django advisories →

Affected	Fixed in
All versions before 1.11.28	`1.11.28`Advisories →
Also listed as affected (169) `1.0.1` `1.0.2` `1.0.3` `1.0.4` `1.1` `1.1.1` `1.1.2` `1.1.3` `1.1.4` `1.10` `1.10.1` `1.10.2` `1.10.3` `1.10.4` `1.10.5` `1.10.6` `1.10.7` `1.10.8` `1.10a1` `1.10b1` `1.10rc1` `1.11` `1.11.1` `1.11.10` `1.11.11` `1.11.12` `1.11.13` `1.11.14` `1.11.15` `1.11.16` `1.11.17` `1.11.18` `1.11.2` `1.11.20` `1.11.21` `1.11.22` `1.11.23` `1.11.24` `1.11.25` `1.11.26` `1.11.27` `1.11.3` `1.11.4` `1.11.5` `1.11.6` `1.11.7` `1.11.8` `1.11.9` `1.11a1` `1.11b1` `1.11rc1` `1.2` `1.2.1` `1.2.2` `1.2.3` `1.2.4` `1.2.5` `1.2.6` `1.2.7` `1.3` `1.3.1` `1.3.2` `1.3.3` `1.3.4` `1.3.5` `1.3.6` `1.3.7` `1.4` `1.4.1` `1.4.10` `1.4.11` `1.4.12` `1.4.13` `1.4.14` `1.4.15` `1.4.16` `1.4.17` `1.4.18` `1.4.19` `1.4.2` `1.4.20` `1.4.21` `1.4.22` `1.4.3` `1.4.4` `1.4.5` `1.4.6` `1.4.7` `1.4.8` `1.4.9` `1.5` `1.5.1` `1.5.10` `1.5.11` `1.5.12` `1.5.2` `1.5.3` `1.5.4` `1.5.5` `1.5.6` `1.5.7` `1.5.8` `1.5.9` `1.6` `1.6.1` `1.6.10` `1.6.11` `1.6.2` `1.6.3` `1.6.4` `1.6.5` `1.6.6` `1.6.7` `1.6.8` `1.6.9` `1.7` `1.7.1` `1.7.10` `1.7.11` `1.7.2` `1.7.3` `1.7.4` `1.7.5` `1.7.6` `1.7.7` `1.7.8` `1.7.9` `1.8` `1.8.1` `1.8.10` `1.8.11` `1.8.12` `1.8.13` `1.8.14` `1.8.15` `1.8.16` `1.8.17` `1.8.18` `1.8.19` `1.8.2` `1.8.3` `1.8.4` `1.8.5` `1.8.6` `1.8.7` `1.8.8` `1.8.9` `1.8a1` `1.8b1` `1.8b2` `1.8c1` `1.9` `1.9.1` `1.9.10` `1.9.11` `1.9.12` `1.9.13` `1.9.2` `1.9.3` `1.9.4` `1.9.5` `1.9.6` `1.9.7` `1.9.8` `1.9.9` `1.9a1` `1.9b1` `1.9rc1` `1.9rc2`
`2.0` to before 2.2.10	`2.2.10`Advisories →
Also listed as affected (44) `2.0` `2.0.1` `2.0.10` `2.0.12` `2.0.13` `2.0.2` `2.0.3` `2.0.4` `2.0.5` `2.0.6` `2.0.7` `2.0.8` `2.0.9` `2.1` `2.1.1` `2.1.10` `2.1.11` `2.1.12` `2.1.13` `2.1.14` `2.1.15` `2.1.2` `2.1.3` `2.1.4` `2.1.5` `2.1.7` `2.1.8` `2.1.9` `2.1a1` `2.1b1` `2.1rc1` `2.2` `2.2.1` `2.2.2` `2.2.3` `2.2.4` `2.2.5` `2.2.6` `2.2.7` `2.2.8` `2.2.9` `2.2a1` `2.2b1` `2.2rc1`
`3.0` to before 3.0.3	`3.0.3`Advisories →
Also listed as affected (3) `3.0` `3.0.1` `3.0.2`

Description

Django 1.11 before 1.11.28, 2.2 before 2.2.10, and 3.0 before 3.0.3 allows SQL Injection if untrusted data is used as a StringAgg delimiter (e.g., in Django applications that offer downloads of data as a series of rows with a user-specified column delimiter). By passing a suitably crafted delimiter to a contrib.postgres.aggregates.StringAgg instance, it was possible to break escaping and inject malicious SQL.

GHSA-hmr4-m2h5-33qx

Affected versions

django PyPI

Description

References