Ghost icon indicating copy to clipboard operation
Ghost copied to clipboard

🐛 Fixed migrations for SQLite database users (#19839)

Open markstos opened this issue 1 year ago • 2 comments
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

markstos avatar Sep 21 '24 18:09 markstos