Roy Golan has uploaded a new change for review. Change subject: core: No storage domains appear in drop-down of Add disk ......................................................................
core: No storage domains appear in drop-down of Add disk get_entity_parents failed when multiple DCs had an ISO domains. The failure is SQL error caused when trying to assign a single value when the return value was multiple records. Change-Id: I67a6f4f50944c8a028910e7f8a26f9c31bc6dc98 Signed-off-by: Roy Golan <[email protected]> --- M backend/manager/dbscripts/create_functions.sql 1 file changed, 1 insertion(+), 3 deletions(-) git pull ssh://gerrit.ovirt.org:29418/ovirt-engine refs/changes/70/7370/1 diff --git a/backend/manager/dbscripts/create_functions.sql b/backend/manager/dbscripts/create_functions.sql index 8f4ab72..a0776c8 100644 --- a/backend/manager/dbscripts/create_functions.sql +++ b/backend/manager/dbscripts/create_functions.sql @@ -247,13 +247,11 @@ UNION SELECT v_entity_id AS id; WHEN v_entity_type = 11 THEN -- Storage Domain - -- get data center id - ds_id := ( SELECT storage_pool_id FROM storage_pool_iso_map WHERE storage_id = v_entity_id ); RETURN QUERY SELECT system_root_id AS id UNION - SELECT ds_id AS id + SELECT storage_pool_id as id FROM storage_pool_iso_map WHERE storage_id = v_entity_id UNION SELECT v_entity_id AS id; WHEN v_entity_type = 17 THEN -- Quota -- To view, visit http://gerrit.ovirt.org/7370 To unsubscribe, visit http://gerrit.ovirt.org/settings Gerrit-MessageType: newchange Gerrit-Change-Id: I67a6f4f50944c8a028910e7f8a26f9c31bc6dc98 Gerrit-PatchSet: 1 Gerrit-Project: ovirt-engine Gerrit-Branch: master Gerrit-Owner: Roy Golan <[email protected]> _______________________________________________ Engine-patches mailing list [email protected] http://lists.ovirt.org/mailman/listinfo/engine-patches
