#27095: Queries involving postgres Array fields can't include expressions as
elements
----------------------------------------------+--------------------
Reporter: MatthewWilkes | Owner: nobody
Type: Uncategorized | Status: new
Component: Database layer (models, ORM) | Version: master
Severity: Normal | Keywords:
Triage Stage: Unreviewed | Has patch: 0
Easy pickings: 0 | UI/UX: 0
----------------------------------------------+--------------------
Issue #22288 allows use of expressions in lookups that take iterables
rather than single items directly. This allows, for example:
{{{
NullableIntegerArrayModel.objects.filter(field__in=[models.F('field')]),
}}}
i.e., filtering an ArrayField using `__in` with expressions that evaluate
to other ArrayField references.
However, the following fails:
{{{
NullableIntegerArrayModel.objects.filter(field__in=[[models.F('id')]]),
}}}
i.e., building a new array that contains scalar expressions.
There are some tests, marked with expectedFailure, in
`postgres_tests.test_array`: `test_in_including_F_object` and
`test_contained_by_including_F_object`, that demonstrate this problem.
--
Ticket URL: <https://code.djangoproject.com/ticket/27095>
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 post to this group, send email to [email protected].
To view this discussion on the web visit
https://groups.google.com/d/msgid/django-updates/056.adc8c89e6c08df7134ec599a85e7169d%40djangoproject.com.
For more options, visit https://groups.google.com/d/optout.
