id	summary	reporter	owner	description	type	status	priority	milestone	component	version	severity	resolution	keywords	cc
1356	ippTools sql files should use @WORD@ replacement instead of %s hooks	eugene	eugene	"in various places, the sql includes commented-out segments with a string format statement (eg, -- WHERE HOOK %s) which is replaced with some optional code block by the c program (eg, a where clause).  This mechanism is fragile, esp since the sql wildcard is %.  The new replacement is to use a special word in the sql statement (@WORD@) that is then explicitly replaced in the c code with a statement of the form psStringSubstitute(&query,whereClause,""@WORD@"").

see example of the latter code in magictool_restore_diff.sql / magictool.c
"	defect	assigned	low		ippTools		normal