[wp-trac] [WordPress Trac] #16812: Taxonomy queries without joins ignore order by

[WordPress Trac]

#16812: Taxonomy queries without joins ignore order by
-----------------------------------------+------------------------------
 Reporter:  Chad Killingsworth           |       Owner:  scribu
     Type:  defect (bug)                 |      Status:  reviewing
 Priority:  normal                       |   Milestone:  Awaiting Review
Component:  Query                        |     Version:  3.1
 Severity:  normal                       |  Resolution:
 Keywords:  has-patch reporter-feedback  |
-----------------------------------------+------------------------------
Changes (by Chad Killingsworth):

 * cc: chadkilllingsworth@… (added)


Comment:

 I have a test instance setup and I disabled all plugins before I began
 testing/debugging the issue. I agree with your statement about the
 strangeness of the group by/order by conflict. The SQL Statement including
 the group by clause looks perfectly valid to me and I don't understand why
 it would affect post ordering in any way.

 Here's the query variables and request output:

 {{{
 Array
 (
     [cat] => -1
     [feed] => atom
     [error] =>
     [m] => 0
     [p] => 0
     [post_parent] =>
     [subpost] =>
     [subpost_id] =>
     [attachment] =>
     [attachment_id] => 0
     [name] =>
     [static] =>
     [pagename] =>
     [page_id] => 0
     [second] =>
     [minute] =>
     [hour] =>
     [day] => 0
     [monthnum] => 0
     [year] => 0
     [w] => 0
     [category_name] =>
     [tag] =>
     [tag_id] =>
     [author_name] =>
     [tb] =>
     [paged] => 0
     [comments_popup] =>
     [meta_key] =>
     [meta_value] =>
     [preview] =>
     [s] =>
     [sentence] =>
     [fields] =>
     [category__in] => Array
         (
         )

     [category__not_in] => Array
         (
             [0] => 1
         )

     [category__and] => Array
         (
         )

     [post__in] => Array
         (
         )

     [post__not_in] => Array
         (
         )

     [tag__in] => Array
         (
         )

     [tag__not_in] => Array
         (
         )

     [tag__and] => Array
         (
         )

     [tag_slug__in] => Array
         (
         )

     [tag_slug__and] => Array
         (
         )

     [meta_query] => Array
         (
         )

     [ignore_sticky_posts] =>
     [suppress_filters] =>
     [cache_results] => 1
     [update_post_term_cache] => 1
     [update_post_meta_cache] => 1
     [post_type] =>
     [posts_per_page] => 10
     [nopaging] =>
     [comments_per_page] => 50
     [no_found_rows] =>
     [order] => DESC
     [orderby] => wp_1_posts.post_date DESC
 )
  SELECT SQL_CALC_FOUND_ROWS  wp_1_posts.* FROM wp_1_posts  WHERE 1=1  AND
 ( wp_1_posts.ID NOT IN (
                                         SELECT object_id
                                         FROM wp_1_term_relationships
                                         WHERE term_taxonomy_id IN (1)
                                 ) ) AND wp_1_posts.post_type = 'post' AND
 (wp_1_posts.post_status = 'publish' OR wp_1_posts.post_status = 'private')
 GROUP BY wp_1_posts.ID ORDER BY wp_1_posts.post_date DESC LIMIT 0, 10
 }}}

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