Changeset 31953

Timestamp:

Jul 29, 2011, 2:58:27 PM (15 years ago)

Author:

watersc1

Message:

Fix exposure republishing when warp_id IS NULL.

File:

• tags/ipp-20110622/ippTools/share/dqstatstool_definebyquery.sql (modified) (2 diffs)

tags/ipp-20110622/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'