{"id":"UBUNTU-CVE-2020-7471","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.","modified":"2026-02-04T03:18:33.483734Z","published":"2020-02-03T10:00:00Z","related":["USN-4264-1"],"upstream":["CVE-2020-7471"],"references":[{"type":"REPORT","url":"https://ubuntu.com/security/CVE-2020-7471"},{"type":"REPORT","url":"https://www.openwall.com/lists/oss-security/2020/02/03/1"},{"type":"ADVISORY","url":"https://ubuntu.com/security/notices/USN-4264-1"},{"type":"REPORT","url":"https://www.cve.org/CVERecord?id=CVE-2020-7471"}],"affected":[{"package":{"name":"python-django","ecosystem":"Ubuntu:18.04:LTS","purl":"pkg:deb/ubuntu/python-django@1:1.11.11-1ubuntu1.7?arch=source&distro=bionic"},"ranges":[{"type":"ECOSYSTEM","events":[{"introduced":"0"},{"fixed":"1:1.11.11-1ubuntu1.7"}]}],"versions":["1:1.11.4-1ubuntu1","1:1.11.6-1ubuntu1","1:1.11.9-1ubuntu1","1:1.11.11-1ubuntu1","1:1.11.11-1ubuntu1.1","1:1.11.11-1ubuntu1.2","1:1.11.11-1ubuntu1.3","1:1.11.11-1ubuntu1.4","1:1.11.11-1ubuntu1.5","1:1.11.11-1ubuntu1.6"],"ecosystem_specific":{"availability":"No subscription required","binaries":[{"binary_name":"python-django","binary_version":"1:1.11.11-1ubuntu1.7"},{"binary_version":"1:1.11.11-1ubuntu1.7","binary_name":"python-django-common"},{"binary_name":"python3-django","binary_version":"1:1.11.11-1ubuntu1.7"}]},"database_specific":{"source":"https://github.com/canonical/ubuntu-security-notices/blob/main/osv/cve/2020/UBUNTU-CVE-2020-7471.json"}}],"schema_version":"1.7.3","severity":[{"type":"CVSS_V3","score":"CVSS:3.1/AV:N/AC:L/PR:N/UI:N/S:U/C:H/I:H/A:H"},{"type":"Ubuntu","score":"medium"}]}