CVE-2024-9774

Python-sql: python-sql unary operators does not escape non-expression

6.5 MediumFix available

A vulnerability was found in python-sql where unary operators do not escape non-Expression.

Attack profile

How easy it is to exploit

Attack vector: Network
Complexity: Low
Privileges needed: High
User interaction: None

What an attacker can affect

Confidentiality: High
Integrity: High
Availability: None

Exploit likelihood

0.68%Up 0.6 points since Dec 27, 2024

What each source reports

CVE List Score used 6.5

Python-sql: python-sql unary operators does not escape non-expression

A vulnerability was found in python-sql where unary operators do not escape non-Expression.

Record: CVE-2024-9774
CVSS 3.0: 6.5 MediumCVSS:3.0/AV:N/AC:L/PR:H/UI:N/S:U/C:H/I:H/A:N
Weakness: CWE-150
Updated: 2026-11-02

EUVDEUVD-2024-3604 6.5

A vulnerability was found in python-sql where unary operators do not escape non-Expression.

Record: EUVD-2024-3604
CVSS 3.0: 6.5 MediumCVSS:3.0/AV:N/AC:L/PR:H/UI:N/S:U/C:H/I:H/A:N
Updated: 2026-11-02

GitHub AdvisoriesGHSA-pq9p-pc3p-9hm4 6.5

python-sql SQL injection vulnerability

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.

Record: GHSA-pq9p-pc3p-9hm4
CVSS 3.0: 6.5 MediumCVSS:3.0/AV:N/AC:L/PR:H/UI:N/S:U/C:H/I:H/A:N
Weakness: CWE-150
Updated: 2026-11-02

NVD 6.5

A vulnerability was found in python-sql where unary operators do not escape non-Expression.

Record: CVE-2024-9774
CVSS 3.0: 6.5 MediumCVSS:3.0/AV:N/AC:L/PR:H/UI:N/S:U/C:H/I:H/A:N
Weakness: CWE-150
Updated: 2026-11-02

OSVDEBIAN-CVE-2024-9774 6.5

A vulnerability was found in python-sql where unary operators do not escape non-Expression.

Record: DEBIAN-CVE-2024-9774
CVSS 3.0: 6.5 MediumCVSS:3.0/AV:N/AC:L/PR:H/UI:N/S:U/C:H/I:H/A:N
Updated: 2026-11-02

OSVGHSA-pq9p-pc3p-9hm4 6.5

python-sql SQL injection vulnerability

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.

Record: GHSA-pq9p-pc3p-9hm4
CVSS 3.0: 6.5 MediumCVSS:3.0/AV:N/AC:L/PR:H/UI:N/S:U/C:H/I:H/A:N
Weakness: CWE-150
Updated: 2026-11-02

Show 6 moreShow less

OSVPYSEC-2026-1855 6.5

python-sql SQL injection vulnerability

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.

Record: PYSEC-2026-1855
CVSS 3.0: 6.5 MediumCVSS:3.0/AV:N/AC:L/PR:H/UI:N/S:U/C:H/I:H/A:N
Updated: 2026-11-02

OSVUBUNTU-CVE-2024-9774 6.5

A vulnerability was found in python-sql where unary operators do not escape non-Expression.

Record: UBUNTU-CVE-2024-9774
CVSS 3.0: 6.5 MediumCVSS:3.0/AV:N/AC:L/PR:H/UI:N/S:U/C:H/I:H/A:N
Updated: 2026-11-02

OSV No score

A vulnerability was found in python-sql where unary operators do not escape non-Expression.

Record: CVE-2024-9774
Updated: 2026-11-02

OSVopenSUSE-SU-2024:0412-1 No score

Security update for python-python-sql

This update for python-python-sql fixes the following issues:

CVE-2024-9774: Fixed that unary operators does not escape non-Expression (boo#1234653).

Record: openSUSE-SU-2024:0412-1
Updated: 2026-11-02

OSVopenSUSE-SU-2024:0413-1 No score

Security update for python-python-sql

This update for python-python-sql fixes the following issues:

CVE-2024-9774: Fixed that unary operators does not escape non-Expression (boo#1234653).

Record: openSUSE-SU-2024:0413-1
Updated: 2026-11-02

OSVUSN-8765-1 No score

python-sql vulnerability

Cédric Krier discovered that python-sql incorrectly escaped values passed to unary operators. An attacker could possibly use this issue to perform SQL injection attacks.

Record: USN-8765-1
Updated: 2026-11-02

Affected packages

Affected packages
Package	Affected	Fixed
`python-sql` PyPI	before 1.5.2	1.5.2
`python-sql` Debian:12	before 1.4.0-1+deb12u1, plus listed versions 1.4.0-1	1.4.0-1+deb12u1
`python-sql` Debian:13	before 1.5.2-1	1.5.2-1
`python-sql` Debian:14	before 1.5.2-1	1.5.2-1
`python-sql` Debian:11	before 1.2.1-1+deb11u1, plus listed versions 1.2.1-1	1.2.1-1+deb11u1
`python-sql` PyPI	before 1.5.2, plus listed versions 0.10.20.30.40.5 Show 16 moreShow less 0.60.70.80.91.0.01.1.01.2.01.2.11.2.21.3.01.4.01.4.11.4.21.4.31.5.01.5.1	1.5.2
`python-sql` Ubuntu:Pro:16.04:LTS	before 0.8-1ubuntu0.1~esm1, plus listed versions 0.7-10.8-1	0.8-1ubuntu0.1~esm1
`python-sql` Ubuntu:Pro:18.04:LTS	before 0.9-1ubuntu0.1~esm1, plus listed versions 0.9-1	0.9-1ubuntu0.1~esm1
`python-sql` Ubuntu:Pro:20.04:LTS	before 1.1.0-1ubuntu0.1~esm1, plus listed versions 1.0.0-11.0.0-21.1.0-1	1.1.0-1ubuntu0.1~esm1
`python-sql` Ubuntu:Pro:22.04:LTS	before 1.3.0-1ubuntu0.1~esm1, plus listed versions 1.2.1-11.3.0-1	1.3.0-1ubuntu0.1~esm1

Show 5 moreShow less

Affected packages
Package	Affected	Fixed
`python-sql` Ubuntu:24.04:LTS	before 1.4.0-1+deb12u1build0.24.04.1, plus listed versions 1.4.0-1	1.4.0-1+deb12u1build0.24.04.1
`python-python-sql` SUSE:Package Hub 15 SP5	before 1.5.1-bp155.3.6.1	1.5.1-bp155.3.6.1
`python-python-sql` openSUSE:Leap 15.5	before 1.5.1-bp155.3.6.1	1.5.1-bp155.3.6.1
`python-python-sql` SUSE:Package Hub 15 SP6	before 1.5.1-bp156.2.6.1	1.5.1-bp156.2.6.1
`python-python-sql` openSUSE:Leap 15.6	before 1.5.1-bp156.2.6.1	1.5.1-bp156.2.6.1

History

History
Recorded	Changed	Sources
Nov 2, 2026	first indexed	CVE List, EUVD, GitHub Advisories, NVD, OSV

Dates are when Every CVE recorded each change. Upstream dates may differ.

In short

CVE-2024-9774 is a medium vulnerability (CVSS 6.5) in python-sql, published October 21, 2024. No source lists public exploit code. EPSS puts the chance of exploitation in the next 30 days at 0.68%, the 52nd percentile. Fixed in python-sql 1.5.2.

References

Show 14 moreShow less