Re: [Django] #33552: has_key, has_keys, and has_any_keys JSONField() lookups don't handle numeric keys on SQLite, MySQL, and Oracle.

4 views
Skip to first unread message

Django

unread,
Mar 12, 2022, 1:25:09 AM3/12/22
to django-...@googlegroups.com
#33552: has_key, has_keys, and has_any_keys JSONField() lookups don't handle
numeric keys on SQLite, MySQL, and Oracle.
-------------------------------------+-------------------------------------
Reporter: TheTerrasque | Owner: Sage
| Abdullah
Type: Bug | Status: assigned
Component: Database layer | Version: 4.0
(models, ORM) |
Severity: Normal | Resolution:
Keywords: | Triage Stage: Accepted
Has patch: 1 | Needs documentation: 0
Needs tests: 0 | Patch needs improvement: 0
Easy pickings: 0 | UI/UX: 0
-------------------------------------+-------------------------------------
Changes (by Sage Abdullah):

* owner: nobody => Sage Abdullah
* status: new => assigned
* has_patch: 0 => 1


Comment:

[https://github.com/django/django/pull/15503 PR]

--
Ticket URL: <https://code.djangoproject.com/ticket/33552#comment:5>
Django <https://code.djangoproject.com/>
The Web framework for perfectionists with deadlines.

Django

unread,
Mar 14, 2022, 2:26:29 AM3/14/22
to django-...@googlegroups.com
#33552: has_key, has_keys, and has_any_keys JSONField() lookups don't handle
numeric keys on SQLite, MySQL, and Oracle.
-------------------------------------+-------------------------------------
Reporter: TheTerrasque | Owner: Sage
| Abdullah
Type: Bug | Status: assigned
Component: Database layer | Version: 4.0
(models, ORM) |
Severity: Normal | Resolution:
Keywords: | Triage Stage: Accepted
Has patch: 1 | Needs documentation: 0
Needs tests: 0 | Patch needs improvement: 1

Easy pickings: 0 | UI/UX: 0
-------------------------------------+-------------------------------------
Changes (by Mariusz Felisiak):

* needs_better_patch: 0 => 1


--
Ticket URL: <https://code.djangoproject.com/ticket/33552#comment:6>

Django

unread,
Mar 15, 2022, 1:51:32 AM3/15/22
to django-...@googlegroups.com
#33552: has_key, has_keys, and has_any_keys JSONField() lookups don't handle
numeric keys on SQLite, MySQL, and Oracle.
-------------------------------------+-------------------------------------
Reporter: TheTerrasque | Owner: Sage
| Abdullah
Type: Bug | Status: assigned
Component: Database layer | Version: 4.0
(models, ORM) |
Severity: Normal | Resolution:
Keywords: | Triage Stage: Ready for
| checkin

Has patch: 1 | Needs documentation: 0
Needs tests: 0 | Patch needs improvement: 0

Easy pickings: 0 | UI/UX: 0
-------------------------------------+-------------------------------------
Changes (by Mariusz Felisiak):

* needs_better_patch: 1 => 0
* stage: Accepted => Ready for checkin


--
Ticket URL: <https://code.djangoproject.com/ticket/33552#comment:7>

Django

unread,
Mar 15, 2022, 4:03:01 AM3/15/22
to django-...@googlegroups.com
#33552: has_key, has_keys, and has_any_keys JSONField() lookups don't handle
numeric keys on SQLite, MySQL, and Oracle.
-------------------------------------+-------------------------------------
Reporter: TheTerrasque | Owner: Sage
| Abdullah
Type: Bug | Status: closed

Component: Database layer | Version: 4.0
(models, ORM) |
Severity: Normal | Resolution: fixed

Keywords: | Triage Stage: Ready for
| checkin
Has patch: 1 | Needs documentation: 0
Needs tests: 0 | Patch needs improvement: 0
Easy pickings: 0 | UI/UX: 0
-------------------------------------+-------------------------------------
Changes (by Mariusz Felisiak <felisiak.mariusz@…>):

* status: assigned => closed
* resolution: => fixed


Comment:

In [changeset:"a88fab1bca33c037bd1a12459c215d7bc1247735" a88fab1]:
{{{
#!CommitTicketReference repository=""
revision="a88fab1bca33c037bd1a12459c215d7bc1247735"
Fixed #33552 -- Fixed JSONField has key lookups with numeric keys on
MariaDB, MySQL, Oracle, and SQLite.
}}}

--
Ticket URL: <https://code.djangoproject.com/ticket/33552#comment:8>

Reply all
Reply to author
Forward
0 new messages