ofri masad has uploaded a new change for review. Change subject: core: Fix sql syntax for quota ......................................................................
core: Fix sql syntax for quota calculateAllVdsGroupUsage function was fixed to be compatible with lower postgres versions (verified on version 8.4.13) Change-Id: I9eed6757ac4a9ed891792929be902aa628d62f59 Bug-Url: https://bugzilla.redhat.com/905891 Signed-off-by: Ofri Masad <[email protected]> --- M backend/manager/dbscripts/create_functions.sql 1 file changed, 2 insertions(+), 1 deletion(-) git pull ssh://gerrit.ovirt.org:29418/ovirt-engine refs/changes/89/12289/1 diff --git a/backend/manager/dbscripts/create_functions.sql b/backend/manager/dbscripts/create_functions.sql index 7c030f4..2b5b401 100644 --- a/backend/manager/dbscripts/create_functions.sql +++ b/backend/manager/dbscripts/create_functions.sql @@ -561,7 +561,8 @@ LEFT JOIN vds_groups ON vds_groups.vds_group_id = vm_static.vds_group_id WHERE quota_limitation.virtual_cpu IS NOT NULL AND quota_limitation.mem_size_mb IS NOT NULL - GROUP BY vm_static.quota_id, vds_groups.vds_group_id, vm_static.vds_group_id, quota_limitation.id; + GROUP BY quota_limitation.quota_id, quota_limitation.vds_group_id, vds_group_name, quota_limitation.virtual_cpu, quota_limitation.mem_size_mb, + vm_static.quota_id, vds_groups.vds_group_id, vm_static.vds_group_id, quota_limitation.id; END; $function$ LANGUAGE plpgsql; -- To view, visit http://gerrit.ovirt.org/12289 To unsubscribe, visit http://gerrit.ovirt.org/settings Gerrit-MessageType: newchange Gerrit-Change-Id: I9eed6757ac4a9ed891792929be902aa628d62f59 Gerrit-PatchSet: 1 Gerrit-Project: ovirt-engine Gerrit-Branch: master Gerrit-Owner: ofri masad <[email protected]> _______________________________________________ Engine-patches mailing list [email protected] http://lists.ovirt.org/mailman/listinfo/engine-patches
