SQLite
View Ticket
Not logged in
Ticket UUID: 0fc59f908b074712165cd76ca2fa9344124fe755
Title: Missing COLLATE function does not result in an error
Status: Fixed Type: Code_Defect
Severity: Severe Priority: Immediate
Subsystem: Unknown Resolution: Fixed
Last Modified: 2013-05-15 17:58:20
Version Found In: 3.7.16.2
User Comments:
drh added on 2013-05-15 13:23:33: (text/x-fossil-wiki)
If a database schema uses an application-defined collating sequence, and
an instance of SQLite is run on that database that does not have the
necessary collating sequence defined, then the "REINDEX" and 
"PRAGMA integrity_check" commands run without generating an error
and substitute the built-in BINARY
collating sequence in place of the application-defined collating sequence.
Running the REINDEX command this way corrupts the index (though the 
corruption can be reversed by rerunning REINDEX in a new database connection
where the application-defined collating sequence has been defined).
Running PRAGMA integrity_check this way results in spurious errors.

This problem appears to have been introduced by check-in
[8542e6180d4321d] and first appeared in release 3.7.15.