Open LZRS opened 3 weeks ago
@LZRS There seems to be a current limit (999) on the size of the variables that can be passed in an IN(..) query. There are open issues here in Android : https://issuetracker.google.com/issues/192284727 .
One way to solve this is by splitting the full query to smaller sized queries (maybe inside a utility function) and joining the results in the end.
Let me know if you would like to work on the issue.
Cool. Yes, I'd like to work on the issue
Cool. Yes, I'd like to work on the issue
Assigned to you.
Describe the bug Currently testing with for a user with many patients, sometimes sync fails with error
Component Engine library
Additional context Checking the LocalEntity table for our app it has around 54k tasks, it might be related to the above query failing on sync upload
Would you like to work on the issue? Please state if this issue should be assigned to you or who you think could help to solve this issue.