CVE-2024-9774 json
Python-sql: python-sql unary operators does not escape non-expression
published 2024-12-27 22 mo ago modified 2026-07-07 4 mo ago also GHSA-pq9p-pc3p-9hm4 , PYSEC-2026-1855 , EUVD-2024-3604
- cvss
- 6.5
- version 3.0, CNA
- cisa kev
- Not listed
- not in CISA's catalog
- epss
- 0.7%
- EPSS 0.7% chance of exploitation in 30 days, percentile 52%
- public exploits
- 0
- none known
Summary
A vulnerability was found in python-sql where unary operators do not escape non-Expression.
Patch / fix
- pypi python-sql 1.5.2
- python-sql Debian 12 1.4.0-1+deb12u1
- python-sql Debian 14, Debian 13 1.5.2-1
debian advisories DEBIAN-CVE-2024-9774
- python-sql Ubuntu 24.04 LTS 1.4.0-1+deb12u1build0.24.04.1
- python-sql Ubuntu Pro 16.04 LTS 0.8-1ubuntu0.1~esm1
- python-sql Ubuntu Pro 18.04 LTS 0.9-1ubuntu0.1~esm1
- python-sql Ubuntu Pro 20.04 LTS 1.1.0-1ubuntu0.1~esm1
- python-sql Ubuntu Pro 22.04 LTS 1.3.0-1ubuntu0.1~esm1
ubuntu advisories UBUNTU-CVE-2024-9774
Ubuntu security data © Canonical Ltd., from https://github.com/canonical/ubuntu-security-notices via OSV; changed: normalised to fixed package versions per release. CC BY-SA 4.0
- python-python-sql Package Hub 15 SP6, openSUSE Leap 15.6 1.5.1-bp156.2.6.1
- python-python-sql Package Hub 15 SP5, openSUSE Leap 15.5 1.5.1-bp155.3.6.1
opensuse advisories openSUSE-SU-2024:0413-1openSUSE-SU-2024:0412-1
Vendor advisories
What the vendors themselves say about their products: affected, fixed or not affected, and what to do.
red hat product security vex CVE-2024-9774 updated cvss 6.5
python-sql: python-sql Unary operators does not escape non-Expression
-
Red Hat All currently supported Red Hat productsnot affected: vulnerable code not present
Red Hat CSAF VEX © Red Hat, Inc., from https://security.access.redhat.com/data/csaf/v2/vex/; changed: reduced to product statuses and remediations. CC BY 4.0 · csaf
CISA SSVC
- Exploitation
- none
- Automatable
- no
- Technical impact
- total
- Assessed
- 22 mo ago
Exploit prediction
0.68% chance of exploitation in the next 30 days, higher than 52% of all scored CVEs (FIRST EPSS, 2026-11-08).
CVSS scores
| assigned by | version | score | vector |
|---|---|---|---|
| CNA | 3.0 | 6.5 | CVSS:3.0/AV:N/AC:L/PR:H/UI:N/S:U/C:H/I:H/A:N |
| GitHub | 3.0 | 6.5 | CVSS:3.0/AV:N/AC:L/PR:H/UI:N/S:U/C:H/I:H/A:N |
| OSV | 3.0 | 6.5 | CVSS:3.0/AV:N/AC:L/PR:H/UI:N/S:U/C:H/I:H/A:N |
Affected packages
| ecosystem | package | affected | fixed in |
|---|---|---|---|
| pypi | python-sql | <1.5.2 |
1.5.2 |
Classification
- Weakness
-
- CWE-150 Improper Neutralization of Escape, Meta, or Control Sequences
References
-
foss.heptapod.net
/tryton/python-sql/-/commit/f20551bbb8b3b4c4dd0a2c3d36f377bff6f2f349
web
-
access.redhat.com
/security/cve/CVE-2024-9774
vdb-entry, web
-
bugzilla.redhat.com
/show_bug.cgi?id=2332734
issue-tracking, web
-
discuss.tryton.org
/t/security-release-for-issue-93/7889/3
web
-
lists.debian.org
/debian-lts-announce/2024/10/msg00023.html
web
-
nvd.nist.gov
/vuln/detail/CVE-2024-9774
advisory
-
bugs.tryton.org
/python-sql/93
web
-
discuss.tryton.org
/t/security-release-for-issue-93/7889
web
-
github.com
/tryton/python-sql
package
-
pypi.org
/project/python-sql
package
-
github.com
/advisories/GHSA-pq9p-pc3p-9hm4
advisory
Sources
- CVE List CVE-2024-9774
- GitHub Advisory GHSA-pq9p-pc3p-9hm4
- NVD CVE-2024-9774
- OSV PYSEC-2026-1855
Fencer Vulns keeps one entry per vulnerability: the CVE id wins, then GHSA, and records that alias each other are merged, except that two CVEs always keep separate entries. The same data is available as JSON.