{"id":"CVE-2024-9774","aliases":["DEBIAN-CVE-2024-9774","DLA-3932-1","DSA-5795-1","EUVD-2024-3604","GHSA-pq9p-pc3p-9hm4","PYSEC-2026-1855","UBUNTU-CVE-2024-9774","USN-8765-1","openSUSE-SU-2024:0412-1","openSUSE-SU-2024:0413-1"],"status":"published","title":"Python-sql: python-sql unary operators does not escape non-expression","description":"A vulnerability was found in python-sql where unary operators do not escape non-Expression.","severity":{"version":"3.0","score":6.5,"vector":"CVSS:3.0/AV:N/AC:L/PR:H/UI:N/S:U/C:H/I:H/A:N","level":"medium","assessor":"cna","from":"cve"},"epss":{"day":"2026-11-11","score":0.00681,"percentile":0.52882,"model":"v2026.06.15"},"facts":{"in_kev":false,"known_exploited":false,"public_exploit":false,"fix_available":true},"cwes":["CWE-150"],"published":"2024-10-21T00:00:00Z","modified":"2026-11-02T12:03:16Z","fixes":[{"ecosystem":"PyPI","package":"python-sql","fixed_in":["1.5.2"],"sources":["ghsa","osv"]},{"ecosystem":"Debian:12","package":"python-sql","fixed_in":["1.4.0-1+deb12u1"],"sources":["osv"]},{"ecosystem":"Debian:13","package":"python-sql","fixed_in":["1.5.2-1"],"sources":["osv"]},{"ecosystem":"Debian:14","package":"python-sql","fixed_in":["1.5.2-1"],"sources":["osv"]},{"ecosystem":"Debian:11","package":"python-sql","fixed_in":["1.2.1-1+deb11u1"],"sources":["osv"]},{"ecosystem":"Ubuntu:Pro:16.04:LTS","package":"python-sql","fixed_in":["0.8-1ubuntu0.1~esm1"],"sources":["osv"]},{"ecosystem":"Ubuntu:Pro:18.04:LTS","package":"python-sql","fixed_in":["0.9-1ubuntu0.1~esm1"],"sources":["osv"]},{"ecosystem":"Ubuntu:Pro:20.04:LTS","package":"python-sql","fixed_in":["1.1.0-1ubuntu0.1~esm1"],"sources":["osv"]},{"ecosystem":"Ubuntu:Pro:22.04:LTS","package":"python-sql","fixed_in":["1.3.0-1ubuntu0.1~esm1"],"sources":["osv"]},{"ecosystem":"Ubuntu:24.04:LTS","package":"python-sql","fixed_in":["1.4.0-1+deb12u1build0.24.04.1"],"sources":["osv"]},{"ecosystem":"SUSE:Package Hub 15 SP5","package":"python-python-sql","fixed_in":["1.5.1-bp155.3.6.1"],"sources":["osv"]},{"ecosystem":"openSUSE:Leap 15.5","package":"python-python-sql","fixed_in":["1.5.1-bp155.3.6.1"],"sources":["osv"]},{"ecosystem":"SUSE:Package Hub 15 SP6","package":"python-python-sql","fixed_in":["1.5.1-bp156.2.6.1"],"sources":["osv"]},{"ecosystem":"openSUSE:Leap 15.6","package":"python-python-sql","fixed_in":["1.5.1-bp156.2.6.1"],"sources":["osv"]}],"affected":[{"source":"ghsa","ecosystem":"PyPI","package":"python-sql","ranges":[{"type":"ECOSYSTEM","events":[{"introduced":"0"},{"fixed":"1.5.2"}]}]},{"source":"osv","ecosystem":"Debian:12","package":"python-sql","ranges":[{"type":"ECOSYSTEM","events":[{"introduced":"0"},{"fixed":"1.4.0-1+deb12u1"}]}],"versions":["1.4.0-1"]},{"source":"osv","ecosystem":"Debian:13","package":"python-sql","ranges":[{"type":"ECOSYSTEM","events":[{"introduced":"0"},{"fixed":"1.5.2-1"}]}]},{"source":"osv","ecosystem":"Debian:14","package":"python-sql","ranges":[{"type":"ECOSYSTEM","events":[{"introduced":"0"},{"fixed":"1.5.2-1"}]}]},{"source":"osv","ecosystem":"Debian:11","package":"python-sql","ranges":[{"type":"ECOSYSTEM","events":[{"introduced":"0"},{"fixed":"1.2.1-1+deb11u1"}]}],"versions":["1.2.1-1"]},{"source":"osv","ecosystem":"Debian:12","package":"python-sql","ranges":[{"type":"ECOSYSTEM","events":[{"introduced":"0"},{"fixed":"1.4.0-1+deb12u1"}]}],"versions":["1.4.0-1"]},{"source":"osv","ecosystem":"PyPI","package":"python-sql","ranges":[{"type":"ECOSYSTEM","events":[{"introduced":"0"},{"fixed":"1.5.2"}]}],"versions":["0.1","0.2","0.3","0.4","0.5","0.6","0.7","0.8","0.9","1.0.0","1.1.0","1.2.0","1.2.1","1.2.2","1.3.0","1.4.0","1.4.1","1.4.2","1.4.3","1.5.0","1.5.1"]},{"source":"osv","ecosystem":"PyPI","package":"python-sql","ranges":[{"type":"ECOSYSTEM","events":[{"introduced":"0"},{"fixed":"1.5.2"}]}],"versions":["0.1","0.2","0.3","0.4","0.5","0.6","0.7","0.8","0.9","1.0.0","1.1.0","1.2.0","1.2.1","1.2.2","1.3.0","1.4.0","1.4.1","1.4.2","1.4.3","1.5.0","1.5.1"]},{"source":"osv","ecosystem":"Ubuntu:Pro:16.04:LTS","package":"python-sql","ranges":[{"type":"ECOSYSTEM","events":[{"introduced":"0"},{"fixed":"0.8-1ubuntu0.1~esm1"}]}],"versions":["0.7-1","0.8-1"]},{"source":"osv","ecosystem":"Ubuntu:Pro:18.04:LTS","package":"python-sql","ranges":[{"type":"ECOSYSTEM","events":[{"introduced":"0"},{"fixed":"0.9-1ubuntu0.1~esm1"}]}],"versions":["0.9-1"]},{"source":"osv","ecosystem":"Ubuntu:Pro:20.04:LTS","package":"python-sql","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"]},{"source":"osv","ecosystem":"Ubuntu:Pro:22.04:LTS","package":"python-sql","ranges":[{"type":"ECOSYSTEM","events":[{"introduced":"0"},{"fixed":"1.3.0-1ubuntu0.1~esm1"}]}],"versions":["1.2.1-1","1.3.0-1"]},{"source":"osv","ecosystem":"Ubuntu:24.04:LTS","package":"python-sql","ranges":[{"type":"ECOSYSTEM","events":[{"introduced":"0"},{"fixed":"1.4.0-1+deb12u1build0.24.04.1"}]}],"versions":["1.4.0-1"]},{"source":"osv","ecosystem":"Ubuntu:Pro:16.04:LTS","package":"python-sql","ranges":[{"type":"ECOSYSTEM","events":[{"introduced":"0"},{"fixed":"0.8-1ubuntu0.1~esm1"}]}],"versions":["0.7-1","0.8-1"]},{"source":"osv","ecosystem":"Ubuntu:Pro:18.04:LTS","package":"python-sql","ranges":[{"type":"ECOSYSTEM","events":[{"introduced":"0"},{"fixed":"0.9-1ubuntu0.1~esm1"}]}],"versions":["0.9-1"]},{"source":"osv","ecosystem":"Ubuntu:Pro:20.04:LTS","package":"python-sql","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"]},{"source":"osv","ecosystem":"Ubuntu:Pro:22.04:LTS","package":"python-sql","ranges":[{"type":"ECOSYSTEM","events":[{"introduced":"0"},{"fixed":"1.3.0-1ubuntu0.1~esm1"}]}],"versions":["1.2.1-1","1.3.0-1"]},{"source":"osv","ecosystem":"Ubuntu:24.04:LTS","package":"python-sql","ranges":[{"type":"ECOSYSTEM","events":[{"introduced":"0"},{"fixed":"1.4.0-1+deb12u1build0.24.04.1"}]}],"versions":["1.4.0-1"]},{"source":"osv","ecosystem":"SUSE:Package Hub 15 SP5","package":"python-python-sql","ranges":[{"type":"ECOSYSTEM","events":[{"introduced":"0"},{"fixed":"1.5.1-bp155.3.6.1"}]}]},{"source":"osv","ecosystem":"openSUSE:Leap 15.5","package":"python-python-sql","ranges":[{"type":"ECOSYSTEM","events":[{"introduced":"0"},{"fixed":"1.5.1-bp155.3.6.1"}]}]},{"source":"osv","ecosystem":"SUSE:Package Hub 15 SP6","package":"python-python-sql","ranges":[{"type":"ECOSYSTEM","events":[{"introduced":"0"},{"fixed":"1.5.1-bp156.2.6.1"}]}]},{"source":"osv","ecosystem":"openSUSE:Leap 15.6","package":"python-python-sql","ranges":[{"type":"ECOSYSTEM","events":[{"introduced":"0"},{"fixed":"1.5.1-bp156.2.6.1"}]}]}],"references":[{"url":"https://access.redhat.com/security/cve/CVE-2024-9774","tags":["vdb-entry","x_refsource_REDHAT","web"]},{"url":"https://bugzilla.redhat.com/show_bug.cgi?id=2332734","tags":["issue-tracking","x_refsource_REDHAT","report","web"]},{"url":"https://discuss.tryton.org/t/security-release-for-issue-93/7889/3","tags":["web"]},{"url":"https://lists.debian.org/debian-lts-announce/2024/10/msg00023.html","tags":["web"]},{"url":"https://nvd.nist.gov/vuln/detail/CVE-2024-9774","tags":["advisory"]},{"url":"https://bugs.tryton.org/python-sql/93","tags":["web"]},{"url":"https://discuss.tryton.org/t/security-release-for-issue-93/7889","tags":["web"]},{"url":"https://foss.heptapod.net/tryton/python-sql/-/commit/f20551bbb8b3b4c4dd0a2c3d36f377bff6f2f349","tags":["web"]},{"url":"https://github.com/advisories/GHSA-pq9p-pc3p-9hm4","tags":["advisory"]},{"url":"https://security-tracker.debian.org/tracker/CVE-2024-9774","tags":["advisory"]},{"url":"https://github.com/tryton/python-sql","tags":["package"]},{"url":"https://pypi.org/project/python-sql","tags":["package"]},{"url":"https://ubuntu.com/security/CVE-2024-9774","tags":["report"]},{"url":"https://www.cve.org/CVERecord?id=CVE-2024-9774","tags":["report"]},{"url":"https://discuss.tryton.org/t/security-release-for-issue-93","tags":["report"]},{"url":"https://ubuntu.com/security/notices/USN-8765-1","tags":["advisory"]},{"url":"https://lists.opensuse.org/archives/list/security-announce@lists.opensuse.org/thread/NH7RQ74KYYNIEITRLT3RX22PYBPURFLV/","tags":["advisory"]},{"url":"https://bugzilla.suse.com/1234653","tags":["report"]},{"url":"https://www.suse.com/security/cve/CVE-2024-9774","tags":["web"]},{"url":"https://lists.opensuse.org/archives/list/security-announce@lists.opensuse.org/thread/BL6XAG7UX2MMKOTVXRICBTZ53LZDHEAG/","tags":["advisory"]}],"sources":{"cve":[{"id":"CVE-2024-9774","title":"Python-sql: python-sql unary operators does not escape non-expression","description":"A vulnerability was found in python-sql where unary operators do not escape non-Expression.","status":"published","published":"2024-12-27T02:00:12.451Z","modified":"2025-08-30T21:04:45.504Z","cvss":[{"version":"3.0","score":6.5,"vector":"CVSS:3.0/AV:N/AC:L/PR:H/UI:N/S:U/C:H/I:H/A:N","level":"medium","assessor":"cna"}],"cwes":["CWE-150"],"updated_at":"2026-11-02T14:34:06.147811Z"}],"euvd":[{"id":"EUVD-2024-3604","description":"A vulnerability was found in python-sql where unary operators do not escape non-Expression.","status":"published","published":"2024-12-27T02:00:12Z","modified":"2025-08-30T21:04:45Z","cvss":[{"version":"3.0","score":6.5,"vector":"CVSS:3.0/AV:N/AC:L/PR:H/UI:N/S:U/C:H/I:H/A:N","level":"medium"}],"updated_at":"2026-11-02T20:31:49.168932Z"}],"ghsa":[{"id":"GHSA-pq9p-pc3p-9hm4","title":"python-sql SQL injection vulnerability","description":"A vulnerability was found in python-sql where unary operators do not escape non-Expression (like `And` and `Or`) which makes any system exposing those vulnerable to an SQL injection attack.","status":"published","published":"2024-12-27T03:31:23Z","modified":"2025-02-07T06:31:14Z","cvss":[{"version":"3.0","score":6.5,"vector":"CVSS:3.0/AV:N/AC:L/PR:H/UI:N/S:U/C:H/I:H/A:N","level":"medium"}],"cwes":["CWE-150"],"updated_at":"2026-11-02T14:38:29.866763Z"}],"nvd":[{"id":"CVE-2024-9774","description":"A vulnerability was found in python-sql where unary operators do not escape non-Expression.","status":"published","published":"2024-12-27T02:15:07.33Z","modified":"2026-06-17T08:25:14.097Z","cvss":[{"version":"3.0","score":6.5,"vector":"CVSS:3.0/AV:N/AC:L/PR:H/UI:N/S:U/C:H/I:H/A:N","level":"medium","assessor":"secondary"}],"cwes":["CWE-150"],"updated_at":"2026-11-02T14:10:41.091507Z"}],"osv":[{"id":"DEBIAN-CVE-2024-9774","description":"A vulnerability was found in python-sql where unary operators do not escape non-Expression.","status":"published","published":"2024-12-27T02:15:07.33Z","modified":"2026-11-02T12:03:16.201759446Z","cvss":[{"version":"3.0","score":6.5,"vector":"CVSS:3.0/AV:N/AC:L/PR:H/UI:N/S:U/C:H/I:H/A:N","level":"medium"}],"updated_at":"2026-11-02T15:45:44.747956Z"},{"id":"GHSA-pq9p-pc3p-9hm4","title":"python-sql SQL injection vulnerability","description":"A vulnerability was found in python-sql where unary operators do not escape non-Expression (like `And` and `Or`) which makes any system exposing those vulnerable to an SQL injection attack.","status":"published","published":"2024-12-27T03:31:23Z","modified":"2026-07-07T17:57:06.428571832Z","cvss":[{"version":"3.0","score":6.5,"vector":"CVSS:3.0/AV:N/AC:L/PR:H/UI:N/S:U/C:H/I:H/A:N","level":"medium"}],"cwes":["CWE-150"],"updated_at":"2026-11-02T15:46:53.700556Z"},{"id":"PYSEC-2026-1855","title":"python-sql SQL injection vulnerability","description":"A vulnerability was found in python-sql where unary operators do not escape non-Expression (like `And` and `Or`) which makes any system exposing those vulnerable to an SQL injection attack.","status":"published","published":"2026-07-07T14:34:47.930521Z","modified":"2026-07-07T17:48:08.050310645Z","cvss":[{"version":"3.0","score":6.5,"vector":"CVSS:3.0/AV:N/AC:L/PR:H/UI:N/S:U/C:H/I:H/A:N","level":"medium"}],"updated_at":"2026-11-02T15:52:55.06457Z"},{"id":"UBUNTU-CVE-2024-9774","description":"A vulnerability was found in python-sql where unary operators do not escape non-Expression.","status":"published","published":"2024-12-27T02:15:00Z","modified":"2026-09-15T20:16:38.38734562Z","cvss":[{"version":"3.0","score":6.5,"vector":"CVSS:3.0/AV:N/AC:L/PR:H/UI:N/S:U/C:H/I:H/A:N","level":"medium"}],"updated_at":"2026-11-02T16:55:18.664792Z"},{"id":"CVE-2024-9774","description":"A vulnerability was found in python-sql where unary operators do not escape non-Expression.","status":"published","published":"2024-12-27T02:15:07Z","modified":"2026-07-07T17:57:06.428571832Z","updated_at":"2026-11-02T15:44:45.712478Z"},{"id":"DLA-3932-1","title":"python-sql - security update","status":"published","published":"2024-10-22T00:00:00Z","modified":"2026-03-09T01:18:52.260558Z","updated_at":"2026-11-02T15:46:12.203458Z"},{"id":"DSA-5795-1","title":"python-sql - security update","status":"published","published":"2024-10-21T00:00:00Z","modified":"2026-03-09T02:09:21.176534Z","updated_at":"2026-11-02T15:46:17.892347Z"},{"id":"openSUSE-SU-2024:0412-1","title":"Security update for python-python-sql","description":"This update for python-python-sql fixes the following issues:\n\n- CVE-2024-9774: Fixed that unary operators does not escape non-Expression (boo#1234653).\n","status":"published","published":"2024-12-21T13:02:17Z","modified":"2026-02-04T04:09:32.243815Z","updated_at":"2026-11-02T16:58:33.135986Z"},{"id":"openSUSE-SU-2024:0413-1","title":"Security update for python-python-sql","description":"This update for python-python-sql fixes the following issues:\n\n- CVE-2024-9774: Fixed that unary operators does not escape non-Expression (boo#1234653).\n","status":"published","published":"2024-12-21T13:02:20Z","modified":"2026-02-04T03:11:16.321642Z","updated_at":"2026-11-02T16:58:33.135986Z"},{"id":"USN-8765-1","title":"python-sql vulnerability","description":"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.","status":"published","published":"2026-09-15T14:39:05Z","modified":"2026-09-16T02:57:28.459191491Z","updated_at":"2026-11-02T16:58:26.907654Z"}]}}