https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=29664
Andrii Nugged <[email protected]> changed: What |Removed |Added ---------------------------------------------------------------------------- CC| |[email protected] --- Comment #20 from Andrii Nugged <[email protected]> --- Follow-up bug note: $whereTType .= q{ AND status != 'VOID' }; This makes MariaDB act unexpectedly: statuses with NULL are also skipped! When I added this to our piloting production: $whereTType .= q{ AND (status IS NULL OR status != 'VOID') }; it started to show those accountlines which has NULLs. Reasoning: https://mariadb.com/kb/en/null-values/ SELECT NULL != 'VOID', 'VOID' != 'VOID', 'TOTAL' != 'VOID'; +----------------+------------------+-------------------+ | NULL != 'VOID' | 'VOID' != 'VOID' | 'TOTAL' != 'VOID' | +----------------+------------------+-------------------+ | NULL | 0 | 1 | +----------------+------------------+-------------------+ -- You are receiving this mail because: You are watching all bug changes. _______________________________________________ Koha-bugs mailing list [email protected] https://lists.koha-community.org/cgi-bin/mailman/listinfo/koha-bugs website : http://www.koha-community.org/ git : http://git.koha-community.org/ bugs : http://bugs.koha-community.org/
