Ghost
Ghost copied to clipboard
🐛 Fixed migrations for SQLite database users (#19839)
trafficstars
SQLite has limit of 500 items in a compound select statement.
This limit could be hit when a complex select statement was being generated as part of a batch insert statement.
Lowering the batch size will have minimal impact on migration performance while improving SQLite compatibility.
One of these bulk inserts is confirmed to be affected through the linked issue. I did confirm if the other two cases would trigger it, but the change won't hurt there either.
Ref: https://www.sqlite.org/limits.html Issue: #19839