[sqlite] Delete crashes with Version 3.2.4 in Windows XP

[Downey, Shawn]

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);

The schemas in question are:

CREATE TABLE diagram 
  (
    name varchar(24) not null ,
    syst varchar(10) not null ,
    long_name varchar(50),
    version varchar(16),
    rev varchar(4)
  );
CREATE INDEX fk_a_680 on diagram (syst);
CREATE UNIQUE INDEX pk_diagram on diagram (name);

CREATE TABLE diagram_item 
  (
    diagram varchar(24) not null ,
    item varchar(24),
    glyph char(512)
  );
CREATE INDEX fk_di_d_diagram on diagram_item (diagram);
CREATE INDEX fk_di_i_item on diagram_item (item);

There are 91 records in diagram and 160754 records in diagram_item.

Shawn M. Downey
MPR Associates
632 Plank Road, Suite 110
Clifton Park, NY 12065
518-371-3983 x3 (work)
860-508-5015 (cell)