[Date Prev][Date Next] [Chronological] [Thread] [Top]

(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.