[sqlite] Windows port problem

[Ron Aaron]

Hi -

2.8.12 crashes (mingw version on Windows) ((it works fine on Linux))

Do this :

sqlite < bad.sql

Where bad.sql is:

CREATE TABLE emails (id, text);
INSERT INTO emails VALUES(1,'hi');
INSERT INTO emails VALUES(2,'there');

CREATE TABLE flags (flag, name);
INSERT INTO flags values (1, 'drop');
INSERT INTO flags values (2, 'whatever');
INSERT INTO flags values (4, 'noemail');

CREATE TABLE people (id, last, flag);
INSERT INTO people values (1,'use', 2);
INSERT INTO people values (2,'me', 1);
INSERT INTO people values (3,'sowhat', 4);

SELECT text
FROM emails
WHERE text != ''
AND id IN 
        (
        SELECT id FROM people 
        WHERE last like 'use%'
        AND NOT FLAG & 
                (
                SELECT sum(flag) FROM flags
                WHERE  name in ('drop', 'noemail')
                )
        );


---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]