Changeset 31952

Timestamp:

Jul 29, 2011, 2:57:23 PM (15 years ago)

Author:

watersc1

Message:

Edit to prevent continual re-publishing of exposures with no warpRun defined (the JOIN USING(warp_id) where warp_id IS NULL was causing problems, as NULL != NULL).

File:

• trunk/ippTools/share/dqstatstool_definebyquery.sql (modified) (2 diffs)

trunk/ippTools/share/dqstatstool_definebyquery.sql

@@ -1 +1 @@
 -- query to identify unique data to bundle
 
-SELECT DISTINCT exp_id,chip_id,cam_id,warp_id,invalid from rawExp 
+SELECT DISTINCT exp_id,chip_id,cam_id,warpRun.warp_id,invalid from rawExp 
         JOIN chipRun USING(exp_id) 
         JOIN camRun USING(chip_id) 
@@ -7 +7 @@
         LEFT OUTER JOIN fakeRun USING(cam_id) 
         LEFT OUTER JOIN warpRun USING(fake_id)
-        LEFT OUTER JOIN dqstatsContent USING (exp_id,chip_id,cam_id,warp_id)
+        LEFT OUTER JOIN dqstatsContent USING (exp_id,chip_id,cam_id)
 WHERE camRun.state = 'full'