GaOrtiga commented on code in PR #9531:
URL: https://github.com/apache/cloudstack/pull/9531#discussion_r3453983929
##########
engine/schema/src/main/java/com/cloud/capacity/dao/CapacityDaoImpl.java:
##########
@@ -87,6 +87,13 @@ public class CapacityDaoImpl extends
GenericDaoBase<CapacityVO, Long> implements
"LEFT JOIN dedicated_resources dr_cluster ON
dr_cluster.cluster_id IS NOT NULL AND dr_cluster.cluster_id = host.cluster_id "
+
"LEFT JOIN dedicated_resources dr_host ON dr_host.host_id
IS NOT NULL AND dr_host.host_id = host.id ";
+ private static final String
ORDER_CLUSTERS_BY_AGGREGATE_CAPACITY_INCLUDE_DEDICATED_JOIN_CLAUSE =
+ "JOIN host ON capacity.host_id = host.id " +
+ "LEFT JOIN (SELECT affinity_group.id, agvm.instance_id
FROM affinity_group_vm_map agvm JOIN affinity_group ON agvm.affinity_group_id =
affinity_group.id AND affinity_group.type='ExplicitDedication') AS ag ON
ag.instance_id = ? " +
+ "LEFT JOIN dedicated_resources dr_pod ON dr_pod.pod_id IS
NOT NULL AND dr_pod.pod_id = host.pod_id AND dr_pod.account_id IS NOT NULL AND
dr_pod.account_id != ownerId " +
Review Comment:
I'll run a test, been a while since I altered this query, so I might be
confusing
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: [email protected]
For queries about this service, please contact Infrastructure at:
[email protected]
