﻿id	summary	reporter	owner	description	type	status	priority	milestone	component	version	severity	resolution	keywords	cc	branch	changelog	apichanges	internalchanges
2445	Ticket search breaks with NULL values	ErikRose	Jonas Borgström	"Searches often fail to find tickets which have any of these fields set to NULL in the `ticket` table:
 * summary
 * keywords
 * description
 * reporter
 * cc

This is because the SQL is first concatenating all those fields and then running a LIKE against them. Trac 0.8.4 did this right. I'll attach patch in a moment that restores correct behavior.

Incidentally, this also fixes a bug which can result in false positives during search, as ""fake"" words are generated at field boundaries by the concatenation."	defect	closed	normal	0.10	search system	0.9	major	fixed		psucorp@…				
