Changeset 30585 for branches/eam_branches/ipp-20101205/ippTools/share/chiptool_processedimfile.sql

Timestamp:

Feb 11, 2011, 3:54:07 PM (15 years ago)

Author:

eugene

Message:

merge changes from trunk

Location:

branches/eam_branches/ipp-20101205

Files:

• . (modified) (1 prop)
• ippTools/share/chiptool_processedimfile.sql (modified) (1 diff)

branches/eam_branches/ipp-20101205/ippTools/share/chiptool_processedimfile.sql

@@ -30 +30 @@
     rawImfile.burntool_state,
     IFNULL(magicDSRun.magic_ds_id, 0) AS magic_ds_id,
-    magicDSRun.state AS dsRun_state,
-    magicDSFile.data_state AS dsFile_data_state
+    IFNULL(magicDSRun.state,0) AS dsRun_state,
+    IFNULL(magicDSFile.fault,0) AS dsFile_fault,
+    IFNULL(magicDSFile.data_state,0) AS dsFile_data_state
 FROM chipRun
 JOIN chipImfile