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
25843	Ampersands in icontains filter returns inconsistent results	Gady Pitaru	nobody	"Ampersands in `icontains` filter returns inconsistent results based on if the ampersand is the last character or not. Replacing the ampersand character with `&` fixes the issue. The following examples illustrate the issue, assuming there is one record with `field = 'Fish & Chips'`:

{{{
query1 = 'Fish &'
Model.objects.filter(field__icontains=query1)
# returns a result

query2 = 'Fish & Chips'
Model.objects.filter(field__icontains=query2)
# returns no results

query3 = 'Fish & Chips'
Model.objects.filter(field__icontains=query3)
# returns a result
}}}"	Bug	closed	Database layer (models, ORM)	1.6	Normal	worksforme			Unreviewed	0	0	0	0	0	0