Changeset 25022 for branches/eam_branches/20090715/ippTools/share/magicdstool_torevert_diff.sql

Timestamp:

Aug 7, 2009, 12:45:24 PM (17 years ago)

Author:

eugene

Message:

update from mainline

Location:

branches/eam_branches/20090715

Files:

• . (modified) (1 prop)
• ippTools/share/magicdstool_torevert_diff.sql (modified) (2 diffs)

branches/eam_branches/20090715/ippTools/share/magicdstool_torevert_diff.sql

@@ -9 +9 @@
     outroot,
     diffSkyfile.path_base,
-    NULL AS cam_path_base,
+    "NULL" AS cam_path_base,
     0 AS bytes,
     0 AS md5sum
@@ -18 +18 @@
     JOIN rawExp USING(exp_id)
 WHERE magicDSRun.stage = 'diff'
-    AND magicDSRun.state = 'new'
+    AND (magicDSRun.state = 'new' OR magicDSRun.state = 'censored')
     AND magicDSFile.fault > 0