Changeset 34639 for trunk

Timestamp:

Nov 1, 2012, 7:43:41 AM (14 years ago)

Author:

bills

Message:

mask out of range SecFiltFlags to avoid overflow into SMALLINT Object.[grizy]Flags

File:

• trunk/ippToPsps/jython/objectbatch.py (modified) (2 diffs)

trunk/ippToPsps/jython/objectbatch.py

@@ -115 +115 @@
 
             filterID = self.scratchDb.getFilterID(filter[1])
+
+            # NOTE: mask of cps.FLAGS is required to insure that it fits in Object.{grizy}Flags (which is 16 bits)
+            # DVO SecfiltFlags uses bit 24 (0x01 0000) which is out of range
 
             sql = "UPDATE Object JOIN \
@@ -130 +133 @@
                    ," + filter[1] + "20pct = MAG_20/1000 \
                    ," + filter[1] + "80pct = MAG_80/1000 \
-                   ," + filter[1] + "Flags = FLAGS  \
+                   ," + filter[1] + "Flags = (0x7fff & FLAGS)  \
                    ," + filter[1] + "StackDetectID = (10 * STACK_DETECT_ID) + " + str(filterID)