Just out of curiosity: what are you need it for? Do you think that
it's necessary to use SQLite properly?
Pavel
On Tue, Mar 23, 2010 at 8:01 AM, Navaneeth Sen B
<navanee...@tataelxsi.co.in> wrote:
> Hello all,
>
> I am new to SQLite software. I have understood the structure of SQLite
> as described in the "Architecture of SQLite" manual.
> I am now reading the document named "The Virtual Database Engine of
> SQLite" which I got from the
> SQLite site.
> Currently i am working on Fedora 11 machine with SQLite version 3.6.20.
> I have a doubt while reading the VDBE program.
>
> sqlite> CREATE TABLE sample2(one char, two int, three float);
> sqlite> EXPLAIN INSERT INTO sample2 VALUES('Sen',685,87.6);
>
> addr opcode p1 p2 p3 p4 p5 comment
> ---- ------------- ---- ---- ---- -------------
> -- -------------
> 0 Trace 0 0 0 00
> 1 Goto 0 11 0 00
> 2 OpenWrite 0 3 0 3 00
> 3 NewRowid 0 2 0 00
> 4 String8 0 3 0 Sen 00
> 5 Integer 685 4 0 00
> 6 Real 0 5 0 87.6 00
> 7 MakeRecord 3 3 6 ade 00
> 8 Insert 0 6 2 sample2 1b
> 9 Close 0 0 0 00
> 10 Halt 0 0 0 00
> 11 Transaction 0 1 0 00
> 12 VerifyCookie 0 4 0 00
> 13 TableLock 0 3 1 sample2 00
> 14 Goto 0 2 0 00
>
> I have many doubts as the vdbe program structure is different from the
> one explained in the document. The document is for SQLite 2.8.0.
>
> Now the area where i need more clarifications are :
>
> * OpenWrite
> * MakeRecord
> * Stack operations happening when you do a MakeRecord
> * NewRowid
> * Insert
> * TableLock
>
> I would like to know the function of each operands in the above stated
> cases and the related stack operations.
>
>
> --
> Regards,
> *Navaneeth Sen B.*
>
> _______________________________________________
> 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
