Hi,Richard The cases happens in PC. The disk remained is not much, sorts of several hundreds of Mb .
Then the following step is what I do. 1) Create a 1M bytes size file. 2) create a table and begin to insert data in the table until the disk comes full. 3) Delete the 1M bytes file. 4) Begin transaction 5) Delete records in the table, looks like "delete from tt"; 6) End transaction(Commit). Thanks Ryan ZhangCheng -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: 2006年11月27日 19:01 To: [email protected] Subject: Re: [sqlite] A database corrupting case to report "Zhang Cheng-E7104C" <[EMAIL PROTECTED]> wrote: > Database Corrupt cases: > Tested on PC > > Steps > > 1) Inserted table to full disk and Reserved 1M space in disk > 2 )Release the reserved space I do not understand what you mean by the previous two steps. Can you pleae provide more detail. > 3) Begin transaction > 4) Delete table > 5) End transaction > > Then database is corrupt. > -- D. Richard Hipp <[EMAIL PROTECTED]> ----------------------------------------------------------------------------- To unsubscribe, send email to [EMAIL PROTECTED] ----------------------------------------------------------------------------- ----------------------------------------------------------------------------- To unsubscribe, send email to [EMAIL PROTECTED] -----------------------------------------------------------------------------

