Changeset 27168 for trunk/ippTools/share/regtool_pendingcompressimfile.sql

Timestamp:

Mar 3, 2010, 3:23:12 PM (16 years ago)

Author:

watersc1

Message:

Slight bug in the updatebyquery code, in which updating an exposure with a select by state would invalidate the update of the imfiles. The sql change helps avoid this issue.

File:

• trunk/ippTools/share/regtool_pendingcompressimfile.sql (modified) (1 diff)

trunk/ippTools/share/regtool_pendingcompressimfile.sql

@@ -1 +1 @@
 SELECT rawImfile.*,rawExp.workdir,rawExp.exp_tag from rawImfile
        JOIN rawExp USING(exp_id)
-       WHERE (data_state = 'goto_compressed' OR data_state = 'goto_lossy')
+       WHERE ((data_state = 'goto_compressed' AND state = 'goto_compressed')
+           OR (data_state = 'goto_lossy' AND state = 'goto_lossy'))
 -- where hook %s
 -- limit hook %s