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