Hi, I have few questions regarding "Pragma integrity_check"
1. I have test table: PRAGMA ignore_check_constraints = true; CREATE TABLE dtest1(the_key INTEGER NOT NULL, versionId INTEGER , primary key (the_key), check( versionId <> 0 ) ) WITHOUT ROWID INSERT into dtest1 values (0,0); PRAGMA ignore_check_constraints = false; after that I try to run PRAGMA integrity_check; and I found that if I open db as read_write - sqlite founds the error, but if I open db in read_only mode - integrity check report "ok". is this behavior correct, can I detect this constraint violation in read_only mode|? 2. Will "PRAGMA integrity_check;" change DB in any cases (if I open it with read_write access)? -- Best regard, Konstantin Voronin. ________________________________ This e-mail and any attachment(s) are intended only for the recipient(s) named above and others who have been specifically authorized to receive them. They may contain confidential information. If you are not the intended recipient, please do not read this email or its attachment(s). Furthermore, you are hereby notified that any dissemination, distribution or copying of this e-mail and any attachment(s) is strictly prohibited. If you have received this e-mail in error, please immediately notify the sender by replying to this e-mail and then delete this e-mail and any attachment(s) or copies thereof from your system. Thank you. _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
