Hi . I am new to this mailing list I have a table with 500,000 rows, it has a unique column of registration numbers The rules for the format of these numbers has changed over time and the schema has changed with the rules of the time. PRAGMA integrity_check now complains about some rows not passing the constraint. An option on integrity_check to ignore schema CHECK would be avoid having to code a CHECK that caries with time. I preferred the pre 3.18 behaviour. More flexible and fulfills a real world requirement.
-- DB _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users