"too many SQL variables" on delete all recursive
Issue #54
resolved
Should this method be executed in groups of < 1000 to avoid limitations?
private static void DeleteAllIds(this SQLiteConnection conn, object[] primaryKeyValues, string entityName, string primaryKeyName)
Comments (4)
-
-
reporter According to
#9at https://www.sqlite.org/limits.html This limit would be set at 999. Thanks, Dennis -
I just created a test for deleting 10.000 objects in the same statement and worked as expected on iOS. Which platform is giving you this error?
-
- changed status to resolved
DeleteAllByIds will now split the list of primary keys in groups of 999 elements to avoid maximum number of variables errors in some platforms. Fixes
#54→ <<cset c6cf912657bf>>
- Log in to comment
Didn't know about this limitation. All elements of the same type are deleted in a single query. It should be easy to fix.
Thanks for reporting it.