Shireesh Anjal has uploaded a new change for review. Change subject: gluster: Modify calls to fnSplitterUuid ......................................................................
gluster: Modify calls to fnSplitterUuid Patch http://gerrit.ovirt.org/9825 changed the definition of the SP fnSplitterUuid in such a way that the older calls to this SP, that looked like: select ID from fnSplitterUuid(v_ids) no longer work, and now need to be changed to something like: select * from fnSplitterUuid(v_ids) While this change was done in most of the *_sp.sql scripts, it was missed out in gluster_volumes_sp.sql Changing it now in gluster_volumes_sp.sql Change-Id: I824aedc908cfc0a67ea2fa5ea57dd14eecb865ce Bug-Url: https://bugzilla.redhat.com/show_bug.cgi?id=901531 Signed-off-by: Shireesh Anjal <[email protected]> --- M backend/manager/dbscripts/gluster_volumes_sp.sql 1 file changed, 3 insertions(+), 3 deletions(-) git pull ssh://gerrit.ovirt.org:29418/ovirt-engine refs/changes/99/11799/1 diff --git a/backend/manager/dbscripts/gluster_volumes_sp.sql b/backend/manager/dbscripts/gluster_volumes_sp.sql index 4cc74c3..8d04b91 100644 --- a/backend/manager/dbscripts/gluster_volumes_sp.sql +++ b/backend/manager/dbscripts/gluster_volumes_sp.sql @@ -213,7 +213,7 @@ AS $procedure$ BEGIN DELETE FROM gluster_volumes - WHERE id in (select ID from fnSplitterUuid(v_volume_ids)); + WHERE id in (select * from fnSplitterUuid(v_volume_ids)); END; $procedure$ LANGUAGE plpgsql; @@ -252,7 +252,7 @@ AS $procedure$ BEGIN DELETE FROM gluster_volume_bricks - WHERE id in (select ID from fnSplitterUuid(v_ids)); + WHERE id in (select * from fnSplitterUuid(v_ids)); END; $procedure$ LANGUAGE plpgsql; @@ -270,7 +270,7 @@ AS $procedure$ BEGIN DELETE FROM gluster_volume_options - WHERE id in (select ID from fnSplitterUuid(v_ids)); + WHERE id in (select * from fnSplitterUuid(v_ids)); END; $procedure$ LANGUAGE plpgsql; -- To view, visit http://gerrit.ovirt.org/11799 To unsubscribe, visit http://gerrit.ovirt.org/settings Gerrit-MessageType: newchange Gerrit-Change-Id: I824aedc908cfc0a67ea2fa5ea57dd14eecb865ce Gerrit-PatchSet: 1 Gerrit-Project: ovirt-engine Gerrit-Branch: engine_3.2 Gerrit-Owner: Shireesh Anjal <[email protected]> _______________________________________________ Engine-patches mailing list [email protected] http://lists.ovirt.org/mailman/listinfo/engine-patches
