{"id":"UBUNTU-CVE-2024-9774","details":"A vulnerability was found in python-sql where unary operators do not escape non-Expression.","modified":"2025-10-24T05:06:47Z","published":"2024-12-27T02:15:00Z","upstream":["CVE-2024-9774"],"references":[{"type":"REPORT","url":"https://ubuntu.com/security/CVE-2024-9774"},{"type":"REPORT","url":"https://www.cve.org/CVERecord?id=CVE-2024-9774"},{"type":"REPORT","url":"https://discuss.tryton.org/t/security-release-for-issue-93"}],"affected":[{"package":{"name":"python-sql","ecosystem":"Ubuntu:16.04:LTS","purl":"pkg:deb/ubuntu/python-sql@0.8-1?arch=source&distro=xenial"},"ranges":[{"type":"ECOSYSTEM","events":[{"introduced":"0"}]}],"versions":["0.7-1","0.8-1"],"ecosystem_specific":{"binaries":[{"binary_name":"python-sql","binary_version":"0.8-1"},{"binary_name":"python3-sql","binary_version":"0.8-1"}]},"database_specific":{"source":"https://github.com/canonical/ubuntu-security-notices/blob/main/osv/cve/2024/UBUNTU-CVE-2024-9774.json"}},{"package":{"name":"python-sql","ecosystem":"Ubuntu:18.04:LTS","purl":"pkg:deb/ubuntu/python-sql@0.9-1?arch=source&distro=bionic"},"ranges":[{"type":"ECOSYSTEM","events":[{"introduced":"0"}]}],"versions":["0.9-1"],"ecosystem_specific":{"binaries":[{"binary_name":"python-sql","binary_version":"0.9-1"},{"binary_name":"python3-sql","binary_version":"0.9-1"}]},"database_specific":{"source":"https://github.com/canonical/ubuntu-security-notices/blob/main/osv/cve/2024/UBUNTU-CVE-2024-9774.json"}},{"package":{"name":"python-sql","ecosystem":"Ubuntu:20.04:LTS","purl":"pkg:deb/ubuntu/python-sql@1.1.0-1?arch=source&distro=focal"},"ranges":[{"type":"ECOSYSTEM","events":[{"introduced":"0"}]}],"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-1"}]},"database_specific":{"source":"https://github.com/canonical/ubuntu-security-notices/blob/main/osv/cve/2024/UBUNTU-CVE-2024-9774.json"}},{"package":{"name":"python-sql","ecosystem":"Ubuntu:22.04:LTS","purl":"pkg:deb/ubuntu/python-sql@1.3.0-1?arch=source&distro=jammy"},"ranges":[{"type":"ECOSYSTEM","events":[{"introduced":"0"}]}],"versions":["1.2.1-1","1.3.0-1"],"ecosystem_specific":{"binaries":[{"binary_name":"python3-sql","binary_version":"1.3.0-1"}]},"database_specific":{"source":"https://github.com/canonical/ubuntu-security-notices/blob/main/osv/cve/2024/UBUNTU-CVE-2024-9774.json"}},{"package":{"name":"python-sql","ecosystem":"Ubuntu:24.04:LTS","purl":"pkg:deb/ubuntu/python-sql@1.4.0-1?arch=source&distro=noble"},"ranges":[{"type":"ECOSYSTEM","events":[{"introduced":"0"}]}],"versions":["1.4.0-1"],"ecosystem_specific":{"binaries":[{"binary_name":"python3-sql","binary_version":"1.4.0-1"}]},"database_specific":{"source":"https://github.com/canonical/ubuntu-security-notices/blob/main/osv/cve/2024/UBUNTU-CVE-2024-9774.json"}}],"schema_version":"1.7.3","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"}]}