Opened 14 years ago
Closed 14 years ago
#17152 closed defect (bug) (fixed)
Multiple keyword search: unnecessary sentence search
Reported by: | scribu | Owned by: | ryan |
---|---|---|---|
Milestone: | 3.2 | Priority: | normal |
Severity: | normal | Version: | |
Component: | Performance | Keywords: | has-patch needs-testing |
Focuses: | Cc: |
Description
'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%')
Attachments (1)
Change History (4)
Note: See
TracTickets for help on using
tickets.
$q['sentence']
is taken care of above.