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
34080	__exact lookup on nested arrays with None values fails on PostgreSQL.	Ion Alberdi	Ion Alberdi	"PR:
https://github.com/pricemoov/django/pull/2/files

How to reproduce:
tox -e py39-postgres -- --settings=test_postgres postgres_tests.test_array.TestQuerying



{{{
django.db.utils.DataError: invalid input syntax for type integer: ""{NULL,NULL}""
LINE 1: ...ullableintegerarraymodel"".""field_nested"" = (ARRAY['{NULL,NUL...

}}}


The error seems to be due to the query being generated as 

{{{
...ARRAY['{NULL,NULL}']...

}}}

instead of 

{{{
...ARRAY[ARRAY[NULL,NULL]]...

}}}

Note that the bug is not reproduced if at **least one** of the elements in the nested array is **not null**.
"	Bug	closed	contrib.postgres	4.1	Normal	fixed			Ready for checkin	1	0	0	0	0	0