schema/spacewalk/oracle/procs/insert_evr.sql
| 1
schema/spacewalk/postgres/procs/insert_evr.sql
| 2 -
schema/spacewalk/postgres/procs/lookup_evr.sql
| 2 -
schema/spacewalk/upgrade/spacewalk-schema-1.6-to-spacewalk-schema-1.7/096-lookup_evr.sql.oracle
| 18 ++++++++++
schema/spacewalk/upgrade/spacewalk-schema-1.6-to-spacewalk-schema-1.7/096-lookup_evr.sql.postgresql
| 2 -
5 files changed, 22 insertions(+), 3 deletions(-)
New commits:
commit 3660c63bad2505a278860864ebc2de294685e35c
Author: Milan Zazrivec <mzazrivec(a)redhat.com>
Date: Tue Feb 28 12:36:31 2012 +0100
fix insert_evr's return
diff --git a/schema/spacewalk/oracle/procs/insert_evr.sql
b/schema/spacewalk/oracle/procs/insert_evr.sql
index 4f5fec2..016ee0b 100644
--- a/schema/spacewalk/oracle/procs/insert_evr.sql
+++ b/schema/spacewalk/oracle/procs/insert_evr.sql
@@ -24,6 +24,7 @@ begin
r_in,
evr_t(e_in, v_in, r_in)) returning id into evr_id;
commit;
+ return evr_id;
end;
/
show errors
diff --git a/schema/spacewalk/postgres/procs/insert_evr.sql
b/schema/spacewalk/postgres/procs/insert_evr.sql
index fdd7cec..843564b 100644
--- a/schema/spacewalk/postgres/procs/insert_evr.sql
+++ b/schema/spacewalk/postgres/procs/insert_evr.sql
@@ -1,2 +1,2 @@
--- oracle equivalent source sha1 873017e2b56a8c100659f47d5158fcb5e0f936dd
+-- oracle equivalent source sha1 3b34c56a2f9af5419b343fde3245d9bfd6822983
-- This file is intentionally left empty.
diff --git a/schema/spacewalk/postgres/procs/lookup_evr.sql
b/schema/spacewalk/postgres/procs/lookup_evr.sql
index 1952e4d..af24ae7 100644
--- a/schema/spacewalk/postgres/procs/lookup_evr.sql
+++ b/schema/spacewalk/postgres/procs/lookup_evr.sql
@@ -1,4 +1,4 @@
--- oracle equivalent source sha1 741172a1f8f23e20540fd2b5dd50a5b193e6cab3
+-- oracle equivalent source sha1 231a317e7ec144399cc913861269e968d41b8840
--
-- Copyright (c) 2008--2012 Red Hat, Inc.
--
diff --git
a/schema/spacewalk/upgrade/spacewalk-schema-1.6-to-spacewalk-schema-1.7/096-lookup_evr.sql.oracle
b/schema/spacewalk/upgrade/spacewalk-schema-1.6-to-spacewalk-schema-1.7/096-lookup_evr.sql.oracle
index ac2a8af..90e2348 100644
---
a/schema/spacewalk/upgrade/spacewalk-schema-1.6-to-spacewalk-schema-1.7/096-lookup_evr.sql.oracle
+++
b/schema/spacewalk/upgrade/spacewalk-schema-1.6-to-spacewalk-schema-1.7/096-lookup_evr.sql.oracle
@@ -1,3 +1,21 @@
+create or replace function insert_evr(e_in in varchar2, v_in in varchar2, r_in in
varchar2)
+return number
+is
+ pragma autonomous_transaction;
+ evr_id number;
+begin
+ insert into rhnPackageEVR(id, epoch, version, release, evr)
+ values (rhn_pkg_evr_seq.nextval,
+ e_in,
+ v_in,
+ r_in,
+ evr_t(e_in, v_in, r_in)) returning id into evr_id;
+ commit;
+ return evr_id;
+end;
+/
+show errors
+
create or replace function
lookup_evr(e_in in varchar2, v_in in varchar2, r_in in varchar2)
return number
diff --git
a/schema/spacewalk/upgrade/spacewalk-schema-1.6-to-spacewalk-schema-1.7/096-lookup_evr.sql.postgresql
b/schema/spacewalk/upgrade/spacewalk-schema-1.6-to-spacewalk-schema-1.7/096-lookup_evr.sql.postgresql
index ab27070..88d9ccb 100644
---
a/schema/spacewalk/upgrade/spacewalk-schema-1.6-to-spacewalk-schema-1.7/096-lookup_evr.sql.postgresql
+++
b/schema/spacewalk/upgrade/spacewalk-schema-1.6-to-spacewalk-schema-1.7/096-lookup_evr.sql.postgresql
@@ -1,4 +1,4 @@
--- oracle equivalent source sha1 d6056fb46cefe089db3dead9e49d58defa74cd08
+-- oracle equivalent source sha1 6ec664be14c5ce243efe64643024138b2864c8eb
--
-- Copyright (c) 2008--2012 Red Hat, Inc.
--
Show replies by date