[sqlite] Multiple INSERT problem

[Demitri Muna]

Hello,
I'm getting an error that I'm not sure what to do about. (I'm using 
v3.0.4.) Starting with this table:

sqlite> create temporary table test (label);
sqlite> insert into test values ('aaa');
sqlite> insert into test values ('abb');
sqlite> insert into test values ('acc');
sqlite> insert into test values ('abc');
This returns four rows: SELECT * FROM test WHERE label LIKE '%a%';
This returns two rows: SELECT * FROM test WHERE label LIKE '%a%' 
INTERSECT SELECT * FROM test WHERE label LIKE '%b%';

This returns: SELECT * FROM test WHERE label LIKE '%a%' INTERSECT 
SELECT * FROM test WHERE label LIKE '%b%' INTERSECT SELECT * FROM test 
WHERE label LIKE '%c%';
SQL error: database disk image is malformed

Is there a limit on the number of intersects I can use? Is there a 
better way that I can accomplish the same thing?

Cheers,
Demitri