[Django] #33340: DatabaseCache backend doesn't quote all fields in queries

7 views
Skip to first unread message

Django

unread,
Dec 2, 2021, 7:25:44 PM12/2/21
to django-...@googlegroups.com
#33340: DatabaseCache backend doesn't quote all fields in queries
-----------------------------------------------+------------------------
Reporter: Tim Graham | Owner: nobody
Type: Bug | Status: new
Component: Core (Cache system) | Version: dev
Severity: Normal | Keywords:
Triage Stage: Unreviewed | Has patch: 0
Needs documentation: 0 | Needs tests: 0
Patch needs improvement: 0 | Easy pickings: 0
UI/UX: 0 |
-----------------------------------------------+------------------------
Snowflake requires all fields to be quoted, otherwise they're treated as
uppercase.

The attached patch works with stable/3.2.x, but I'll have to review it
once [https://github.com/cedar-team/django-snowflake django-snowflake]
development is caught up to Django's main branch.

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

Django

unread,
Dec 2, 2021, 7:26:16 PM12/2/21
to django-...@googlegroups.com
#33340: DatabaseCache backend doesn't quote all fields in queries
-------------------------------------+-------------------------------------

Reporter: Tim Graham | Owner: nobody
Type: Bug | Status: new
Component: Core (Cache system) | Version: dev
Severity: Normal | Resolution:

Keywords: | Triage Stage:
| Unreviewed
Has patch: 0 | Needs documentation: 0
Needs tests: 0 | Patch needs improvement: 0
Easy pickings: 0 | UI/UX: 0
-------------------------------------+-------------------------------------
Changes (by Tim Graham):

* Attachment "33340.diff" added.

Django

unread,
Dec 3, 2021, 12:09:09 AM12/3/21
to django-...@googlegroups.com
#33340: DatabaseCache backend doesn't quote all fields in queries
-------------------------------------+------------------------------------

Reporter: Tim Graham | Owner: nobody
Type: Bug | Status: new
Component: Core (Cache system) | Version: dev
Severity: Normal | Resolution:
Keywords: | Triage Stage: Accepted

Has patch: 0 | Needs documentation: 0
Needs tests: 0 | Patch needs improvement: 0
Easy pickings: 1 | UI/UX: 0
-------------------------------------+------------------------------------
Changes (by Mariusz Felisiak):

* easy: 0 => 1
* stage: Unreviewed => Accepted


Comment:

Thanks for the report.

--
Ticket URL: <https://code.djangoproject.com/ticket/33340#comment:1>

Django

unread,
Dec 3, 2021, 5:49:14 PM12/3/21
to django-...@googlegroups.com
#33340: DatabaseCache backend doesn't quote all fields in queries
-------------------------------------+-------------------------------------
Reporter: Tim Graham | Owner: Arsalan
| Ghassemi
Type: Bug | Status: assigned

Component: Core (Cache system) | Version: dev
Severity: Normal | Resolution:
Keywords: | Triage Stage: Accepted
Has patch: 0 | Needs documentation: 0
Needs tests: 0 | Patch needs improvement: 0
Easy pickings: 1 | UI/UX: 0
-------------------------------------+-------------------------------------
Changes (by Arsalan Ghassemi):

* owner: nobody => Arsalan Ghassemi
* status: new => assigned


Comment:

Hello, I'm working on a patch for this ticket, the topic branch :
https://github.com/ArsaCode/django/tree/ticket_33340

--
Ticket URL: <https://code.djangoproject.com/ticket/33340#comment:2>

Django

unread,
Dec 8, 2021, 8:05:07 PM12/8/21
to django-...@googlegroups.com
#33340: DatabaseCache backend doesn't quote all fields in queries
-------------------------------------+-------------------------------------
Reporter: Tim Graham | Owner: Arsalan
| Ghassemi
Type: Bug | Status: assigned
Component: Core (Cache system) | Version: dev
Severity: Normal | Resolution:
Keywords: | Triage Stage: Accepted
Has patch: 1 | Needs documentation: 0

Needs tests: 0 | Patch needs improvement: 0
Easy pickings: 1 | UI/UX: 0
-------------------------------------+-------------------------------------
Changes (by Arsalan Ghassemi):

* has_patch: 0 => 1


Comment:

Hi,

I opened a PR for this issue : https://github.com/django/django/pull/15166

--
Ticket URL: <https://code.djangoproject.com/ticket/33340#comment:3>

Django

unread,
Dec 9, 2021, 1:43:33 AM12/9/21
to django-...@googlegroups.com
#33340: DatabaseCache backend doesn't quote all fields in queries
-------------------------------------+-------------------------------------
Reporter: Tim Graham | Owner: Arsalan
| Ghassemi
Type: Bug | Status: assigned
Component: Core (Cache system) | Version: dev
Severity: Normal | Resolution:
Keywords: | Triage Stage: Accepted
Has patch: 1 | Needs documentation: 0
Needs tests: 0 | Patch needs improvement: 1

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

* needs_better_patch: 0 => 1


--
Ticket URL: <https://code.djangoproject.com/ticket/33340#comment:4>

Django

unread,
Dec 9, 2021, 5:18:32 AM12/9/21
to django-...@googlegroups.com
#33340: DatabaseCache backend doesn't quote all fields in queries
-------------------------------------+-------------------------------------
Reporter: Tim Graham | Owner: Arsalan
| Ghassemi
Type: Bug | Status: assigned
Component: Core (Cache system) | Version: dev
Severity: Normal | Resolution:
Keywords: | Triage Stage: Ready for
| checkin
Has patch: 1 | Needs documentation: 0

Needs tests: 0 | Patch needs improvement: 0
Easy pickings: 1 | UI/UX: 0
-------------------------------------+-------------------------------------
Changes (by Mariusz Felisiak):

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


--
Ticket URL: <https://code.djangoproject.com/ticket/33340#comment:5>

Django

unread,
Dec 9, 2021, 2:23:30 PM12/9/21
to django-...@googlegroups.com
#33340: DatabaseCache backend doesn't quote all fields in queries
-------------------------------------+-------------------------------------
Reporter: Tim Graham | Owner: Arsalan
| Ghassemi
Type: Bug | Status: closed

Component: Core (Cache system) | Version: dev
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: 1 | UI/UX: 0
-------------------------------------+-------------------------------------
Changes (by Mariusz Felisiak <felisiak.mariusz@…>):

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


Comment:

In [changeset:"17df72114e222d63c2af9ed9780583f4cb0689eb" 17df7211]:
{{{
#!CommitTicketReference repository=""
revision="17df72114e222d63c2af9ed9780583f4cb0689eb"
Fixed #33340 -- Fixed unquoted column names in queries used by
DatabaseCache.
}}}

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

Reply all
Reply to author
Forward
0 new messages