https://kotlinlang.org logo
#squarelibraries
Title
# squarelibraries
s

sasikanth

12/06/2023, 7:02 AM
I have run into a weird crash on iOS with SQLDelight, when using
RETURNING
with a
DELETE
query. SQLite supports
RETURNING
from 3.35.0 onwards, and I have checked that SQLite version is available from iOS 15 onwards, I have tested it on iOS 17. (posting the log in the thread) I have create a query that deletes posts before certain period and then returns deleted ids
Copy code
DELETE FROM post
WHERE post.read == 1 AND post.date < :before
RETURNING post.id;
This works great on Android when tested and on iOS it crashes. But when I wrap the query in a transaction it passes on iOS as well
Copy code
postQueries.transactionWithResult {
  postQueries.deleteReadPosts(before = before).executeAsList()
}
Not sure if I am doing something wrong here or if this is an issue with the platform. so, just checking to see if anyone else had a similar issue.
Untitled