SQLite repairs an UPSERT index inconsistency
engineeringsqliteupsertcorrectnessSQLite 3.45.2 fixes redundant UPSERT clauses that can corrupt an index. A separate aggregation bug shows why a column constraint cannot always justify simplifying an expression.