Code review comment for lp:~adeuring/launchpad/bug-739052

Revision history for this message
Abel Deuring (adeuring) wrote :

On 02.08.2011 11:01, Robert Collins wrote:
> I think
>
>
> SELECT ... FROM ...
> WHERE (original_clause AND col1 >= memo1 AND col2 >= memo2
> AND col3 > memo3)
>
> is whats needed ?
>

no, lets assume two sort columns, with these values in the result set:

1, 1
1, 2
1, 3
2, 1
2, 2
2, 3

If the memo value is (1, 2), we want the rows starting at (1, 3).

So we need the rows where col1 == memo1 and col2 > memo2, and
additinally the rows where col1 > memo1.

See also
https://code.launchpad.net/~adeuring/launchpad/bug-739052-2/+merge/70044

« Back to merge proposal