I built the sqlite 3.2.4 code in VC60 and ran the same delete statement: delete from diagram_item where diagram_item.diagram NOT IN (select diagram.name from diagram);
This caused a dialog box: Unhandled exception in sqlite3.exe: 0xC0000005: Access Violation Clicking OK places the cursor in the function: int sqlite3VdbeFifoPop(Fifo *pFifo, i64 *pVal) at the line: *pVal = pPage->aSlot[pPage->iRead++]; The call stack is as follows: sqlite3VdbeFifoPop(Fifo * 0x0050cb54, __int64 * 0x0012f2f0) line 81 + 13 bytes sqlite3VdbeExec(Vdbe * 0x0050cae0) line 4016 + 19 bytes sqlite3_step(sqlite3_stmt * 0x0050cae0) line 209 + 9 bytes sqlite3_exec(sqlite3 * 0x004f1b70, const char * 0x0050a9a0, int (void *, int, char * *, char * *)* 0x0044b150 callback(void *, int, char * *, char * *), void * 0x0012f970, char * * 0x0012f8e8) line 79 + 9 bytes process_input(callback_data * 0x0012f970, _iobuf * 0x00000000) line 1504 + 28 bytes main(int 2, char * * 0x004f0e80) line 1790 + 14 bytes mainCRTStartup() line 206 + 25 bytes KERNEL32! 77e814c7() I hope this helps. Thanks. Shawn M. Downey MPR Associates 632 Plank Road, Suite 110 Clifton Park, NY 12065 518-371-3983 x3 (work) 860-508-5015 (cell) -----Original Message----- From: Downey, Shawn Sent: Wednesday, August 24, 2005 11:36 AM To: [email protected] Subject: RE: [sqlite] Delete crashes with Version 3.2.4 in Windows XP The database is in the mail (4MB). Thanks. Some additional background: A select with the same clause does not crash in 3.2.4. I.e., select * from diagram_item where diagram_item.diagram NOT IN (select diagram.name from diagram); 3.2.3 does not crash with the delete or the select statement. I am using the precompiled windows executable in either case. I will try to build sqlite3 under VC60 today and see if I can catch the crash in the debugger. Shawn M. Downey MPR Associates 632 Plank Road, Suite 110 Clifton Park, NY 12065 518-371-3983 x3 (work) 860-508-5015 (cell) -----Original Message----- From: D. Richard Hipp [mailto:[EMAIL PROTECTED] Sent: Wednesday, August 24, 2005 11:14 AM To: [email protected] Subject: Re: [sqlite] Delete crashes with Version 3.2.4 in Windows XP On Wed, 2005-08-24 at 10:56 -0400, Downey, Shawn wrote: > I am experiencing a repeatable crash with Sqlite 3.2.4 under Windows XP > when running the following SQL at the command line: > > delete from diagram_item where diagram_item.diagram NOT IN (select > diagram.name from diagram); > It works fine when I try it. Please send me your database if you can. Use ".dump" to convert to text, then compress the text and send private email to [EMAIL PROTECTED] -- D. Richard Hipp <[EMAIL PROTECTED]>
