> Le 29 nov. 2018 à 14:45, Maurice van der Stee <s...@planet.nl> a écrit : > > 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.
Just like this? select config_package, config_flags, (config_flags & 4) from config where (config_flags & 4) != 4; 1|2|0 -- Best Regards, Meilleures salutations, Met vriendelijke groeten, Olivier Mascia _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users