Just as expected. You are comparing INTEGER to TEXT values. '4' is a text value, not an integer.
-----Ursprüngliche Nachricht----- Von: sqlite-users [mailto:[email protected]] Im Auftrag von Maurice van der Stee Gesendet: Donnerstag, 29. November 2018 14:46 An: [email protected] Betreff: [EXTERNAL] [sqlite] Strange query results. This reproduces the issue for me: create table config (config_package integer, config_flags integer); insert into config (config_package, config_flags) values (1, 2); insert into config (config_package, config_flags) values (2, 4); insert into config (config_package, config_flags) values (3, 6); select config_package, config_flags, (config_flags & '4') from config where (config_flags & '4') != '4'; This produces: 1|2|0 2|4|4 3|6|4 While it should only have returned the first row. -- =============================== Maurice van der Stee ([email protected]) _______________________________________________ sqlite-users mailing list [email protected] http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users ___________________________________________ Gunter Hick | Software Engineer | Scientific Games International GmbH | Klitschgasse 2-4, A-1130 Vienna | FN 157284 a, HG Wien, DVR: 0430013 | (O) +43 1 80100 - 0 May be privileged. May be confidential. Please delete if not the addressee. _______________________________________________ sqlite-users mailing list [email protected] http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
