(ITS#8457) back-sql: unordered entries combined with pagination gives wrong results

Full_Name: Matthias Hunstock Version: git HEAD OS: Linux URL: ftp://ftp.openldap.org/incoming/fix-sql-order.patch Submission from: (NULL) (2001:638:904:bf:e544:e758:826b:80ce)

Back-SQL does not use any "ORDER BY" statements when querying for ldap entries. If a client uses pagination, there is code that that generates an optimized SQL query with a WHERE clause like " AND ldap_entries.id > x " with x being the highest id from the last paginated search result. As the DBMS gives results in unsorted order, this leads to extremely reduced result sets because it is randomly cut off.

The linked patch resolves the issue for us.