ofri masad has uploaded a new change for review. Change subject: core: Fix sql grammar for calculateallstorageusage ......................................................................
core: Fix sql grammar for calculateallstorageusage SQL grammar of calculateallstorageusage() function was changed to be compatible with older postgres versions (under 9.1). Change-Id: I1dd5d9532357f7dd267850ea76afae0f6c9d6257 Bug-Url: https://bugzilla.redhat.com/905891 Signed-off-by: Ofri Masad <oma...@redhat.com> --- M backend/manager/dbscripts/create_functions.sql 1 file changed, 1 insertion(+), 1 deletion(-) git pull ssh://gerrit.ovirt.org:29418/ovirt-engine refs/changes/52/11552/1 diff --git a/backend/manager/dbscripts/create_functions.sql b/backend/manager/dbscripts/create_functions.sql index 7bbf0a8..7c030f4 100644 --- a/backend/manager/dbscripts/create_functions.sql +++ b/backend/manager/dbscripts/create_functions.sql @@ -590,7 +590,7 @@ LEFT JOIN disk_image_dynamic ON images.image_guid = disk_image_dynamic.image_id LEFT JOIN storage_domain_static ON image_storage_domain_map.storage_domain_id = storage_domain_static.id WHERE quota_limitation.storage_size_gb IS NOT NULL - GROUP BY images.quota_id, storage_id,quota_limitation.id,storage_domain_static.storage_name; + GROUP BY quota_limitation.quota_id, storage_id,quota_limitation.id,storage_domain_static.storage_name,quota_limitation.storage_size_gb; END; $function$ LANGUAGE plpgsql; -- To view, visit http://gerrit.ovirt.org/11552 To unsubscribe, visit http://gerrit.ovirt.org/settings Gerrit-MessageType: newchange Gerrit-Change-Id: I1dd5d9532357f7dd267850ea76afae0f6c9d6257 Gerrit-PatchSet: 1 Gerrit-Project: ovirt-engine Gerrit-Branch: master Gerrit-Owner: ofri masad <oma...@redhat.com> _______________________________________________ Engine-patches mailing list Engine-patches@ovirt.org http://lists.ovirt.org/mailman/listinfo/engine-patches
