Changeset 27859 for trunk/ippTools

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

Location:

trunk/ippTools/share

Files:

• pstamptool_completedreq.sql (modified) (1 diff)
• pstamptool_pendingdependent.sql (modified) (1 diff)

trunk/ippTools/share/pstamptool_completedreq.sql

@@ -1 +1 @@
 SELECT pstampRequest.* ,
-    IFNULL(labels.priority, 0) AS priority
+    IFNULL(Label.priority, 0) AS priority
 FROM pstampRequest 
-    LEFT JOIN labels USING(label) 
+    LEFT JOIN Label USING(label) 
 WHERE state = 'run'
     AND (

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