Daniel Erez has uploaded a new change for review. Change subject: core: GetAllAttachableDisks - filter Illegal disks (#851201) ......................................................................
core: GetAllAttachableDisks - filter Illegal disks (#851201) https://bugzilla.redhat.com/851201 GetAllAttachableDisksByPoolId stored procedure: filter out disks in status Illegal. Change-Id: Ia302712c7c49f0818bbb44e46339b8e5867ce69c Signed-off-by: Daniel Erez <de...@redhat.com> --- M backend/manager/dbscripts/all_disks_sp.sql 1 file changed, 1 insertion(+), 0 deletions(-) git pull ssh://gerrit.ovirt.org:29418/ovirt-engine refs/changes/89/7589/1 diff --git a/backend/manager/dbscripts/all_disks_sp.sql b/backend/manager/dbscripts/all_disks_sp.sql index 564382d..b454b92 100644 --- a/backend/manager/dbscripts/all_disks_sp.sql +++ b/backend/manager/dbscripts/all_disks_sp.sql @@ -60,6 +60,7 @@ FROM all_disks WHERE (v_storage_pool_id IS NULL OR all_disks.storage_pool_id = v_storage_pool_id) AND (all_disks.number_of_vms = 0 OR all_disks.shareable) + AND (all_disks.imagestatus IS NULL OR all_disks.imagestatus != 4) AND (v_vm_id IS NULL OR v_vm_id NOT IN (SELECT vm_id FROM vm_device WHERE vm_device.device_id = all_disks.image_group_id)) AND (NOT v_is_filtered OR EXISTS (SELECT 1 FROM user_disk_permissions_view -- To view, visit http://gerrit.ovirt.org/7589 To unsubscribe, visit http://gerrit.ovirt.org/settings Gerrit-MessageType: newchange Gerrit-Change-Id: Ia302712c7c49f0818bbb44e46339b8e5867ce69c Gerrit-PatchSet: 1 Gerrit-Project: ovirt-engine Gerrit-Branch: master Gerrit-Owner: Daniel Erez <de...@redhat.com> _______________________________________________ Engine-patches mailing list Engine-patches@ovirt.org http://lists.ovirt.org/mailman/listinfo/engine-patches
