[wp-trac] [WordPress Trac] #49785: Wrong result / duplicates in query when using MariaDB

[WordPress Trac]

#49785: Wrong result / duplicates in query when using MariaDB
-------------------------------+------------------------------
 Reporter:  Kim.Bertelsen      |       Owner:  (none)
     Type:  defect (bug)       |      Status:  new
 Priority:  normal             |   Milestone:  Awaiting Review
Component:  Database           |     Version:  5.4
 Severity:  normal             |  Resolution:
 Keywords:  reporter-feedback  |     Focuses:
-------------------------------+------------------------------

Comment (by Kim.Bertelsen):

 Replying to [comment:1 johnbillion]:
 > Thanks for the report @kimbertelsen .
 >
 > What happens if you run the query directly in your mysql console without
 the LIMIT clause in place? Do you get the correct total and correct
 results or do you get duplicates in the results?

 Without LIMIT I get the full list of 128 pages, no duplicates.
 {{{
 SELECT SQL_CALC_FOUND_ROWS wp_posts.ID FROM wp_posts WHERE 1=1 AND
 wp_posts.ID NOT IN (51915) AND wp_posts.post_parent NOT IN (51915) AND
 wp_posts.post_type = 'page' AND ((wp_posts.post_status = 'publish')) ORDER
 BY wp_posts.menu_order ASC
 }}}

-- 
Ticket URL: <https://core.trac.wordpress.org/ticket/49785#comment:2>
WordPress Trac <https://core.trac.wordpress.org/>
WordPress publishing platform