[Django] #34769: JSONField key/path transforms tests fail on Oracle 21c.
Django
-------------------------------------+-------------------------------------
Reporter: Mariusz | Owner: nobody
Felisiak |
Type: Bug | Status: new
Component: Database | Version: 4.2
layer (models, ORM) | Keywords: oracle json
Severity: Normal | jsonfield
Triage Stage: | Has patch: 0
Unreviewed |
Needs documentation: 0 | Needs tests: 0
Patch needs improvement: 0 | Easy pickings: 0
UI/UX: 0 |
-------------------------------------+-------------------------------------
Oracle 21c has made significant changes in `JSON` implementation, e.g.
added new `JSON` data type, check out
[https://docs.oracle.com/en/database/oracle/oracle-database/21/nfcon
/application-development.html#GUID-A44ED5C3-5419-49D5-B5D9-263B53F51C4D
release notes]. Currently 22 `model_fields.test_jsonfield` tests fail on
Oracle 21c+:
--
Ticket URL: <https://code.djangoproject.com/ticket/34769>
Django <https://code.djangoproject.com/>
The Web framework for perfectionists with deadlines.
Django
-------------------------------------+-------------------------------------
Type: Bug | Status: new
Component: Database layer | Version: 4.2
(models, ORM) |
Severity: Normal | Resolution:
Keywords: oracle json | Triage Stage:
jsonfield | Unreviewed
Has patch: 0 | Needs documentation: 0
Needs tests: 0 | Patch needs improvement: 0
Easy pickings: 0 | UI/UX: 0
-------------------------------------+-------------------------------------
* Attachment "logs" added.
Django
-------------------------------------+-------------------------------------
Reporter: Mariusz Felisiak | Owner: nobody
Type: Bug | Status: new
Component: Database layer | Version: 4.2
(models, ORM) |
Severity: Normal | Resolution:
Keywords: oracle json | Triage Stage:
jsonfield | Unreviewed
Has patch: 0 | Needs documentation: 0
Needs tests: 0 | Patch needs improvement: 0
Easy pickings: 0 | UI/UX: 0
-------------------------------------+-------------------------------------
Old description:
> Oracle 21c has made significant changes in `JSON` implementation, e.g.
> added new `JSON` data type, check out
> [https://docs.oracle.com/en/database/oracle/oracle-database/21/nfcon
> /application-development.html#GUID-A44ED5C3-5419-49D5-B5D9-263B53F51C4D
> release notes]. Currently 22 `model_fields.test_jsonfield` tests fail on
> Oracle 21c+:
New description:
Oracle 21c has made significant changes in `JSON` implementation, e.g.
added new `JSON` data type, check out
[https://docs.oracle.com/en/database/oracle/oracle-database/21/nfcon
/application-development.html#GUID-A44ED5C3-5419-49D5-B5D9-263B53F51C4D
release notes]. Currently 22 `model_fields.test_jsonfield` tests fail on
Oracle 21c+, check out
[https://code.djangoproject.com/attachment/ticket/34769/logs logs].
--
--
Ticket URL: <https://code.djangoproject.com/ticket/34769#comment:1>
Django
-------------------------------------+-------------------------------------
Reporter: Mariusz Felisiak | Owner: nobody
Type: Bug | Status: new
Component: Database layer | Version: 4.2
(models, ORM) |
Severity: Normal | Resolution:
jsonfield |
Has patch: 0 | Needs documentation: 0
Needs tests: 0 | Patch needs improvement: 0
Easy pickings: 0 | UI/UX: 0
-------------------------------------+-------------------------------------
* stage: Unreviewed => Accepted
Comment:
Mariusz, shall we mark this as release blocker for 5.0?
--
Ticket URL: <https://code.djangoproject.com/ticket/34769#comment:2>
Django
-------------------------------------+-------------------------------------
Reporter: Mariusz Felisiak | Owner: nobody
Type: Bug | Status: new
Component: Database layer | Version: 4.2
(models, ORM) |
Severity: Normal | Resolution:
Keywords: oracle json | Triage Stage: Accepted
jsonfield |
Has patch: 0 | Needs documentation: 0
Needs tests: 0 | Patch needs improvement: 0
Easy pickings: 0 | UI/UX: 0
-------------------------------------+-------------------------------------
Comment (by Mariusz Felisiak):
Replying to [comment:2 Natalia Bidart]:
> Mariusz, shall we mark this as release blocker for 5.0?
No, it's not a regression or a bug in the new feature.
--
Ticket URL: <https://code.djangoproject.com/ticket/34769#comment:3>
Django
-------------------------------------+-------------------------------------
| Felisiak
Type: Bug | Status: assigned
Component: Database layer | Version: 4.2
(models, ORM) |
Severity: Normal | Resolution:
Keywords: oracle json | Triage Stage: Accepted
jsonfield |
Has patch: 0 | Needs documentation: 0
Needs tests: 0 | Patch needs improvement: 0
Easy pickings: 0 | UI/UX: 0
-------------------------------------+-------------------------------------
* owner: nobody => Mariusz Felisiak
* status: new => assigned
Comment:
I'm finally figured out how to fix this.
--
Ticket URL: <https://code.djangoproject.com/ticket/34769#comment:4>
Django
-------------------------------------+-------------------------------------
Reporter: Mariusz Felisiak | Owner: Mariusz
| Felisiak
Type: Bug | Status: assigned
Component: Database layer | Version: 4.2
(models, ORM) |
Severity: Normal | Resolution:
Keywords: oracle json | Triage Stage: Accepted
jsonfield |
Needs tests: 0 | Patch needs improvement: 0
Easy pickings: 0 | UI/UX: 0
-------------------------------------+-------------------------------------
Changes (by Mariusz Felisiak):
* has_patch: 0 => 1
Comment:
[https://github.com/django/django/pull/17717 PR]
--
Ticket URL: <https://code.djangoproject.com/ticket/34769#comment:5>
Django
-------------------------------------+-------------------------------------
Reporter: Mariusz Felisiak | Owner: Mariusz
| Felisiak
Component: Database layer | Version: 4.2
(models, ORM) |
Keywords: oracle json | Triage Stage: Accepted
jsonfield |
Has patch: 1 | Needs documentation: 0
Needs tests: 0 | Patch needs improvement: 0
Easy pickings: 0 | UI/UX: 0
-------------------------------------+-------------------------------------
* status: assigned => closed
* resolution: => fixed
Comment:
In [changeset:"8d2c16252e78a0fae2356ead3a7b3f879a653046" 8d2c162]:
{{{
#!CommitTicketReference repository=""
revision="8d2c16252e78a0fae2356ead3a7b3f879a653046"
Fixed #34769 -- Fixed key transforms on Oracle 21c+.
Oracle 21c introduced support for primivites in JSON fields that
caused changes in handling them by JSON_QUERY/JSON_VALUE functions.
}}}
--
Ticket URL: <https://code.djangoproject.com/ticket/34769#comment:6>