Changeset 23503

Timestamp:

Mar 24, 2009, 4:35:26 PM (17 years ago)

Author:

Paul Price

Message:

Fixing GROUP BY

Location:

trunk/ippTools

Files:

• share/difftool_definewarpwarp_select.sql (modified) (1 diff)
• src/difftool.c (modified) (1 diff)

trunk/ippTools/share/difftool_definewarpwarp_select.sql

@@ -23 +23 @@
     AND templateRawExp.filter = inputRawExp.filter
 -- WHERE hook %s
-GROUP BY input_id
+GROUP BY input_warp_id

trunk/ippTools/src/difftool.c

@@ -1352 +1352 @@
         psTrace("difftool", 1, "no rows found");
         psFree(results);
+        if (!psDBCommit(config->dbh)) {
+            psError(PS_ERR_UNKNOWN, false, "database error");
+            return false;
+        }
         return true;
     }