#2445: Ticket search breaks with NULL values
---------------------------+------------------------------------------------
Reporter: ErikRose | Owner: jonas
Type: defect | Status: new
Priority: normal | Milestone:
Component: ticket system | Version: 0.9
Severity: major | Keywords:
---------------------------+------------------------------------------------
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.
--
Ticket URL: <http://projects.edgewall.com/trac/ticket/2445>
The Trac Project <http://trac.edgewall.com/>
_______________________________________________
Trac-Tickets mailing list
[email protected]
http://lists.edgewall.com/mailman/listinfo/trac-tickets
