[cloudstack] 01/01: API: Fix listSSHKeyPairs API when listing all resources (listall=true & projectid=-1)

[pe...@apache.org]

This is an automated email from the ASF dual-hosted git repository.

pearl11594 pushed a commit to branch fix-list-sshkeys-proj
in repository https://gitbox.apache.org/repos/asf/cloudstack.git

commit c20aa99ca4e5d375c28b32d66c1833c3f9573dd1
Author: Pearl Dsilva <pe...@gmail.com>
AuthorDate: Wed Dec 29 13:42:31 2021 +0530

    API: Fix listSSHKeyPairs API when listing all resources (listall=true & projectid=-1)
---
 framework/db/src/main/java/com/cloud/utils/db/GenericDaoBase.java | 4 +++-
 1 file changed, 3 insertions(+), 1 deletion(-)

diff --git a/framework/db/src/main/java/com/cloud/utils/db/GenericDaoBase.java b/framework/db/src/main/java/com/cloud/utils/db/GenericDaoBase.java
index 7d1b7b7..8d69d4d 100644
--- a/framework/db/src/main/java/com/cloud/utils/db/GenericDaoBase.java
+++ b/framework/db/src/main/java/com/cloud/utils/db/GenericDaoBase.java
@@ -41,6 +41,7 @@ import java.util.Date;
 import java.util.Enumeration;
 import java.util.HashMap;
 import java.util.List;
+import java.util.Locale;
 import java.util.Map;
 import java.util.TimeZone;
 import java.util.UUID;
@@ -1293,7 +1294,8 @@ public abstract class GenericDaoBase<T, ID extends Serializable> extends Compone
             fromIndex += onClause.length();
         }
 
-        str.delete(str.length() - 4, str.length());
+        int diff =  str.toString().trim().toLowerCase(Locale.ROOT).endsWith("where") ? 6 : 4;
+        str.delete(str.length() - diff, str.length());
 
         for (JoinBuilder<SearchCriteria<?>> join : joins) {
             if (join.getT().getJoins() != null) {