`Error: statement too long` what is the statement size limit?
Error: statement too longwhat is the statement size limit?
Error: statement too long
cause should not be deprecated, it's still thereError: too many terms in compound SELECT (coming from a select {condition} union all select {another condition} ).. I suppose I'm wondering what SQLite differences would account for this seeing that the query works in the regular backend but errors out in the experimental?SQLITE_LIMIT_COMPOUND_SELECT set to 3
.cause in that.batch() an error is thrown and everything is rolled back. This is not what I'd like to do, rather I'd like to ack/retry each item based on the success attribute.run()s inside try catches?insert into i can look at the results.changes attribute to tell if a row was inserted or not then .ack() or .retry() based on thatmeta.changes the same in production and in development? it's present in dev but the docs do not mention it, only meta.durationdb.dump() do if not dumping the db content into an sqlite file?causeError: too many terms in compound SELECTselect {condition} union all select {another condition} SQLITE_LIMIT_COMPOUND_SELECT3.cause.batch()results.forEach(({ success }, index) => {
if (success) {
batch.messages[index].ack();
return;
}
batch.messages[index].retry();
});.run()insert intoresults.changes.ack().retry()meta.changesmeta.durationdb.dump()