id	summary	reporter	owner	description	type	status	component	version	severity	resolution	keywords	cc	stage	has_patch	needs_docs	needs_tests	needs_better_patch	easy	ui_ux
24609	Concat on MySQL doesn't need the coalesce step	Adam Johnson	Adam Johnson	"The new Concat database function calls ConcatPair which does a coalesce around each argument with the empty string on sqlite and MySQL.

MySQL's CONCAT *does* return NULL if any argument is NULL, however it has a very similar function, CONCAT_WS that just silently skips NULLs. Therefore it can be used rather than unnecessary COALESCE calls: https://dev.mysql.com/doc/refman/5.5/en/string-functions.html#function_concat-ws

I've implemented this in a patch - it's not a big change."	Cleanup/optimization	closed	Database layer (models, ORM)	1.8	Normal	fixed			Ready for checkin	1	0	0	0	0	0