django.git/django/db/models/fields/json.py, branch 6.0.3

[6.0.x] Fixed #36612 -- Fixed a KeyTextTransform crash on MySQL against annotations.

2025-09-22T07:02:01Z

MySQL only supports the ->> when used directly against columns, this can be inferred by the presence of lhs.output_field.model as model bounds fields are directly tied to columns. Purposely don't systematically switch to using JSON_QUOTE(JSON_EXTRACT(...)) as there might be functional indices out there that rely on the SQL remaining stable between versions. Thanks Jacob Tavener for the report. Backport of af84cfba5970fda8306860b650937701c7c03c6f from main.

Refs #36085 -- Moved compile_json_path to BaseDatabaseOperations.

2025-05-14T11:21:18Z

Refs #28909 -- Simplified code using unpacking generalizations.

2025-04-01T01:43:13Z

Fixed #35167 -- Delegated to super() in JSONField.get_db_prep_save().

2025-02-18T16:28:24Z

Avoids reports of bulk_update() sending Cast expressions to JSONField.get_prep_value(). Co-authored-by: Simon Charette

Fixed CVE-2024-53908 -- Prevented SQL injections in direct HasKeyLookup usage on Oracle.

2024-12-04T12:43:13Z

Thanks Seokchan Yoon for the report, and Mariusz Felisiak and Sarah Boyce for the reviews.

Refs #35842 -- Fixed handling of quotes in JSONField key lookups on Oracle.

2024-12-03T10:19:55Z

Refs #34060 -- Fixed JSONField __exact lookup for primitivies on Oracle 21c+.

2024-02-19T07:28:42Z

Regression in c991602ce5798385261381025c06698d7fd30dc5. Co-Authored-By: Mariusz Felisiak

Fixed #34060 -- Fixed migrations crash when adding check constraints with JSONField __exact lookup on Oracle.

2024-02-15T12:57:58Z

Fixed #34769 -- Fixed key transforms on Oracle 21c+.

2024-01-10T20:00:42Z

Oracle 21c introduced support for primivites in JSON fields that caused changes in handling them by JSON_QUERY/JSON_VALUE functions.

Refs #33308 -- Removed support for passing encoded JSON string literals to JSONField & co.

2023-09-18T20:12:40Z

Per deprecation timeline.