Always use RETURNING
once the minimum supported SQLite version is 3.35.0
#17577
Labels
RETURNING
once the minimum supported SQLite version is 3.35.0
#17577
The minimum supported version of SQLite3 at the time of writing is 3.34 (since that's what's in Debian oldstable right now), which doesn't support the
RETURNING
clause inINSERT
/UPDATE
/DELETE
queries. That means every such usage ofRETURNING
must be gated by a check toBaseDatabaseEngine.supports_returning
or when it's known that a Postgres database is in use.The earliest version of SQLite3 to support this usage of
RETURNING
is 3.35.0, so once the minimum supported version is that or newer, Synapse can assumeRETURNING
is always available.The text was updated successfully, but these errors were encountered: