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]>
