CVE-2024-42005:django: SQL injection
A reconstruction of the flaw, and the evidence path Lachesis follows to make it visible.
A QuerySet.values()/values_list() over a JSONField with a crafted JSON object key used as an alias.
That is the shape of the failure. The rest of this case file follows the evidence behind it.
What was known.
What Lachesis established.
Known before Lachesis ran
The CVE and vulnerable release were selected from public history. We are not claiming novel discovery.
- CVE
- CVE-2024-42005
- Vulnerable target
- 4.2.13 (affected: >=4.2 <4.2.15, >=5.0 <5.0.8) · vulnerable
- Prior knowledge
- CVE-2024-42005 · 4.2.13 (affected: >=4.2 <4.2.15, >=5.0 <5.0.8) is vulnerable
Independent re-detection
The experiment graph was built around the vulnerable release, enriched (pass2 dataflow + atropos bind + pass3 semantic), then enumerated BLIND over the whole constructor registry (no family hard-coded, no target line seeded). The lead below is the class-matched candidate the enumerator surfaced on its own; the provenance and body reads are the tool's own follow-up operations. Prose in `adjudication`/`trace` is MY reading of the verbatim source + official fix, clearly separated from tool output.
- Seeded inputs
- None
- Run timestamp
- 2026-08-29T00:00:00Z
- Evidence artifact
- cve-2024-42005.kuzu (built from the vulnerable release, enriched pass2+pass3; graph + sidecars deleted after capture)
The commands and outputs below come from this recorded Lachesis run.
What Lachesis reconstructed.
One historical repository. Four captured queries. A complete source-to-sink argument.
Lachesis follows the same evidence path through unfamiliar repositories.
Here is how the path becomes visible.
These are the recorded questions Lachesis asked of the historical vulnerable code, followed by the raw result and source location each query returned.
Captured runA real replay of Lachesis over the graph we built for this case. Every `output` below is verbatim captured tool text; the graph was built bounded (hard memory/time cap) and released immediately after capture, so nothing accumulates.
Load the graph and list every bug family
Load the graph built from the vulnerable release and list every bug family the blind enumerator knows -- no family is pre-selected.
{"move": "load_graph", "graph": "/Users/riyandhiman/.claude/jobs/12d61190/tmp/hr/cve-2024-42005.kuzu", "profile": "all", "nodes": 211769}
CANDIDATE_CENSUS
move: candidate_census
taxonomy (8):
domain=lifecycle title=Resource lifecycle meaning=an operation that acquires, releases, uses, or transfers a tracked resource obligation=resource operations stay within the object's lifetime primary=True languages=['c', 'python', 'javascript', 'typescript'] enumerable=True families=[{'family': 'acquire', 'obligation': 'resource acquisition', 'constructor': 'lifecycle.acquire', 'enumerable': True}, {'family': 'release', 'obligation': 'resource release', 'constructor': 'lifecycle.release', 'enumerable': True}, {'family': 'use', 'obligation': 'tracked resource use', 'constructor': 'lifecycle.use', 'enumerable': True}, {'family': 'escape', 'obligation': 'resource ownership transfer', 'constructor': 'lifecycle.escape', 'enumerable': True}, {'family': 'leak', 'obligation': 'Allocated object remains live at an exit', 'constructor'
... [truncated]A small line with a large consequence.
cursor.execute enforces no escaping on the SQL string it receives; the escaping obligation must be met upstream when the column alias is composed
self.cursor.execute(self.sql, params)
// 4.2.15 adds a check_alias(field) validation loop in Query.set_values (query.py:~2411) so a JSONField-key-derived alias is rejected before it enters the SQL
The original record.
Read the historical advisory and vulnerability record behind this reconstruction.