Dear sirs, My group is working with SQLITE Version 3.7 . .and the project has to do with transformation of applications to run on a Bare PC. On a CREATE TABLE, our traversal, in terms of opcodes, inside sqlite3VdbeExec() is something like 1, 22, 25, 1, 23, 1a, 7, 24, 7, 24, 62, 27, 36, a, 37, 2b, 2b, a, 27, 15, 4a, etc. A parallel session on Visual Studios gives the same sequence but has opcode 34 instead of the highlighted 4a. Can you, out of your expertise with SQLITE tell us what could cause this difference,? Any clue would help. In going from one opcode to another, what is there to watch for, that may alter the opcode value, p1 value, p2 value or p3 value? If at all possible, I would like to speak offline with some developer in your group so I can describe a few more of our observations - my cell is (973) 332 0997, Best Regards, RKKUZO ----- Forwarded Message ----- From: "Black, Michael (IS)" <michael.bla...@ngc.com> To: u okafor <uo07...@yahoo.com>; "sqlite-users@sqlite.org" <sqlite-users@sqlite.org> Sent: Tuesday, January 3, 2012 10:22 AM Subject: RE:Fw: [sqlite] Fw: A question on sqlite processing
Why don't you try the split yourself and see if it solves the problem and then let us all know? It sure sounds like file size could be the cause. Michael D. Black Senior Scientist Advanced Analytics Directorate Advanced GEOINT Solutions Operating Unit Northrop Grumman Information Systems ________________________________ From: u okafor [uo07...@yahoo.com] Sent: Monday, January 02, 2012 4:41 PM To: sqlite-users@sqlite.org Cc: Black, Michael (IS); d...@sqlite.org Subject: EXT :Fw: [sqlite] Fw: A question on sqlite processing Is that to say that the 'split on the source file' that is yet to be made is the reason for the branching described below (see highlighted below) - can you, please, explain further, I am still lost? That question still remains a question, please help . . . And now, another . . if you don't mind . . when I tried to set a breakpoint at the definition (in sqlite3.c file) of the function,SQLITE_API u8 state = 0; intsqlite3_complete(constchar*zSql){/* Current state, using numbers defined in header comment */u8 token; not currently be hit. No executable code is associated with this line. Possible causes include: preprocessir directives or compiler/linker optimizations. I would really like dislodge/remove as many of the preprocessor directives and options for compiler/linker optimization as possible. Mine is a search project; I need to strip off the sophistication used all over to have just the bare application. Can you help me? ----- Forwarded Message ----- From: "Black, Michael (IS)" <michael.bla...@ngc.com> To: u okafor <uo07...@yahoo.com>; General Discussion of SQLite Database <sqlite-users@sqlite.org> Sent: Friday, December 30, 2011 8:17 AM Subject: RE:[sqlite] Fw: A question on sqlite processing This was just answered in another chain. Visual Studio has a 64k limit on source code files for the debugger (thanks Microsoft...a 16-bit limit?...really!). If you need to step into it use WinDbg http://msdn.microsoft.com/en-us/windows/hardware/gg463009 Nobody has done a split on the source file yet to make it < 64k. Michael D. Black Senior Scientist Advanced Analytics Directorate Advanced GEOINT Solutions Operating Unit Northrop Grumman Information Systems ________________________________ From: sqlite-users-boun...@sqlite.org [sqlite-users-boun...@sqlite.org] on behalf of u okafor [uo07...@yahoo.com] Sent: Thursday, December 29, 2011 3:24 PM To: sqlite-users@sqlite.org Subject: EXT :[sqlite] Fw: A question on sqlite processing Dear sir, I have built a project solution in Visual Studio environment (version 10) using a free amalgamation source down from SQLite website and I am debugging. My first question is - when I invoke sqlite3_complete() out of the shell.c source file, control passes into the body of sqlite3PagerSetPageSize(Pager *pPager, ..) function, a method defined in sqlite3.c file (rather than going to a function defined in sqlite3.c file as sqlite3_complete()). please explain this phenomenon and the reason behind it . . . it's a similar occurrence also with sqlite3_config. It is consistent and obviously with a reason - only I don't know what that reason is, please help Yours truly, uzo okafor ----- Forwarded Message ----- From: Richard Hipp <d...@sqlite.org> To: u okafor <uo07...@yahoo.com> Sent: Wednesday, December 28, 2011 8:45 PM Subject: Re: A question on sqlite processing On Wed, Dec 28, 2011 at 7:26 PM, u okafor <uo07...@yahoo.com> wrote: Dear sir, >I am a research student who is currently using freely downloaded software from >SQLite. >I have a few questions and would appreciate if you can call me back @ (973) >332 0997 >My questions are so simple, I promise . . >uzo okafor > > I am on travel. Questions to sqlite-users@sqlite.org will get answered quickly. -- D. Richard Hipp d...@sqlite.org _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users /* Value of the next token */I was not allowed, a message showed (moemtarily) that said 'The breakpoint will _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users