﻿id,summary,reporter,owner,description,type,status,priority,milestone,component,version,severity,resolution,keywords,cc
17152,Multiple keyword search: unnecessary sentence search,scribu,ryan,"'s=foo+bar' generates this query:

{{{
SELECT SQL_CALC_FOUND_ROWS wp_posts . *
FROM wp_posts
WHERE 1 =1
AND (
	((wp_posts.post_title LIKE '%foo%') OR (wp_posts.post_content LIKE '%foo%'))
	AND
	((wp_posts.post_title LIKE '%bar%') OR (wp_posts.post_content LIKE '%bar%'))
	OR
	(wp_posts.post_title LIKE '%foo bar%')
	OR
	(wp_posts.post_content LIKE '%foo bar%')
)
AND wp_posts.post_type IN ('post', 'page', 'attachment')
AND (wp_posts.post_status = 'publish' OR wp_posts.post_status = 'private')
ORDER BY wp_posts.post_date DESC
LIMIT 0 , 10
}}}

Unless I'm missing something, this part is superfluous:

{{{
	OR
	(wp_posts.post_title LIKE '%foo bar%')
	OR
	(wp_posts.post_content LIKE '%foo bar%')
}}}
",defect (bug),closed,normal,3.2,Performance,,normal,fixed,has-patch needs-testing,
