Given the following table:
BEGIN TRANSACTION;
CREATE TABLE chain( a integer, b integer);
INSERT INTO "chain" VALUES(1,2);
INSERT INTO "chain" VALUES(2,3);
INSERT INTO "chain" VALUES(3,4);
INSERT INTO "chain" VALUES(2,8);
INSERT INTO "chain" VALUES(1,5);
COMMIT;
select * from chain where ( a=2 and (b&8) and !(b&4)) ;
SQL error: unrecognized token: "!("
SQLite documentation indicates that "!" is a unary prefix operator. Is this a
bug?
Vs:
sqlite> select * from chain where ( a=2 and (b&8) and not (b&4)) ;
a|b
2|8
Regards,
Ken
