id	summary	reporter	owner	description	type	status	component	version	severity	resolution	keywords	cc	stage	has_patch	needs_docs	needs_tests	needs_better_patch	easy	ui_ux
27095	Queries involving postgres Array fields can't include expressions as elements	Matthew Wilkes		"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."	Bug	new	contrib.postgres	dev	Normal				Accepted	0	0	0	0	0	0