summaryrefslogtreecommitdiff
path: root/docs
diff options
context:
space:
mode:
authorClifford Gama <cliffygamy@gmail.com>2025-11-21 12:20:12 +0200
committerGitHub <noreply@github.com>2025-11-21 11:20:12 +0100
commit7e4c4f43f51e829e6378a0305bfda81479a368ab (patch)
tree5d34ab8e2fe2151d4cd38ef10b679a40215eb2c8 /docs
parent8ce3e1f9d0cdfdcba91e7e544804fa33f6fa9177 (diff)
Fixed #36718 -- Added JSONField support for negative array indexing on Oracle 21c+.
Diffstat (limited to 'docs')
-rw-r--r--docs/releases/6.1.txt4
-rw-r--r--docs/topics/db/queries.txt6
2 files changed, 9 insertions, 1 deletions
diff --git a/docs/releases/6.1.txt b/docs/releases/6.1.txt
index 41b554bb5d..ed1855cac9 100644
--- a/docs/releases/6.1.txt
+++ b/docs/releases/6.1.txt
@@ -254,6 +254,10 @@ Models
<django.db.models.DecimalField.decimal_places>` are no longer required to be
set on Oracle, PostgreSQL, and SQLite.
+* :class:`~django.db.models.JSONField` now supports
+ :ref:`negative array indexing <key-index-and-path-transforms>` on Oracle
+ 21c+.
+
Pagination
~~~~~~~~~~
diff --git a/docs/topics/db/queries.txt b/docs/topics/db/queries.txt
index 0a63ffb553..4070ab9066 100644
--- a/docs/topics/db/queries.txt
+++ b/docs/topics/db/queries.txt
@@ -1184,7 +1184,7 @@ directly, but you can still use dictionary unpacking to use it in a query:
>>> Dog.objects.filter(**{"data__owner__other_pets__-1__name": "Fishy"})
<QuerySet [<Dog: Rufus>]>
-.. admonition:: MySQL, MariaDB, and Oracle
+.. admonition:: MySQL, MariaDB, and Oracle < 21c
Negative JSON array indices are not supported.
@@ -1192,6 +1192,10 @@ directly, but you can still use dictionary unpacking to use it in a query:
SQLite support for negative JSON array indices was added.
+.. versionchanged:: 6.1
+
+ Oracle 21c+ support for negative JSON array indices was added.
+
If the key you wish to query by clashes with the name of another lookup, use
the :lookup:`contains <jsonfield.contains>` lookup instead.