I try both.
Depending on the data deleting or rewriting, I get 2 empty column, or just
empty(no column).
???:Richard Hippdrh at sqlite.org
???:SQLite mailing listsqlite-users at mailinglists.sqlite.org
:2015?12?2?(??)?21:31
??:Re: [sqlite] Why Corrupted DB File Cause No Error?
On 12
listsqlite-users at mailinglists.sqlite.org
:2015?12?2?(??)?19:42
??:Re: [sqlite] Why Corrupted DB File Cause No Error?
On 2 Dec 2015, at 11:38am, Stephan Beal sgbeal at googlemail.com wrote: On
Wed, Dec 2, 2015 at 11:59 AM, sanhua.zh sanhua.zh at foxmail.com wrote: Why
it does not show error
:2015?12?2?(??)?19:38
??:Re: [sqlite] Why Corrupted DB File Cause No Error?
On Wed, Dec 2, 2015 at 11:59 AM, sanhua.zh sanhua.zh at foxmail.com wrote: Why
it does not show error, some thing like?Error: database disk image is
malformed?? Is it a bug in SQLite? because you didn't corrupt a
I make a database, create a table and insert some data.
And then delete a section of data manually using binary editor, result that I
can?t get any of column but SQLite does not give me a error message.
console log before db file corrupted:
sqlite .open test.db
sqlite select * from testtable;
au
On Wed, Dec 2, 2015 at 12:56 PM, sanhua.zh wrote:
> I guess so too.
> But, It can be happen in real scene.
>
A part of data may be lost by a low chance accident in the application
> lifecycle. It would be very hard to find out this problem and fix it
> because of causing no error.
>
It's a hyp
On Wed, Dec 2, 2015 at 11:59 AM, sanhua.zh wrote:
> Why it does not show error, some thing like?Error: database disk image is
> malformed?? Is it a bug in SQLite?
>
because you didn't corrupt a part it actually read. Imagine if you have a
20GB db and you expect it to report such errors when you
On 2 Dec 2015, at 11:38am, Stephan Beal wrote:
> On Wed, Dec 2, 2015 at 11:59 AM, sanhua.zh wrote:
>
>> Why it does not show error, some thing like?Error: database disk image is
>> malformed?? Is it a bug in SQLite?
>
> because you didn't corrupt a part it actually read.
Looking at the trans
On 12/2/15, sanhua.zh wrote:
> I make a database, create a table and insert some data.
> And then delete a section of data manually using binary editor,
Did you really "delete" the data, or did you simply change the data to
have all NULL content?
--
D. Richard Hipp
drh at sqlite.org
8 matches
Mail list logo