[Koha-bugs] [Bug 23081] Make items.issues and deleteditems.issues default to 0 instead of null
bugzilla-daemon at bugs.koha-community.org
bugzilla-daemon at bugs.koha-community.org
Mon Apr 27 01:54:59 CEST 2020
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=23081
Andrew Fuerste-Henry <andrew at bywatersolutions.com> changed:
What |Removed |Added
----------------------------------------------------------------------------
Attachment #103608|0 |1
is obsolete| |
--- Comment #11 from Andrew Fuerste-Henry <andrew at bywatersolutions.com> ---
Created attachment 103725
-->
https://bugs.koha-community.org/bugzilla3/attachment.cgi?id=103725&action=edit
Bug 23081: set default to 0 for items.issues and deleteditems.issues
To test:
- save and run this sql query in reports: select sum(if(issues is
null,1,0)),sum(if(issues=0,1,0)) from items
- you should see a lot of nulls and no zeros
- apply patch
- updatedatabase
- re-run your query and see that your nulls have changed to zeros
- create a new item
- rerun your query and see your new item is counted in the zeros, not the nulls
--
You are receiving this mail because:
You are watching all bug changes.
More information about the Koha-bugs
mailing list