Changeset 32671

Timestamp:

Nov 15, 2011, 12:48:12 PM (15 years ago)

Author:

bills

Message:

fix very bad bug in sql for chiptool -dropprocessedimfile

File:

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

trunk/ippTools/share/chiptool_dropprocessedimfile_delete.sql

@@ -2 +2 @@
     USING magicDSRun, magicDSFile, chipRun, chipProcessedImfile
 WHERE chipRun.chip_id = chipProcessedImfile.chip_id
-    AND magicDSRun.stage ='chip' and magicDSRun.stage_id = chipRun.chip_id
-    AND magicDSFile.magic_ds_id = magicDSFile.magic_ds_id
+    AND magicDSRun.stage ='chip'
+    AND magicDSRun.stage_id = chipRun.chip_id
+    AND magicDSRun.magic_ds_id = magicDSFile.magic_ds_id
     AND magicDSFile.component = chipProcessedImfile.class_id