id	summary	reporter	owner	description	type	status	priority	milestone	component	version	severity	resolution	keywords	cc
1085	camtool -revertprocessedexp -cam_id fails: ambiguous column name in query	jester@…	jhoblitt	"I tried to revert some failed exposures but camtool fails:

$ camtool -revertprocessedexp -cam_id 2
 p_psDBRunQuery (psDB.c:837) : Failed to execute SQL query.  Error: Column 'cam_id' in where clause is ambiguous
 revertprocessedexpMode (camtool.c:874) : database error


 -> p_psDBRunQuery (psDB.c:837): Database error generated by the server
     Failed to execute SQL query.  Error: Column 'cam_id' in where clause is ambiguous
 -> revertprocessedexpMode (camtool.c:874): unknown psLib error
     database error

Same happens for exp_id and I suspect for many other column names that occur in more than one of the tables in the 'using' clause in share/ippTools/camtool_revertprocessedexp.sql

I tried the query by hand and found I had to delete things from warpRun,  which has a foreign key constraint on camProcessedExp, before I could delete the rows from camProcessedExp. I'm guessing that the same applies to what camtool has to do?"	defect	closed	high		ippTools	2.5	critical	invalid