[wp-trac] [WordPress Trac] #17264: Duplicate posts returned if multiple meta_values match and no meta_key is set

[WordPress Trac]

#17264: Duplicate posts returned if multiple meta_values match and no meta_key is
set
--------------------------+------------------------------
 Reporter:  trepmal       |       Owner:
     Type:  defect (bug)  |      Status:  new
 Priority:  normal        |   Milestone:  Awaiting Review
Component:  Query         |     Version:  3.1
 Severity:  normal        |  Resolution:
 Keywords:                |
--------------------------+------------------------------
Changes (by trepmal):

 * keywords:  reporter-feedback =>


Comment:

 Point-release nightlies gets me 3.1.2-alpha[[BR]]
 problem persists

 Bleeding edge nightlies gets me 3.2-bleeding[[BR]]
 produces the following error (and no search results):[[BR]]
 WordPress database error: [You have an error in your SQL syntax; check the
 manual that corresponds to your MySQL server version for the right syntax
 to use near ') GROUP BY wp_posts.ID ORDER BY wp_posts.post_date DESC LIMIT
 0, 10' at line 1]
 SELECT SQL_CALC_FOUND_ROWS wp_posts.* FROM wp_posts WHERE 1=1 AND
 wp_posts.post_type = 'post' AND (wp_posts.post_status = 'publish' OR
 wp_posts.post_status = 'private') AND ( ) GROUP BY wp_posts.ID ORDER BY
 wp_posts.post_date DESC LIMIT 0, 10

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