Changeset 38397 for trunk/ippToPsps/jython/objectbatch.py

Timestamp:

Jun 5, 2015, 5:09:21 PM (11 years ago)

Author:

heather

Message:

schema 21 / sas 39 ipptopsps - random now float/double, forced object column names changed to be less confusing

File:

• trunk/ippToPsps/jython/objectbatch.py (modified) (1 diff)

trunk/ippToPsps/jython/objectbatch.py

@@ -364 +364 @@
         sqlLine.group("ippObjID",        "OBJ_ID + (CAT_ID << 32)") # NOTE: shift by 32 bits exactly
         sqlLine.group("surveyID",        "'" + str(self.surveyID) + "'")
-        sqlLine.group("randomID",        "FLOOR(RAND("+str(self.batchID)+")*9223372036854775807)") # XXX where does this number come from??
+        sqlLine.group("randomID",        "RAND("+str(self.batchID)+")") # XXX where does this number come from??
         sqlLine.group("batchID",         "'" + str(self.batchID) + "'")
         sqlLine.group("dvoRegionID",     "CAT_ID")