Hi,

 From :
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=24379#c1

 > This query does not return rows where login_attempts IS NULL. It will
return accounts where login_attempts = 0

I only recently understood the behavior or NULL values in SQL queries
for NOT IN and !=.

Should be advice this in coding guide lines ?
Is there a syntax better than another : col!=value / not(col=value) ?

Best regards 🎃

--
Fridolin SOMERS <fridolin.somers@biblibre.com>
Software and system maintainer 🦄
BibLibre, France
_______________________________________________
Koha-devel mailing list
Koha-devel@lists.koha-community.org
https://lists.koha-community.org/cgi-bin/mailman/listinfo/koha-devel
website : http://www.koha-community.org/
git : http://git.koha-community.org/
bugs : http://bugs.koha-community.org/