commit 40019a635c432251b7dce462402402aa41d8678e
author Rainer Döbele <doebele@apache.org> Thu Sep 22 12:12:02 2022 +0200
committer Rainer Döbele <doebele@apache.org> Thu Sep 22 12:12:02 2022 +0200
tree 92e119eec8e964cb1431cca1751f34aaa7424fc1
parent 465a0b4d23b9bf06ad901d7c80c37f4415342c44

EMPIREDB-396 fix queryRowCount for parameterized aggregate queries

empire-db/src/main/java/org/apache/empire/db/DBUtils.java

diff --git a/empire-db/src/main/java/org/apache/empire/db/DBUtils.java b/empire-db/src/main/java/org/apache/empire/db/DBUtils.java
index 783d7a3..5b393cd 100644
--- a/empire-db/src/main/java/org/apache/empire/db/DBUtils.java
+++ b/empire-db/src/main/java/org/apache/empire/db/DBUtils.java
@@ -482,7 +482,7 @@
             DBCommand subCmd = cmd.clone();
             subCmd.clearOrderBy();
             String sql = "SELECT COUNT(*) FROM ("+subCmd.getSelect() + ") q";
-            return querySingleInt(sql, null, 0);
+            return querySingleInt(sql, subCmd.getParamValues(), 0);
         }
         // find any rowset
         DBRowSet rs = exprList[0].getSourceColumn().getRowSet();