Changeset 27859 for trunk/ippTools/share/pstamptool_pendingdependent.sql

Timestamp:

May 4, 2010, 4:10:59 PM (16 years ago)

Author:

watersc1

Message:

Fix typos in pstamptool database queries.
Add pstampDependent.outdir entry to changes.txt.

Final tested code for detectability server.
Works on test cases that involve updates.

r

File:

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

trunk/ippTools/share/pstamptool_pendingdependent.sql

@@ -4 +4 @@
 JOIN pstampJob USING(dep_id)
 JOIN pstampRequest USING(req_id)
-JOIN Label ON pstampRequest.label = Label.label
+LEFT JOIN Label ON pstampRequest.label = Label.label
 WHERE pstampDependent.state = 'new'
     AND pstampDependent.fault = 0