Hi Richard,

Thank you for quick reply.

Actually I am reading from that file only, but I didn't get the concept
of 'Cell' that is mentioned as...
" The payload for an entry and the preceding pointer are combined to
form a "Cell".

Can you please help me to clarify this.

Actually I got some bug in sqlite-3.5.9 for NFS pages (disk image
malformed) so I was debugging the same, and came across this.
The bug is as follow, which I posted in 'sqlite-...@sqlite.org',
awaiting reply...
=== sqlite-3.5.9 bug ===
I using sqlite-3.5.9 and observing a 'disk image malformed' error after
executing several sql statements.
After debugging found that the in sqlite3BtreeInitPage() it returns with
SQLITE_CORRUPT_BKPT based on some condition (see below)...

SQLITE_PRIVATE int sqlite3BtreeInitPage( 
 MemPage *pPage,        /* The page to be initialized */
 MemPage *pParent       /* The parent.  Might be NULL */
){
     ...
     if( pPage->nCell==0 && pParent!=0 && pParent->pgno!=1 ){
     /* All pages must have at least one cell, except for root pages */
     return SQLITE_CORRUPT_BKPT;
     }
     ...
}

So I some doubts, is this condition required? if required what does it
checks?
Also if you have any workaround, please let me know.
Please let me know from which version of sqlite this bug has been
resolved.
=== sqlite-3.5.9 bug ===

I appreciate you help to understand this bug.


Thank you.
-Hiral 

-----Original Message-----
From: sqlite-users-boun...@sqlite.org
[mailto:sqlite-users-boun...@sqlite.org] On Behalf Of D. Richard Hipp
Sent: Thursday, May 28, 2009 6:23 PM
To: General Discussion of SQLite Database
Subject: Re: [sqlite] SQLite3 question


On May 28, 2009, at 8:43 AM, Oza, Hiral_Dineshbhai wrote:
>
> Can you please let me know meaning of 'Cell' in Btrees used in  
> sqlite3.

See line 43 of the btreeInt.h source file for the definition.  You  
will want to read the previous 42 lines of that same file for context.

D. Richard Hipp
d...@hwaci.com



_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Reply via email to