Tal Nisan has posted comments on this change. Change subject: core: Check all attached VMs when updating shared disk boot flag ......................................................................
Patch Set 3: (1 inline comment) .................................................... File backend/manager/dbscripts/all_disks_sp.sql Line 56: Create or replace FUNCTION GetVmBootDisk(v_vm_guid UUID) RETURNS SETOF all_disks AS $procedure$ Line 57: BEGIN Line 58: RETURN QUERY SELECT all_disks.* Line 59: FROM all_disks Line 60: LEFT JOIN vm_device ON vm_device.device_id = all_disks.image_group_id The all_disks view contains LUN disks, actually the test case is with a bootable disk ;) And I took the original join from the getAllForVm query, figured there had to be a reason why someone chose to use a left join Line 61: WHERE vm_device.vm_id = v_vm_guid and boot = true; Line 62: END; $procedure$ Line 63: LANGUAGE plpgsql; Line 64: -- To view, visit http://gerrit.ovirt.org/14709 To unsubscribe, visit http://gerrit.ovirt.org/settings Gerrit-MessageType: comment Gerrit-Change-Id: I82ee07e02e08d60f559017d9f8205ab7df41c5c3 Gerrit-PatchSet: 3 Gerrit-Project: ovirt-engine Gerrit-Branch: master Gerrit-Owner: Tal Nisan <[email protected]> Gerrit-Reviewer: Alissa Bonas <[email protected]> Gerrit-Reviewer: Allon Mureinik <[email protected]> Gerrit-Reviewer: Ayal Baron <[email protected]> Gerrit-Reviewer: Daniel Erez <[email protected]> Gerrit-Reviewer: Liron Ar <[email protected]> Gerrit-Reviewer: Maor Lipchuk <[email protected]> Gerrit-Reviewer: Sergey Gotliv <[email protected]> Gerrit-Reviewer: Tal Nisan <[email protected]> Gerrit-Reviewer: Vered Volansky <[email protected]> Gerrit-Reviewer: liron aravot <[email protected]> _______________________________________________ Engine-patches mailing list [email protected] http://lists.ovirt.org/mailman/listinfo/engine-patches
