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
30385	SearchVector's usage of CONCAT makes it impossible to index against.	Simon Charette	Simon Charette	"`SearchVector` was changed in Django 2.2 to allow querying non-text fields (#29582) by using `CONCAT` which automatically cast such fields to text and deals with `NULL` value appropriately.

This had the unintended side effect of making the generated SQL loose it's `IMMUTABLE` status as `CONCAT` can generate locale/TZ dependant output which makes the generated SQL expression impossible to index against."	Bug	closed	contrib.postgres	2.2	Release blocker	fixed			Accepted	1	0	0	0	0	0