[Django] #29668: missing FROM-clause entry in subquery with extra

[Django]

#29668: missing FROM-clause entry in subquery with extra
-----------------------------------------+------------------------
Reporter: pranavneeraj | Owner: nobody
Type: Bug | Status: new
Component: Uncategorized | Version: 2.0
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 |
-----------------------------------------+------------------------
Turn.active_objects.all().select_related('request__address').extra(select={'start_time_tz':
'(start_time AT TIME ZONE COALESCE("api_address".timezone))'}).distinct()
Works but
Turn.active_objects.all().select_related('request__address').extra(select={'start_time_tz':
'(start_time AT TIME ZONE
COALESCE("api_address".timezone))'}).distinct().count() doesn't.

Because count executes subquery.

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

[Django]

#29668: missing FROM-clause entry in subquery with extra

-------------------------------+--------------------------------------

Reporter: pranavneeraj | Owner: nobody
Type: Bug | Status: new
Component: Uncategorized | Version: 2.0

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

-------------------------------+--------------------------------------

Comment (by pranavneeraj):

Version is 1.9.

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

[Django]

#29668: missing FROM-clause entry in subquery with extra

-------------------------------------+-------------------------------------

Reporter: pranavneeraj | Owner: nobody
Type: Bug | Status: new

Component: Database layer | Version: 2.0
(models, ORM) |
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 pranavneeraj):

* component: Uncategorized => Database layer (models, ORM)

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

[Django]

#29668: missing FROM-clause entry in subquery with extra

-------------------------------------+-------------------------------------

Reporter: pranavneeraj | Owner: nobody
Type: Bug | Status: new

Component: Database layer | Version: 2.0
(models, ORM) |

Severity: Release blocker | 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 pranavneeraj):

* severity: Normal => Release blocker

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

[Django]

#29668: missing FROM-clause entry in subquery with extra

-------------------------------------+-------------------------------------

Reporter: pranavneeraj | Owner: nobody
Type: Bug | Status: new

Component: Database layer | Version: 2.0
(models, ORM) |

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 felixxm):

* cc: felixxm (added)
* severity: Release blocker => Normal

Comment:

I wouldn't mark this as a release blocker if it is there since Django 1.9.
Have you confirmed that issue appears in the supported versions e.g. 2.0
or 2.1?

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

[Django]

#29668: missing FROM-clause entry in subquery with extra

-------------------------------------+-------------------------------------
Reporter: pranavneeraj | Owner: nobody
Type: Bug | Status: closed

Component: Database layer | Version: 2.0
(models, ORM) |

Severity: Normal | Resolution: invalid

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):

* status: new => closed
* resolution: => invalid

Old description:

> Turn.active_objects.all().select_related('request__address').extra(select={'start_time_tz':
> '(start_time AT TIME ZONE COALESCE("api_address".timezone))'}).distinct()
> Works but
> Turn.active_objects.all().select_related('request__address').extra(select={'start_time_tz':
> '(start_time AT TIME ZONE
> COALESCE("api_address".timezone))'}).distinct().count() doesn't.
>
> Because count executes subquery.

New description:

`Turn.active_objects.all().select_related('request__address').extra(select={'start_time_tz':

'(start_time AT TIME ZONE COALESCE("api_address".timezone))'}).distinct()`
Works but
`Turn.active_objects.all().select_related('request__address').extra(select={'start_time_tz':
'(start_time AT TIME ZONE
COALESCE("api_address".timezone))'}).distinct().count()` doesn't.

Because count executes subquery.

--

Comment:

Even if it's still an issue, we're no longer fixing bugs with
`QuerySet.extra()` per [https://groups.google.com/d/topic/django-
developers/FojuU0syO8Y/discussion discussion on django-developers].

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