{"id":"CVE-2020-7471","aliases":["BIT-django-2020-7471","GHSA-hmr4-m2h5-33qx","PYSEC-2020-35"],"url":"https://o3.security/vulnerability/CVE-2020-7471","summary":"SQL injection in Django","details":"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.","published":"2020-02-03T12:15:26.993Z","modified":"2026-07-15T10:14:34.997365471Z","cvss":{"score":9.8,"severity":"CRITICAL","vector":"CVSS:3.1/AV:N/AC:L/PR:N/UI:N/S:U/C:H/I:H/A:H"},"epss":null,"cisaKev":null,"exploitsKnown":null,"affectedPackages":[{"ecosystem":"PyPI","name":"django","fixedVersion":"1.11.28"},{"ecosystem":"PyPI","name":"django","fixedVersion":"2.2.10"},{"ecosystem":"PyPI","name":"django","fixedVersion":"3.0.3"}],"fix":{"url":"https://github.com/django/django/commit/eb31d845323618d688ad429479c6dda973056136","label":"django/django@eb31d84"},"references":[{"type":"WEB","url":"https://groups.google.com/forum/#%21topic/django-announce/X45S86X5bZI"},{"type":"WEB","url":"https://lists.fedoraproject.org/archives/list/package-announce%40lists.fedoraproject.org/message/4A2AP4T7RKPBCLTI2NNQG3T6MINDUUMZ/"},{"type":"WEB","url":"https://seclists.org/bugtraq/2020/Feb/30"},{"type":"WEB","url":"https://usn.ubuntu.com/4264-1/"},{"type":"ADVISORY","url":"http://www.openwall.com/lists/oss-security/2020/02/03/1"},{"type":"ADVISORY","url":"https://docs.djangoproject.com/en/3.0/releases/security/"},{"type":"ADVISORY","url":"https://security.gentoo.org/glsa/202004-17"},{"type":"ADVISORY","url":"https://security.netapp.com/advisory/ntap-20200221-0006/"},{"type":"ADVISORY","url":"https://www.debian.org/security/2020/dsa-4629"},{"type":"ADVISORY","url":"https://www.djangoproject.com/weblog/2020/feb/03/security-releases/"},{"type":"ADVISORY","url":"https://www.openwall.com/lists/oss-security/2020/02/03/1"},{"type":"FIX","url":"https://github.com/django/django/commit/eb31d845323618d688ad429479c6dda973056136"}],"provenance":{"sources":["OSV.dev","FIRST.org (EPSS)"],"lastVerified":"2026-07-15T10:14:34.997365471Z"}}