[wp-trac] [WordPress Trac] #18522: Search using double quotes stopped working at v3.1

[WordPress Trac]

#18522: Search using double quotes stopped working at v3.1
--------------------------+------------------------------
 Reporter:  kizora        |       Owner:
     Type:  defect (bug)  |      Status:  new
 Priority:  normal        |   Milestone:  Awaiting Review
Component:  General       |     Version:  3.1
 Severity:  normal        |  Resolution:
 Keywords:                |
--------------------------+------------------------------

Comment (by kizora):

 Have just run debug in the live website set to wp3.1. The query used is
 (identical)

 Query Arguments:s=%5C%22Swimming+Pool%5C%22

 SELECT SQL_CALC_FOUND_ROWS wp_posts.* FROM wp_posts WHERE 1=1 AND
 (((wp_posts.post_title LIKE '%Swimming Pool%') OR (wp_posts.post_content
 LIKE '%Swimming Pool%'))) AND wp_posts.post_type IN ('post', 'page',
 'attachment') AND (wp_posts.post_status = 'publish' OR
 wp_posts.post_author = 1 AND wp_posts.post_status = 'private') ORDER BY
 wp_posts.post_date DESC LIMIT 0, 10

 and that finds no rows!

 I ran the query in live phpMyAdmin and it finds 10 rows - confused!

 debug stats show:-
 the localhost version = | PHP 5.3.1 | DB 5.1.41 | Mem. 17,979,896 bytes
 the live version =      | PHP 5.2.14 | DB 5.0.91 | Mem. 22,955,176 bytes

 could the different PHP / DB versions have an effect?

-- 
Ticket URL: <http://core.trac.wordpress.org/ticket/18522#comment:10>
WordPress Trac <http://core.trac.wordpress.org/>
WordPress blogging software