dotnet / dotnet/efcore

SQLite: Support ORDER BY and LIMIT in bulk update/delete

Open
#28,522 0 comments 0 reactions 0 assignees View on GitHub
area-bulkupdate area-sqlite
Dominant language
C#
Stars
14.8k
Forks
3.4k
PR merge metrics
PR metrics pending

Description

SQLite supports ORDER BY and LIMIT if compiled with a specific option, [see docs](https://www.sqlite.org/compile.html#enable_update_delete_limit). I'm not sure what version we deliver and whether it has that option (plus IIRC on non-Windows we use the system-installed SQLite, where we have no idea). So this may need to be an opt-in context option.

In the meantime, ORDER BY and LIMIT are supported via a subquery pushdown, which is less nice and may have a perf impact (unconfirmed). We'd need to investigate more to understand if this is worth it.

Contributor guide

Open the contributing guide

Assessment

This issue has not been assessed yet.

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.