{"url":"http://public2.vulnerablecode.io/api/packages/69787?format=json","purl":"pkg:pypi/sqlparse@0.5.0","type":"pypi","namespace":"","name":"sqlparse","version":"0.5.0","qualifiers":{},"subpath":"","is_vulnerable":true,"next_non_vulnerable_version":"0.5.4","latest_non_vulnerable_version":"0.5.4","affected_by_vulnerabilities":[{"url":"http://public2.vulnerablecode.io/api/vulnerabilities/50131?format=json","vulnerability_id":"VCID-q1py-pag7-aufq","summary":"sqlparse: formatting list of tuples leads to denial of service\nThe below gist hangs while attempting to format a long list of tuples.\n\nThis was found while [drafting a regression test for Dja\nngo 5.2's composite primary key feature](https://code.djangoproject.com/ticket/36416#comment:3), which allows querying composite fields with tuples.","references":[{"reference_url":"https://github.com/andialbrecht/sqlparse","reference_id":"","reference_type":"","scores":[{"value":"6.9","scoring_system":"cvssv4","scoring_elements":"CVSS:4.0/AV:N/AC:L/AT:N/PR:N/UI:N/VC:N/VI:L/VA:N/SC:N/SI:N/SA:N"},{"value":"MODERATE","scoring_system":"generic_textual","scoring_elements":""}],"url":"https://github.com/andialbrecht/sqlparse"},{"reference_url":"https://github.com/andialbrecht/sqlparse/commit/40ed3aa958657fa4a82055927fa9de70ab903360","reference_id":"","reference_type":"","scores":[{"value":"6.9","scoring_system":"cvssv4","scoring_elements":"CVSS:4.0/AV:N/AC:L/AT:N/PR:N/UI:N/VC:N/VI:L/VA:N/SC:N/SI:N/SA:N"},{"value":"MODERATE","scoring_system":"generic_textual","scoring_elements":""}],"url":"https://github.com/andialbrecht/sqlparse/commit/40ed3aa958657fa4a82055927fa9de70ab903360"},{"reference_url":"https://github.com/andialbrecht/sqlparse/releases/tag/0.5.4","reference_id":"","reference_type":"","scores":[{"value":"6.9","scoring_system":"cvssv4","scoring_elements":"CVSS:4.0/AV:N/AC:L/AT:N/PR:N/UI:N/VC:N/VI:L/VA:N/SC:N/SI:N/SA:N"},{"value":"MODERATE","scoring_system":"generic_textual","scoring_elements":""}],"url":"https://github.com/andialbrecht/sqlparse/releases/tag/0.5.4"},{"reference_url":"https://github.com/advisories/GHSA-27jp-wm6q-gp25","reference_id":"GHSA-27jp-wm6q-gp25","reference_type":"","scores":[{"value":"MODERATE","scoring_system":"cvssv3.1_qr","scoring_elements":""}],"url":"https://github.com/advisories/GHSA-27jp-wm6q-gp25"},{"reference_url":"https://github.com/andialbrecht/sqlparse/security/advisories/GHSA-27jp-wm6q-gp25","reference_id":"GHSA-27jp-wm6q-gp25","reference_type":"","scores":[{"value":"MODERATE","scoring_system":"cvssv3.1_qr","scoring_elements":""},{"value":"6.9","scoring_system":"cvssv4","scoring_elements":"CVSS:4.0/AV:N/AC:L/AT:N/PR:N/UI:N/VC:N/VI:L/VA:N/SC:N/SI:N/SA:N"},{"value":"MODERATE","scoring_system":"generic_textual","scoring_elements":""}],"url":"https://github.com/andialbrecht/sqlparse/security/advisories/GHSA-27jp-wm6q-gp25"}],"fixed_packages":[{"url":"http://public2.vulnerablecode.io/api/packages/74034?format=json","purl":"pkg:pypi/sqlparse@0.5.4","is_vulnerable":false,"affected_by_vulnerabilities":[],"resource_url":"http://public2.vulnerablecode.io/packages/pkg:pypi/sqlparse@0.5.4"}],"aliases":["GHSA-27jp-wm6q-gp25"],"risk_score":3.1,"exploitability":"0.5","weighted_severity":"6.2","resource_url":"http://public2.vulnerablecode.io/vulnerabilities/VCID-q1py-pag7-aufq"}],"fixing_vulnerabilities":[{"url":"http://public2.vulnerablecode.io/api/vulnerabilities/47483?format=json","vulnerability_id":"VCID-6jpc-dsrp-6qdg","summary":"sqlparse parsing heavily nested list leads to Denial of Service\nPassing a heavily nested list to sqlparse.parse() leads to a Denial of Service due to RecursionError.","references":[{"reference_url":"https://access.redhat.com/hydra/rest/securitydata/cve/CVE-2024-4340.json","reference_id":"","reference_type":"","scores":[{"value":"7.5","scoring_system":"cvssv3","scoring_elements":"CVSS:3.1/AV:N/AC:L/PR:N/UI:N/S:U/C:N/I:N/A:H"}],"url":"https://access.redhat.com/hydra/rest/securitydata/cve/CVE-2024-4340.json"},{"reference_url":"https://api.first.org/data/v1/epss?cve=CVE-2024-4340","reference_id":"","reference_type":"","scores":[{"value":"0.10881","scoring_system":"epss","scoring_elements":"0.93529","published_at":"2026-06-08T12:55:00Z"},{"value":"0.10881","scoring_system":"epss","scoring_elements":"0.93531","published_at":"2026-06-05T12:55:00Z"},{"value":"0.10881","scoring_system":"epss","scoring_elements":"0.93532","published_at":"2026-06-06T12:55:00Z"}],"url":"https://api.first.org/data/v1/epss?cve=CVE-2024-4340"},{"reference_url":"https://cve.mitre.org/cgi-bin/cvename.cgi?name=CVE-2024-4340","reference_id":"","reference_type":"","scores":[],"url":"https://cve.mitre.org/cgi-bin/cvename.cgi?name=CVE-2024-4340"},{"reference_url":"https://ftp.suse.com/pub/projects/security/yaml/suse-cvss-scores.yaml","reference_id":"","reference_type":"","scores":[{"value":"7.5","scoring_system":"cvssv3.1","scoring_elements":"CVSS:3.1/AV:N/AC:L/PR:N/UI:N/S:U/C:N/I:N/A:H"}],"url":"https://ftp.suse.com/pub/projects/security/yaml/suse-cvss-scores.yaml"},{"reference_url":"https://github.com/andialbrecht/sqlparse","reference_id":"","reference_type":"","scores":[{"value":"7.5","scoring_system":"cvssv3.1","scoring_elements":"CVSS:3.1/AV:N/AC:L/PR:N/UI:N/S:U/C:N/I:N/A:H"},{"value":"HIGH","scoring_system":"generic_textual","scoring_elements":""}],"url":"https://github.com/andialbrecht/sqlparse"},{"reference_url":"https://github.com/andialbrecht/sqlparse/commit/b4a39d9850969b4e1d6940d32094ee0b42a2cf03","reference_id":"","reference_type":"","scores":[{"value":"7.5","scoring_system":"cvssv3.1","scoring_elements":"CVSS:3.1/AV:N/AC:L/PR:N/UI:N/S:U/C:N/I:N/A:H"},{"value":"HIGH","scoring_system":"generic_textual","scoring_elements":""},{"value":"Track","scoring_system":"ssvc","scoring_elements":"SSVCv2/E:P/A:Y/T:P/P:M/B:A/M:M/D:T/2024-04-30T16:07:16Z/"}],"url":"https://github.com/andialbrecht/sqlparse/commit/b4a39d9850969b4e1d6940d32094ee0b42a2cf03"},{"reference_url":"https://research.jfrog.com/vulnerabilities/sqlparse-stack-exhaustion-dos-jfsa-2024-001031292","reference_id":"","reference_type":"","scores":[{"value":"7.5","scoring_system":"cvssv3.1","scoring_elements":"CVSS:3.1/AV:N/AC:L/PR:N/UI:N/S:U/C:N/I:N/A:H"},{"value":"HIGH","scoring_system":"generic_textual","scoring_elements":""}],"url":"https://research.jfrog.com/vulnerabilities/sqlparse-stack-exhaustion-dos-jfsa-2024-001031292"},{"reference_url":"https://bugs.debian.org/cgi-bin/bugreport.cgi?bug=1070148","reference_id":"1070148","reference_type":"","scores":[],"url":"https://bugs.debian.org/cgi-bin/bugreport.cgi?bug=1070148"},{"reference_url":"https://bugzilla.redhat.com/show_bug.cgi?id=2278038","reference_id":"2278038","reference_type":"","scores":[],"url":"https://bugzilla.redhat.com/show_bug.cgi?id=2278038"},{"reference_url":"https://nvd.nist.gov/vuln/detail/CVE-2024-4340","reference_id":"CVE-2024-4340","reference_type":"","scores":[{"value":"7.5","scoring_system":"cvssv3.1","scoring_elements":"CVSS:3.1/AV:N/AC:L/PR:N/UI:N/S:U/C:N/I:N/A:H"},{"value":"HIGH","scoring_system":"generic_textual","scoring_elements":""}],"url":"https://nvd.nist.gov/vuln/detail/CVE-2024-4340"},{"reference_url":"https://github.com/advisories/GHSA-2m57-hf25-phgg","reference_id":"GHSA-2m57-hf25-phgg","reference_type":"","scores":[{"value":"7.5","scoring_system":"cvssv3.1","scoring_elements":"CVSS:3.1/AV:N/AC:L/PR:N/UI:N/S:U/C:N/I:N/A:H"},{"value":"HIGH","scoring_system":"cvssv3.1_qr","scoring_elements":""},{"value":"Track","scoring_system":"ssvc","scoring_elements":"SSVCv2/E:P/A:Y/T:P/P:M/B:A/M:M/D:T/2024-04-30T16:07:16Z/"}],"url":"https://github.com/advisories/GHSA-2m57-hf25-phgg"},{"reference_url":"https://github.com/andialbrecht/sqlparse/security/advisories/GHSA-2m57-hf25-phgg","reference_id":"GHSA-2m57-hf25-phgg","reference_type":"","scores":[{"value":"7.5","scoring_system":"cvssv3.1","scoring_elements":"CVSS:3.1/AV:N/AC:L/PR:N/UI:N/S:U/C:N/I:N/A:H"},{"value":"HIGH","scoring_system":"cvssv3.1_qr","scoring_elements":""},{"value":"HIGH","scoring_system":"generic_textual","scoring_elements":""}],"url":"https://github.com/andialbrecht/sqlparse/security/advisories/GHSA-2m57-hf25-phgg"},{"reference_url":"https://access.redhat.com/errata/RHSA-2024:3781","reference_id":"RHSA-2024:3781","reference_type":"","scores":[],"url":"https://access.redhat.com/errata/RHSA-2024:3781"},{"reference_url":"https://access.redhat.com/errata/RHSA-2024:9984","reference_id":"RHSA-2024:9984","reference_type":"","scores":[],"url":"https://access.redhat.com/errata/RHSA-2024:9984"},{"reference_url":"https://access.redhat.com/errata/RHSA-2024:9986","reference_id":"RHSA-2024:9986","reference_type":"","scores":[],"url":"https://access.redhat.com/errata/RHSA-2024:9986"},{"reference_url":"https://access.redhat.com/errata/RHSA-2025:1335","reference_id":"RHSA-2025:1335","reference_type":"","scores":[],"url":"https://access.redhat.com/errata/RHSA-2025:1335"},{"reference_url":"https://access.redhat.com/errata/RHSA-2025:9838","reference_id":"RHSA-2025:9838","reference_type":"","scores":[],"url":"https://access.redhat.com/errata/RHSA-2025:9838"},{"reference_url":"https://research.jfrog.com/vulnerabilities/sqlparse-stack-exhaustion-dos-jfsa-2024-001031292/","reference_id":"sqlparse-stack-exhaustion-dos-jfsa-2024-001031292","reference_type":"","scores":[{"value":"7.5","scoring_system":"cvssv3.1","scoring_elements":"CVSS:3.1/AV:N/AC:L/PR:N/UI:N/S:U/C:N/I:N/A:H"},{"value":"Track","scoring_system":"ssvc","scoring_elements":"SSVCv2/E:P/A:Y/T:P/P:M/B:A/M:M/D:T/2024-04-30T16:07:16Z/"}],"url":"https://research.jfrog.com/vulnerabilities/sqlparse-stack-exhaustion-dos-jfsa-2024-001031292/"},{"reference_url":"https://usn.ubuntu.com/6771-1/","reference_id":"USN-6771-1","reference_type":"","scores":[],"url":"https://usn.ubuntu.com/6771-1/"}],"fixed_packages":[{"url":"http://public2.vulnerablecode.io/api/packages/69787?format=json","purl":"pkg:pypi/sqlparse@0.5.0","is_vulnerable":true,"affected_by_vulnerabilities":[{"vulnerability":"VCID-q1py-pag7-aufq"}],"resource_url":"http://public2.vulnerablecode.io/packages/pkg:pypi/sqlparse@0.5.0"}],"aliases":["CVE-2024-4340","GHSA-2m57-hf25-phgg"],"risk_score":4.0,"exploitability":"0.5","weighted_severity":"8.0","resource_url":"http://public2.vulnerablecode.io/vulnerabilities/VCID-6jpc-dsrp-6qdg"},{"url":"http://public2.vulnerablecode.io/api/vulnerabilities/54706?format=json","vulnerability_id":"VCID-f5qv-a62p-ffdg","summary":"Duplicate Advisory: sqlparse parsing heavily nested list leads to Denial of Service\n## Duplicate Advisory\nThis advisory has been withdrawn because it is a duplicate of GHSA-2m57-hf25-phgg. This link is maintained to preserve external references.\n\n## Original Description\nPassing a heavily nested list to sqlparse.parse() leads to a Denial of Service due to RecursionError.","references":[{"reference_url":"https://github.com/andialbrecht/sqlparse/commit/b4a39d9850969b4e1d6940d32094ee0b42a2cf03","reference_id":"","reference_type":"","scores":[{"value":"7.5","scoring_system":"cvssv3.1","scoring_elements":"CVSS:3.1/AV:N/AC:L/PR:N/UI:N/S:U/C:N/I:N/A:H"},{"value":"HIGH","scoring_system":"generic_textual","scoring_elements":""}],"url":"https://github.com/andialbrecht/sqlparse/commit/b4a39d9850969b4e1d6940d32094ee0b42a2cf03"},{"reference_url":"https://research.jfrog.com/vulnerabilities/sqlparse-stack-exhaustion-dos-jfsa-2024-001031292","reference_id":"","reference_type":"","scores":[{"value":"7.5","scoring_system":"cvssv3.1","scoring_elements":"CVSS:3.1/AV:N/AC:L/PR:N/UI:N/S:U/C:N/I:N/A:H"},{"value":"HIGH","scoring_system":"generic_textual","scoring_elements":""}],"url":"https://research.jfrog.com/vulnerabilities/sqlparse-stack-exhaustion-dos-jfsa-2024-001031292"},{"reference_url":"https://nvd.nist.gov/vuln/detail/CVE-2024-4340","reference_id":"CVE-2024-4340","reference_type":"","scores":[{"value":"7.5","scoring_system":"cvssv3.1","scoring_elements":"CVSS:3.1/AV:N/AC:L/PR:N/UI:N/S:U/C:N/I:N/A:H"},{"value":"HIGH","scoring_system":"generic_textual","scoring_elements":""}],"url":"https://nvd.nist.gov/vuln/detail/CVE-2024-4340"},{"reference_url":"https://github.com/advisories/GHSA-2m57-hf25-phgg","reference_id":"GHSA-2m57-hf25-phgg","reference_type":"","scores":[{"value":"7.5","scoring_system":"cvssv3.1","scoring_elements":"CVSS:3.1/AV:N/AC:L/PR:N/UI:N/S:U/C:N/I:N/A:H"},{"value":"HIGH","scoring_system":"generic_textual","scoring_elements":""}],"url":"https://github.com/advisories/GHSA-2m57-hf25-phgg"},{"reference_url":"https://github.com/advisories/GHSA-62qf-jcq8-8gxw","reference_id":"GHSA-62qf-jcq8-8gxw","reference_type":"","scores":[{"value":"HIGH","scoring_system":"cvssv3.1_qr","scoring_elements":""}],"url":"https://github.com/advisories/GHSA-62qf-jcq8-8gxw"}],"fixed_packages":[{"url":"http://public2.vulnerablecode.io/api/packages/69787?format=json","purl":"pkg:pypi/sqlparse@0.5.0","is_vulnerable":true,"affected_by_vulnerabilities":[{"vulnerability":"VCID-q1py-pag7-aufq"}],"resource_url":"http://public2.vulnerablecode.io/packages/pkg:pypi/sqlparse@0.5.0"}],"aliases":["GHSA-62qf-jcq8-8gxw"],"risk_score":4.0,"exploitability":"0.5","weighted_severity":"8.0","resource_url":"http://public2.vulnerablecode.io/vulnerabilities/VCID-f5qv-a62p-ffdg"}],"risk_score":"3.1","resource_url":"http://public2.vulnerablecode.io/packages/pkg:pypi/sqlparse@0.5.0"}