Opened 15 years ago
Closed 14 years ago
#17152 closed defect (bug) (fixed)
Multiple keyword search: unnecessary sentence search
| Reported by: |
|
Owned by: |
|
|---|---|---|---|
| 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.