#31094: subquery uses ungrouped column "table.column" from outer query
-------------------------------------+-------------------------------------
Reporter: Johannes Hoppe | Owner: nobody
Type: Bug | Status: new
Component: Database layer | Version: 3.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
-------------------------------------+-------------------------------------
Description changed by Johannes Hoppe:
Old description:
> Why upgrading to Django 3.0 I get the following issue:
> {{{
> subquery uses ungrouped column "t4.position" from outer query
> LINE 1: ..."."activity_type" AND ST_Contains(U2."locations",
> T4."positi...
> }}}
>
> Full stack trace
> {{{
> Environment:
>
> Request Method: GET
> Request URL: http://localhost:8000/api/offer-map/
>
> Django Version: 3.0
> Python Version: 3.8.0
> Installed Applications:
> ['django.contrib.auth',
> 'django.contrib.sites',
> 'django.contrib.contenttypes',
> '...',
> '....',
> '....',
> 'django.contrib.admin',
> 'django.contrib.sessions',
> 'django.contrib.messages',
> 'whitenoise.runserver_nostatic',
> 'django.contrib.staticfiles',
> 'django.contrib.postgres',
> 'django.contrib.gis',
> 'django.forms',
> 'django_dramatiq',
> 'mailauth',
> 'mailauth.contrib.admin',
> 's3file',
> 'stdimage',
> 'adminsortable2',
> 'rest_framework',
> 'rest_framework_gis',
> 'django_filters',
> 'phonenumber_field',
> '...']
> Installed Middleware:
> ['log_request_id.middleware.RequestIDMiddleware',
> 'voiio.logging.middleware.UserAgentLogMiddleware',
> 'django.middleware.gzip.GZipMiddleware',
> 'django.middleware.security.SecurityMiddleware',
> 'whitenoise.middleware.WhiteNoiseMiddleware',
> 'django.contrib.sessions.middleware.SessionMiddleware',
> 'django.middleware.locale.LocaleMiddleware',
> 'django.middleware.common.CommonMiddleware',
> 'django.middleware.csrf.CsrfViewMiddleware',
> 'django.contrib.auth.middleware.AuthenticationMiddleware',
> 'django.contrib.messages.middleware.MessageMiddleware',
> 'django.middleware.clickjacking.XFrameOptionsMiddleware',
> 's3file.middleware.S3FileMiddleware',
> 'accounts.middleware.CompanyMiddleware']
>
>
> Traceback (most recent call last):
> File "/Users/johannes/GitHub/voiio/voiio-platform/venv/lib/python3.8
> /site-packages/django/db/backends/utils.py", line 86, in _execute
> return self.cursor.execute(sql, params)
>
> The above exception (subquery uses ungrouped column "t4.position" from
> outer query
> LINE 1: ..."."activity_type" AND ST_Contains(U2."locations",
> T4."positi...
> ^
> ) was the direct cause of the following exception:
> File "/Users/johannes/GitHub/voiio/voiio-platform/venv/lib/python3.8
> /site-packages/django/core/handlers/exception.py", line 34, in inner
> response = get_response(request)
> File "/Users/johannes/GitHub/voiio/voiio-platform/venv/lib/python3.8
> /site-packages/django/core/handlers/base.py", line 115, in _get_response
> response = self.process_exception_by_middleware(e, request)
> File "/Users/johannes/GitHub/voiio/voiio-platform/venv/lib/python3.8
> /site-packages/django/core/handlers/base.py", line 113, in _get_response
> response = wrapped_callback(request, *callback_args,
> **callback_kwargs)
> File "/Users/johannes/GitHub/voiio/voiio-platform/venv/lib/python3.8
> /site-packages/django/views/decorators/csrf.py", line 54, in wrapped_view
> return view_func(*args, **kwargs)
> File "/Users/johannes/GitHub/voiio/voiio-platform/venv/lib/python3.8
> /site-packages/rest_framework/viewsets.py", line 114, in view
> return self.dispatch(request, *args, **kwargs)
> File "/Users/johannes/GitHub/voiio/voiio-platform/venv/lib/python3.8
> /site-packages/rest_framework/views.py", line 505, in dispatch
> response = self.handle_exception(exc)
> File "/Users/johannes/GitHub/voiio/voiio-platform/venv/lib/python3.8
> /site-packages/rest_framework/views.py", line 465, in handle_exception
> self.raise_uncaught_exception(exc)
> File "/Users/johannes/GitHub/voiio/voiio-platform/venv/lib/python3.8
> /site-packages/rest_framework/views.py", line 476, in
> raise_uncaught_exception
> raise exc
> File "/Users/johannes/GitHub/voiio/voiio-platform/venv/lib/python3.8
> /site-packages/rest_framework/views.py", line 502, in dispatch
> response = handler(request, *args, **kwargs)
> File "/Users/johannes/GitHub/voiio/voiio-platform/camps/viewsets.py",
> line 344, in list
> page = self.paginate_queryset(queryset)
> File "/Users/johannes/GitHub/voiio/voiio-platform/venv/lib/python3.8
> /site-packages/rest_framework/generics.py", line 171, in
> paginate_queryset
> return self.paginator.paginate_queryset(queryset, self.request,
> view=self)
> File "/Users/johannes/GitHub/voiio/voiio-platform/venv/lib/python3.8
> /site-packages/rest_framework/pagination.py", line 627, in
> paginate_queryset
> results = list(queryset[offset:offset + self.page_size + 1])
> File "/Users/johannes/GitHub/voiio/voiio-platform/venv/lib/python3.8
> /site-packages/django/db/models/query.py", line 258, in __len__
> self._fetch_all()
> File "/Users/johannes/GitHub/voiio/voiio-platform/venv/lib/python3.8
> /site-packages/django/db/models/query.py", line 1261, in _fetch_all
> self._result_cache = list(self._iterable_class(self))
> File "/Users/johannes/GitHub/voiio/voiio-platform/venv/lib/python3.8
> /site-packages/django/db/models/query.py", line 57, in __iter__
> results = compiler.execute_sql(chunked_fetch=self.chunked_fetch,
> chunk_size=self.chunk_size)
> File "/Users/johannes/GitHub/voiio/voiio-platform/venv/lib/python3.8
> /site-packages/django/db/models/sql/compiler.py", line 1137, in
> execute_sql
> cursor.execute(sql, params)
> File "/Users/johannes/GitHub/voiio/voiio-platform/venv/lib/python3.8
> /site-packages/django/db/backends/utils.py", line 100, in execute
> return super().execute(sql, params)
> File "/Users/johannes/GitHub/voiio/voiio-platform/venv/lib/python3.8
> /site-packages/django/db/backends/utils.py", line 68, in execute
> return self._execute_with_wrappers(sql, params, many=False,
> executor=self._execute)
> File "/Users/johannes/GitHub/voiio/voiio-platform/venv/lib/python3.8
> /site-packages/django/db/backends/utils.py", line 77, in
> _execute_with_wrappers
> return executor(sql, params, many, context)
> File "/Users/johannes/GitHub/voiio/voiio-platform/venv/lib/python3.8
> /site-packages/django/db/backends/utils.py", line 86, in _execute
> return self.cursor.execute(sql, params)
> File "/Users/johannes/GitHub/voiio/voiio-platform/venv/lib/python3.8
> /site-packages/django/db/utils.py", line 90, in __exit__
> raise dj_exc_value.with_traceback(traceback) from exc_value
> File "/Users/johannes/GitHub/voiio/voiio-platform/venv/lib/python3.8
> /site-packages/django/db/backends/utils.py", line 86, in _execute
> return self.cursor.execute(sql, params)
>
> Exception Type: ProgrammingError at /api/offer-map/
> Exception Value: subquery uses ungrouped column "t4.position" from outer
> query
> LINE 1: ..."."activity_type" AND ST_Contains(U2."locations",
> T4."positi... ^
> }}}
New description:
Why upgrading to Django 3.0 I get the following issue:
{{{
subquery uses ungrouped column "t4.position" from outer query
LINE 1: ..."."activity_type" AND ST_Contains(U2."locations", T4."positi...
}}}
Stack:
Python 3.8
PostgeSQL 11
macOS / Ubuntu latest
Full stack trace
{{{
Environment:
Request Method: GET
Request URL: http://localhost:8000/api/offer-map/
Django Version: 3.0
Python Version: 3.8.0
Installed Applications:
['django.contrib.auth',
'django.contrib.sites',
'django.contrib.contenttypes',
'...',
'....',
'....',
'django.contrib.admin',
'django.contrib.sessions',
'django.contrib.messages',
'whitenoise.runserver_nostatic',
'django.contrib.staticfiles',
'django.contrib.postgres',
'django.contrib.gis',
'django.forms',
'django_dramatiq',
'mailauth',
'mailauth.contrib.admin',
's3file',
'stdimage',
'adminsortable2',
'rest_framework',
'rest_framework_gis',
'django_filters',
'phonenumber_field',
'...']
Installed Middleware:
['log_request_id.middleware.RequestIDMiddleware',
'voiio.logging.middleware.UserAgentLogMiddleware',
'django.middleware.gzip.GZipMiddleware',
'django.middleware.security.SecurityMiddleware',
'whitenoise.middleware.WhiteNoiseMiddleware',
'django.contrib.sessions.middleware.SessionMiddleware',
'django.middleware.locale.LocaleMiddleware',
'django.middleware.common.CommonMiddleware',
'django.middleware.csrf.CsrfViewMiddleware',
'django.contrib.auth.middleware.AuthenticationMiddleware',
'django.contrib.messages.middleware.MessageMiddleware',
'django.middleware.clickjacking.XFrameOptionsMiddleware',
's3file.middleware.S3FileMiddleware',
'accounts.middleware.CompanyMiddleware']
Traceback (most recent call last):
File "/Users/johannes/GitHub/voiio/voiio-platform/venv/lib/python3.8
/site-packages/django/db/backends/utils.py", line 86, in _execute
return self.cursor.execute(sql, params)
The above exception (subquery uses ungrouped column "t4.position" from
outer query
LINE 1: ..."."activity_type" AND ST_Contains(U2."locations", T4."positi...
^
) was the direct cause of the following exception:
File "/Users/johannes/GitHub/voiio/voiio-platform/venv/lib/python3.8
/site-packages/django/core/handlers/exception.py", line 34, in inner
response = get_response(request)
File "/Users/johannes/GitHub/voiio/voiio-platform/venv/lib/python3.8
/site-packages/django/core/handlers/base.py", line 115, in _get_response
response = self.process_exception_by_middleware(e, request)
File "/Users/johannes/GitHub/voiio/voiio-platform/venv/lib/python3.8
/site-packages/django/core/handlers/base.py", line 113, in _get_response
response = wrapped_callback(request, *callback_args,
**callback_kwargs)
File "/Users/johannes/GitHub/voiio/voiio-platform/venv/lib/python3.8
/site-packages/django/views/decorators/csrf.py", line 54, in wrapped_view
return view_func(*args, **kwargs)
File "/Users/johannes/GitHub/voiio/voiio-platform/venv/lib/python3.8
/site-packages/rest_framework/viewsets.py", line 114, in view
return self.dispatch(request, *args, **kwargs)
File "/Users/johannes/GitHub/voiio/voiio-platform/venv/lib/python3.8
/site-packages/rest_framework/views.py", line 505, in dispatch
response = self.handle_exception(exc)
File "/Users/johannes/GitHub/voiio/voiio-platform/venv/lib/python3.8
/site-packages/rest_framework/views.py", line 465, in handle_exception
self.raise_uncaught_exception(exc)
File "/Users/johannes/GitHub/voiio/voiio-platform/venv/lib/python3.8
/site-packages/rest_framework/views.py", line 476, in
raise_uncaught_exception
raise exc
File "/Users/johannes/GitHub/voiio/voiio-platform/venv/lib/python3.8
/site-packages/rest_framework/views.py", line 502, in dispatch
response = handler(request, *args, **kwargs)
File "/Users/johannes/GitHub/voiio/voiio-platform/camps/viewsets.py",
line 344, in list
page = self.paginate_queryset(queryset)
File "/Users/johannes/GitHub/voiio/voiio-platform/venv/lib/python3.8
/site-packages/rest_framework/generics.py", line 171, in paginate_queryset
return self.paginator.paginate_queryset(queryset, self.request,
view=self)
File "/Users/johannes/GitHub/voiio/voiio-platform/venv/lib/python3.8
/site-packages/rest_framework/pagination.py", line 627, in
paginate_queryset
results = list(queryset[offset:offset + self.page_size + 1])
File "/Users/johannes/GitHub/voiio/voiio-platform/venv/lib/python3.8
/site-packages/django/db/models/query.py", line 258, in __len__
self._fetch_all()
File "/Users/johannes/GitHub/voiio/voiio-platform/venv/lib/python3.8
/site-packages/django/db/models/query.py", line 1261, in _fetch_all
self._result_cache = list(self._iterable_class(self))
File "/Users/johannes/GitHub/voiio/voiio-platform/venv/lib/python3.8
/site-packages/django/db/models/query.py", line 57, in __iter__
results = compiler.execute_sql(chunked_fetch=self.chunked_fetch,
chunk_size=self.chunk_size)
File "/Users/johannes/GitHub/voiio/voiio-platform/venv/lib/python3.8
/site-packages/django/db/models/sql/compiler.py", line 1137, in
execute_sql
cursor.execute(sql, params)
File "/Users/johannes/GitHub/voiio/voiio-platform/venv/lib/python3.8
/site-packages/django/db/backends/utils.py", line 100, in execute
return super().execute(sql, params)
File "/Users/johannes/GitHub/voiio/voiio-platform/venv/lib/python3.8
/site-packages/django/db/backends/utils.py", line 68, in execute
return self._execute_with_wrappers(sql, params, many=False,
executor=self._execute)
File "/Users/johannes/GitHub/voiio/voiio-platform/venv/lib/python3.8
/site-packages/django/db/backends/utils.py", line 77, in
_execute_with_wrappers
return executor(sql, params, many, context)
File "/Users/johannes/GitHub/voiio/voiio-platform/venv/lib/python3.8
/site-packages/django/db/backends/utils.py", line 86, in _execute
return self.cursor.execute(sql, params)
File "/Users/johannes/GitHub/voiio/voiio-platform/venv/lib/python3.8
/site-packages/django/db/utils.py", line 90, in __exit__
raise dj_exc_value.with_traceback(traceback) from exc_value
File "/Users/johannes/GitHub/voiio/voiio-platform/venv/lib/python3.8
/site-packages/django/db/backends/utils.py", line 86, in _execute
return self.cursor.execute(sql, params)
Exception Type: ProgrammingError at /api/offer-map/
Exception Value: subquery uses ungrouped column "t4.position" from outer
query
LINE 1: ..."."activity_type" AND ST_Contains(U2."locations", T4."positi...
^
}}}
--
--
Ticket URL: <https://code.djangoproject.com/ticket/31094#comment:1>
Django <https://code.djangoproject.com/>
The Web framework for perfectionists with deadlines.
--
You received this message because you are subscribed to the Google Groups
"Django updates" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
To view this discussion on the web visit
https://groups.google.com/d/msgid/django-updates/067.08bc10cd2dd1b12809b510303a3aa90f%40djangoproject.com.
