Changeset 43096 for branches/eam_branches/ipp-pstamp-20260421/ippTools/src/difftool.c

Timestamp:

Sep 22, 2026, 3:10:37 PM (3 days ago)

Author:

eugene

Message:

SELECT DISTINCT with UNION needs grouping parentheses in modern SQL

File:

• branches/eam_branches/ipp-pstamp-20260421/ippTools/src/difftool.c (modified) (1 diff)

branches/eam_branches/ipp-pstamp-20260421/ippTools/src/difftool.c

@@ -2883 +2883 @@
     if (limit) {
         psString limitString = psDBGenerateLimitSQL(limit);
-        psStringAppend(&query, " %s", limitString);
-        psStringSubstitute(&query,limitString,"@INNERLIMITS@");
+        // psStringAppend(&query, " %s", limitString);
+        psStringSubstitute(&query, limitString, "@INNERLIMITS@");
         psFree(limitString);
 
     }
     else {
-      psStringSubstitute(&query,NULL,"@INNERLIMITS@");
+      psStringSubstitute(&query ,NULL, "@INNERLIMITS@");
     }
     //    fprintf(stderr,"%s",query);