Raw SQL generated for cursor using libsql issue
To start with I am using:
I am handling a cursor-based pagination. My code looks like this:
When fetching the first batch of items, with
after
argument being null
, I'm successfully getting the data.
The raw generated SQL looks like this:
However, when trying to get the next batch based on the cursor, I'm getting an error from libSQL RESPONSE_TOO_LARGE: Response is too large
.
When looking at the generated SQL it looks like this:
I believe the -1
is a bug and the proper limit is not being applied correctly here. Does anyone have a pointer on how I can debug this locally and maybe local patch it?Solution:Alright, so I figured out the issue is coming from "You must sort by your cursor, which has to be a unique, sequential column."Jump to solution
1 Reply
SolutionAlright, so I figured out the issue is coming from "You must sort by your cursor, which has to be a unique, sequential column."