Allon Mureinik has uploaded a new change for review. Change subject: core: Restore storage_pool_id to storage_domain_for_search ......................................................................
core: Restore storage_pool_id to storage_domain_for_search In commit a7caea90, data center uuid for storage search was removed. This fix returns it when the SD is attach to a single DC. Change-Id: I24cbfe91073f888d58d44b853aca94d0024ef917 Bug-Url: https://bugzilla.redhat.com/1166182 Signed-off-by: Allon Mureinik <amure...@redhat.com> --- M packaging/dbscripts/create_views.sql 1 file changed, 3 insertions(+), 2 deletions(-) git pull ssh://gerrit.ovirt.org:29418/ovirt-engine refs/changes/27/35627/1 diff --git a/packaging/dbscripts/create_views.sql b/packaging/dbscripts/create_views.sql index 24c9a11..e480fbf 100644 --- a/packaging/dbscripts/create_views.sql +++ b/packaging/dbscripts/create_views.sql @@ -355,7 +355,7 @@ WHEN status_table.is_multi_domain THEN NULL WHEN status_table.status IS NULL THEN 2 -- in case domain is unattached ELSE status_table.status END as status, - null::uuid as storage_pool_id, + status_table.storage_pool_ids[1] as storage_pool_id, status_table.pool_names AS storage_pool_name, storage_domain_dynamic.available_disk_size as available_disk_size, storage_domain_dynamic.used_disk_size as used_disk_size, @@ -372,7 +372,8 @@ (SELECT storage_id, count(storage_id) > 1 AS is_multi_domain, max(storage_pool_iso_map.status) AS status, - array_to_string(array_agg(storage_pool.name), ',') AS pool_names + array_to_string(array_agg(storage_pool.name), ',') AS pool_names, + CASE WHEN COUNT(distinct storage_pool.id) = 1 THEN array_agg(storage_pool.id) ELSE NULL END as storage_pool_ids FROM storage_pool_iso_map JOIN storage_pool ON storage_pool_iso_map.storage_pool_id = storage_pool.id GROUP BY storage_id) AS status_table ON storage_domain_static.id=status_table.storage_id -- To view, visit http://gerrit.ovirt.org/35627 To unsubscribe, visit http://gerrit.ovirt.org/settings Gerrit-MessageType: newchange Gerrit-Change-Id: I24cbfe91073f888d58d44b853aca94d0024ef917 Gerrit-PatchSet: 1 Gerrit-Project: ovirt-engine Gerrit-Branch: master Gerrit-Owner: Allon Mureinik <amure...@redhat.com> _______________________________________________ Engine-patches mailing list Engine-patches@ovirt.org http://lists.ovirt.org/mailman/listinfo/engine-patches
