Changeset 29982 for branches/czw_branch/20101203/ippTools/share/chiptool_find_rawexp.sql

Timestamp:

Dec 8, 2010, 7:21:36 PM (16 years ago)

Author:

watersc1

Message:

rtbt works in test case up through auto-chip-queue

File:

• branches/czw_branch/20101203/ippTools/share/chiptool_find_rawexp.sql (modified) (1 diff)

branches/czw_branch/20101203/ippTools/share/chiptool_find_rawexp.sql

@@ -1 +1 @@
 -- this query is used to find potental rawExps to be queued for chiptool
 -- processeing
-SELECT
+SELECT DISTINCT 
     rawExp.*,
     newExp.label
 FROM rawExp
 JOIN newExp using (exp_id)
+LEFT JOIN chipRun USING (exp_id)
 WHERE
     rawExp.fault = 0