http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=8164 Priority: P5 - low Change sponsored?: --- Bug ID: 8164 Assignee: gmcharlt@gmail.com Blocks: 7365 Summary: Replace IFNULL() with COALESCE() in all database calls Severity: enhancement Classification: Unclassified OS: All Reporter: koha.sekjal@gmail.com Hardware: All Status: NEW Version: master Component: Architecture, internals, and plumbing Product: Koha Koha uses IFNULL() in 5 places in it's SQL; this is not standard SQL, and isn't compatible with all databases. The COALESCE() function is supported by: DB2: http://publib.boulder.ibm.com/infocenter/dzichelp/v2r2/topic/com.ibm.db2.doc... Microsoft SQL Server: http://msdn.microsoft.com/en-us/library/aa258244.aspx MySQL: http://dev.mysql.com/doc/refman/5.0/en/control-flow-functions.html#function_... Oracle: http://download.oracle.com/docs/cd/B28359_01/server.111/b28286/functions023.... PostgreSQL: http://www.postgresql.org/docs/8.1/static/functions-conditional.html#AEN1265... and SQLite: http://www.sqlite.org/lang_corefunc.html And probably others (from http://www.nomadjourney.com/2009/04/database-independent-django-queries-coal...) -- You are receiving this mail because: You are watching all bug changes.