Changeset 31452

Timestamp:

02/13/2015 04:59:51 PM (10 years ago)

Author:

boonebgorges

Message:

Provide a secondary sort order for wp_get_archives() when type=postbypost.

Sorting by post_date alone can cause indeterminacy problems on different
versions of MySQL when post_date ties need to be broken. Using ID as a
secondary sort ensures that the order is always determinate.

Props herbmillerjr for an initial patch.
Fixes #30480.

File:

• trunk/src/wp-includes/general-template.php (modified) (1 diff)

trunk/src/wp-includes/general-template.php

@@ -1484 +1484 @@
         }
     } elseif ( ( 'postbypost' == $r['type'] ) || ('alpha' == $r['type'] ) ) {
-        $orderby = ( 'alpha' == $r['type'] ) ? 'post_title ASC ' : 'post_date DESC ';
+        $orderby = ( 'alpha' == $r['type'] ) ? 'post_title ASC ' : 'post_date DESC, ID DESC ';
         $query = "SELECT * FROM $wpdb->posts $join $where ORDER BY $orderby $limit";
         $key = md5( $query );