Changes between Initial Version and Version 1 of Ticket #17273, comment 1


Ignore:
Timestamp:
Nov 21, 2011, 8:53:54 AM (13 years ago)
Author:
Luke Plant

Legend:

Unmodified
Added
Removed
Modified
  • Ticket #17273, comment 1

    initial v1  
    1 This is not a bug. Having some of the same items appear in both [10:15] and [15:20] is correct, because those items have a NULL value for the field you are sorting on. These items therefore don't have strict total order defined for them, so when you ask [n:n+k], the database backend is free to choose and 'k' of them that it pleases.
     1This is not a bug. Having some of the same items appear in both `[10:15]` and `[15:20]` is correct, because those items have a NULL value for the field you are sorting on. These items therefore don't have strict total order defined for them, so when you ask [n:n+k], the database backend is free to choose and 'k' of them that it pleases.
    22
    33For comparison, other database backends have the same behaviour if the ordering you specify does not provide a strict total order.
Back to Top