[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:
-------------------------------+------------------------------
Changes (by johnbillion):

 * keywords:   => reporter-feedback
 * component:  General => Database


Comment:

 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?

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