Dhandapani Gopal has uploaded a new change for review. Change subject: engine: Fixed version check issue ......................................................................
engine: Fixed version check issue Change-Id: I0bc95eed3fd8258a431b549e4be7fae77c1ffe8e Signed-off-by: Dhandapani <[email protected]> --- M backend/manager/dbscripts/common_sp.sql 1 file changed, 3 insertions(+), 3 deletions(-) git pull ssh://gerrit.ovirt.org:29418/ovirt-engine refs/changes/13/10613/1 diff --git a/backend/manager/dbscripts/common_sp.sql b/backend/manager/dbscripts/common_sp.sql index e7f5f92..ff5d9dc 100644 --- a/backend/manager/dbscripts/common_sp.sql +++ b/backend/manager/dbscripts/common_sp.sql @@ -91,9 +91,9 @@ returns void AS $procedure$ begin - if (exists (select 1 from vdc_options where option_name ilike v_option_name and version in (v_version))) then + if (exists (select 1 from vdc_options where option_name ilike v_option_name and version in (select ID from fnSplitter(v_version)))) then begin - delete from vdc_options where option_name ilike v_option_name and version in (v_version); + delete from vdc_options where option_name ilike v_option_name and version in (select ID from fnSplitter(v_version)); end; end if; END; $procedure$ @@ -104,7 +104,7 @@ returns void AS $procedure$ BEGIN - delete from vdc_options where version in (v_version); + delete from vdc_options where version in (select ID from fnSplitter(v_version)); END; $procedure$ LANGUAGE plpgsql; -- To view, visit http://gerrit.ovirt.org/10613 To unsubscribe, visit http://gerrit.ovirt.org/settings Gerrit-MessageType: newchange Gerrit-Change-Id: I0bc95eed3fd8258a431b549e4be7fae77c1ffe8e Gerrit-PatchSet: 1 Gerrit-Project: ovirt-engine Gerrit-Branch: master Gerrit-Owner: Dhandapani Gopal <[email protected]> _______________________________________________ Engine-patches mailing list [email protected] http://lists.ovirt.org/mailman/listinfo/engine-patches
