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
[email protected]
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
