{"id":"USN-8765-1","summary":"python-sql vulnerability","details":"Cédric Krier discovered that python-sql incorrectly escaped values passed\nto unary operators. An attacker could possibly use this issue to perform\nSQL injection attacks.","modified":"2026-09-16T02:57:28.459191491Z","published":"2026-09-15T14:39:05Z","related":["UBUNTU-CVE-2024-9774"],"upstream":["CVE-2024-9774","UBUNTU-CVE-2024-9774"],"references":[{"type":"ADVISORY","url":"https://ubuntu.com/security/notices/USN-8765-1"},{"type":"REPORT","url":"https://ubuntu.com/security/CVE-2024-9774"}],"affected":[{"package":{"name":"python-sql","ecosystem":"Ubuntu:Pro:16.04:LTS","purl":"pkg:deb/ubuntu/python-sql?arch=source&distro=esm-apps-legacy%2Fxenial"},"ranges":[{"type":"ECOSYSTEM","events":[{"introduced":"0"},{"fixed":"0.8-1ubuntu0.1~esm1"}]}],"versions":["0.7-1","0.8-1"],"ecosystem_specific":{"availability":"Available with Ubuntu Pro with Legacy support add-on: https://ubuntu.com/pro","binaries":[{"binary_name":"python-sql","binary_version":"0.8-1ubuntu0.1~esm1"},{"binary_version":"0.8-1ubuntu0.1~esm1","binary_name":"python3-sql"}]},"database_specific":{"cves_map":{"ecosystem":"Ubuntu:Pro:16.04:LTS","cves":[{"severity":[{"score":"CVSS:3.0/AV:N/AC:L/PR:H/UI:N/S:U/C:H/I:H/A:N","type":"CVSS_V3"},{"type":"Ubuntu","score":"medium"}],"id":"CVE-2024-9774"}]},"source":"https://github.com/canonical/ubuntu-security-notices/blob/main/osv/usn/USN-8765-1.json"}},{"package":{"name":"python-sql","ecosystem":"Ubuntu:Pro:18.04:LTS","purl":"pkg:deb/ubuntu/python-sql?arch=source&distro=esm-apps%2Fbionic"},"ranges":[{"type":"ECOSYSTEM","events":[{"introduced":"0"},{"fixed":"0.9-1ubuntu0.1~esm1"}]}],"versions":["0.9-1"],"ecosystem_specific":{"binaries":[{"binary_version":"0.9-1ubuntu0.1~esm1","binary_name":"python-sql"},{"binary_name":"python3-sql","binary_version":"0.9-1ubuntu0.1~esm1"}],"availability":"Available with Ubuntu Pro: https://ubuntu.com/pro"},"database_specific":{"source":"https://github.com/canonical/ubuntu-security-notices/blob/main/osv/usn/USN-8765-1.json","cves_map":{"cves":[{"id":"CVE-2024-9774","severity":[{"type":"CVSS_V3","score":"CVSS:3.0/AV:N/AC:L/PR:H/UI:N/S:U/C:H/I:H/A:N"},{"type":"Ubuntu","score":"medium"}]}],"ecosystem":"Ubuntu:Pro:18.04:LTS"}}},{"package":{"name":"python-sql","ecosystem":"Ubuntu:Pro:20.04:LTS","purl":"pkg:deb/ubuntu/python-sql?arch=source&distro=esm-apps%2Ffocal"},"ranges":[{"type":"ECOSYSTEM","events":[{"introduced":"0"},{"fixed":"1.1.0-1ubuntu0.1~esm1"}]}],"versions":["1.0.0-1","1.0.0-2","1.1.0-1"],"ecosystem_specific":{"binaries":[{"binary_name":"python3-sql","binary_version":"1.1.0-1ubuntu0.1~esm1"}],"availability":"Available with Ubuntu Pro: https://ubuntu.com/pro"},"database_specific":{"source":"https://github.com/canonical/ubuntu-security-notices/blob/main/osv/usn/USN-8765-1.json","cves_map":{"ecosystem":"Ubuntu:Pro:20.04:LTS","cves":[{"id":"CVE-2024-9774","severity":[{"type":"CVSS_V3","score":"CVSS:3.0/AV:N/AC:L/PR:H/UI:N/S:U/C:H/I:H/A:N"},{"type":"Ubuntu","score":"medium"}]}]}}},{"package":{"name":"python-sql","ecosystem":"Ubuntu:Pro:22.04:LTS","purl":"pkg:deb/ubuntu/python-sql?arch=source&distro=esm-apps%2Fjammy"},"ranges":[{"type":"ECOSYSTEM","events":[{"introduced":"0"},{"fixed":"1.3.0-1ubuntu0.1~esm1"}]}],"versions":["1.2.1-1","1.3.0-1"],"ecosystem_specific":{"availability":"Available with Ubuntu Pro: https://ubuntu.com/pro","binaries":[{"binary_name":"python3-sql","binary_version":"1.3.0-1ubuntu0.1~esm1"}]},"database_specific":{"cves_map":{"ecosystem":"Ubuntu:Pro:22.04:LTS","cves":[{"severity":[{"score":"CVSS:3.0/AV:N/AC:L/PR:H/UI:N/S:U/C:H/I:H/A:N","type":"CVSS_V3"},{"type":"Ubuntu","score":"medium"}],"id":"CVE-2024-9774"}]},"source":"https://github.com/canonical/ubuntu-security-notices/blob/main/osv/usn/USN-8765-1.json"}},{"package":{"name":"python-sql","ecosystem":"Ubuntu:24.04:LTS","purl":"pkg:deb/ubuntu/python-sql?arch=source&distro=noble"},"ranges":[{"type":"ECOSYSTEM","events":[{"introduced":"0"},{"fixed":"1.4.0-1+deb12u1build0.24.04.1"}]}],"versions":["1.4.0-1"],"ecosystem_specific":{"availability":"No subscription required","binaries":[{"binary_version":"1.4.0-1+deb12u1build0.24.04.1","binary_name":"python3-sql"}]},"database_specific":{"cves_map":{"cves":[{"id":"CVE-2024-9774","severity":[{"score":"CVSS:3.0/AV:N/AC:L/PR:H/UI:N/S:U/C:H/I:H/A:N","type":"CVSS_V3"},{"type":"Ubuntu","score":"medium"}]}],"ecosystem":"Ubuntu:24.04:LTS"},"source":"https://github.com/canonical/ubuntu-security-notices/blob/main/osv/usn/USN-8765-1.json"}}],"schema_version":"1.9.0"}