commit 3d8cc63bc32ee374d22e42de44619bdce65c5e33
author Wei Zhou <weizhou@apache.org> Tue Oct 03 10:45:47 2023 +0200
committer GitHub <noreply@github.com> Tue Oct 03 10:45:47 2023 +0200
tree b06ff34721aec0b16adf3b66369c9e2ac08f7c37
parent 96205a51ef918313ad8b3288758e15184a710b91

server: fix mysql error when list Shared templates for project (#8020)

server/src/main/java/com/cloud/api/query/QueryManagerImpl.java

diff --git a/server/src/main/java/com/cloud/api/query/QueryManagerImpl.java b/server/src/main/java/com/cloud/api/query/QueryManagerImpl.java
index c288659..08f18fa 100644
--- a/server/src/main/java/com/cloud/api/query/QueryManagerImpl.java
+++ b/server/src/main/java/com/cloud/api/query/QueryManagerImpl.java
@@ -3758,6 +3758,9 @@
                 }
             } else if (templateFilter == TemplateFilter.sharedexecutable || templateFilter == TemplateFilter.shared) {
                 // only show templates shared by others
+                if (permittedAccounts.isEmpty()) {
+                    return new Pair<>(new ArrayList<>(), 0);
+                }
                 sc.addAnd("sharedAccountId", SearchCriteria.Op.IN, permittedAccountIds.toArray());
             } else if (templateFilter == TemplateFilter.executable) {
                 SearchCriteria<TemplateJoinVO> scc = _templateJoinDao.createSearchCriteria();