camtool -revertprocessedexp -cam_id fails: ambiguous column name in query

[jester@…]

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?

[jhoblitt]

I think this bug report has gone stale as we now have the cleanup routines.