Bug 8164

Summary: Replace IFNULL() with COALESCE() in all database calls
Product: Koha Reporter: Ian Walls <koha.sekjal>
Component: Architecture, internals, and plumbingAssignee: Jonathan Druart <jonathan.druart>
Status: CLOSED FIXED QA Contact: Marcel de Rooy <m.de.rooy>
Severity: enhancement    
Priority: P5 - low CC: chris, jcamins, jonathan.druart, m.de.rooy
Version: 3.12   
Hardware: All   
OS: All   
See Also: https://bugzilla.mozilla.org/show_bug.cgi?id=253357
Change sponsored?: --- Patch complexity: Trivial patch
Documentation contact: Documentation submission:
Text to go in the release notes:
Version(s) released in:
Bug Depends on:    
Bug Blocks: 7365    
Attachments: Bug 8164: Replace IFNULL with COALESCE
Bug 8164: Replace IFNULL with COALESCE
Signed patch

Comment 1 Jonathan Druart 2012-08-23 14:38:42 UTC Comment hidden (obsolete)
Comment 2 Chris Cormack 2012-08-23 22:14:02 UTC Comment hidden (obsolete)
Comment 3 Jared Camins-Esakov 2012-10-06 04:20:42 UTC
Changing target version so this bug report will show up in the list of 3.12-targeted features and doesn't get lost in the shuffle during feature freeze.
Comment 4 Marcel de Rooy 2012-11-26 11:34:08 UTC
Tested Acquisition Late Orders and Lists.
Comment 5 Marcel de Rooy 2012-11-26 11:34:52 UTC
Created attachment 13676 [details] [review]
Signed patch
Comment 6 Marcel de Rooy 2012-11-26 11:37:35 UTC
QA Comment: Works. Small patch improving code. Looks good to me.
Passed QA
Comment 7 Jared Camins-Esakov 2012-11-29 00:08:47 UTC
This patch has been pushed to master.