Changeset 9489

Timestamp:

Oct 11, 2006, 12:09:59 PM (20 years ago)

Author:

jhoblitt

Message:

fix -tonormalizedstat so that HAVING can see the approprate fields

File:

• trunk/ippTools/src/dettool.c (modified) (2 diffs)

trunk/ippTools/src/dettool.c

@@ -1725 +1725 @@
 
     psString query = psStringCopy(
-        "SELECT DISTINCT"
+        "SELECT" 
+        "   det_id,"
+        "   det_type,"
+        "   iteration,"
+        "   camera"
+        " FROM"
+        "(SELECT DISTINCT"
         "   detRun.det_id,"
         "   detRun.det_type,"
         "   detRun.iteration,"
-        "   rawDetrendExp.camera"
-// XXX determine if these fields are truely visible to HAVING without
-// explicitly selecting them
-//        "   rawDetrendExp.imfiles,"
-//        "   detStackedImfile.class_id"
+        "   rawDetrendExp.camera,"
+        "   rawDetrendExp.imfiles,"
+        "   detStackedImfile.class_id"
         " FROM detRun"
         " JOIN detInputExp"
@@ -1757 +1761 @@
         "   detRun.det_id"
         " HAVING MAX(rawDetrendExp.imfiles) = COUNT(detStackedImfile.class_id)"
+        ") as tonormalizedstat"
         );