Re: [sqlite] does integrity check ever modify the db file?

2017-01-14 Thread Richard Damon
On 1/13/17 2:51 PM, Adam Smith wrote: Hey all, can 'pragma integrity_check' ever modify the file? For instance in case of a journal file laying around (which was journal file of the same schema db but a bit different data)? The following is what I think happened: a.db and b.db are two

Re: [sqlite] does integrity check ever modify the db file?

2017-01-13 Thread Rowan Worth
On 14 January 2017 at 03:51, Adam Smith wrote: > Hey all, > can 'pragma integrity_check' ever modify the file? For instance in case > of a journal file laying around (which was journal file of the same schema > db but a bit different data)? > > The following is what

[sqlite] does integrity check ever modify the db file?

2017-01-13 Thread Adam Smith
Hey all, can 'pragma integrity_check' ever modify the file? For instance in case of a journal file laying around (which was journal file of the same schema db but a bit different data)? The following is what I think happened: a.db and b.db are two sqlite dbs of size ~5mb which have same schema