stuartf123

Results 4 comments of stuartf123

I am not explicitly setting the value of the paginationUniqueKey. I believe you default the column name to be 'id' and so this results in your code still appending your...

Here is a sample dataset and generated queries that shows the problem: Col1 Col2 10 20 9 21 8 22 7 23 6 24 1st query – paging 2 rows...

Your original algorithm would have generated select col1, col2 where col1 < 8 or col1 = 8 and col2 < 22 limit 3 The above also has a flaw. I...

Here is an implementation of Paginator.buildCursorQuery that pages correctly for composite keys: ``` const operator = this.getOperator(); // adds "(col1 < x) or (col1 = x and col2 < y)"...