Changeset 23842 for trunk/ippTools/share/disttool_processedcomponent.sql

Timestamp:

Apr 13, 2009, 4:32:41 PM (17 years ago)

Author:

bills

Message:

modes to disttool for creating rcDSFileset objects
tweaks to the rcDSFileset and rcDSProduct tables

File:

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

trunk/ippTools/share/disttool_processedcomponent.sql

@@ -1 @@
-SELECT *
-FROM    distComponent
+SELECT 
+    dist_id,
+    target_id,
+    stage,
+    stage_id,
+    component,
+    CONCAT_WS('.', outroot, CONVERT(dist_id, CHAR)) as outdir,
+    bytes,
+    md5sum,
+    name,
+    distComponent.state,
+    distComponent.fault
+FROM    distRun
+JOIN distComponent USING(dist_id)