I suspect that REINDEX can fail. Because of a collation change, a table that was previously valid for a UNIQUE index may have records that violate that constraint. For a WITHOUT ROWID table, changing the collation of the primary key might involve shuffling the location on disk of almost every record. That might be much more expensive (time and space) than other REINDEX operations.