vendredi 12 juin 2015

SQLite bug in WHERE clause

Can anyone confirm that this is a bug?

CREATE TABLE meta 
 meta_id INTEGER PRIMARY KEY, 
 localAbsPathAndName TEXT, 
 purgeGUID TEXT 
);

INSERT INTO meta (localAbsPathAndName) VALUES ('C:\some\path');
INSERT INTO meta (localAbsPathAndName) VALUES ('C:\some\path');

SELECT * FROM  meta WHERE purgeGUID!='aa5de571c9da5e3995b63427f5d23aad'

incorrectly returns no rows

Aucun commentaire:

Enregistrer un commentaire