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: I64e0ea2dd7bfb03494aa0346d2aa24b226a99452 Bug-Url: https://bugzilla.redhat.com/show_bug.cgi?id=901531 Signed-off-by: Shireesh Anjal <san...@redhat.com> --- 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/69/11169/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/11169 To unsubscribe, visit http://gerrit.ovirt.org/settings Gerrit-MessageType: newchange Gerrit-Change-Id: I64e0ea2dd7bfb03494aa0346d2aa24b226a99452 Gerrit-PatchSet: 1 Gerrit-Project: ovirt-engine Gerrit-Branch: master Gerrit-Owner: Shireesh Anjal <san...@redhat.com> _______________________________________________ Engine-patches mailing list Engine-patches@ovirt.org http://lists.ovirt.org/mailman/listinfo/engine-patches
