schema/spacewalk/oracle/procs/lookup_config_info.sql
| 2 +-
schema/spacewalk/postgres/procs/lookup_config_info.sql
| 2 +-
schema/spacewalk/upgrade/spacewalk-schema-1.6-to-spacewalk-schema-1.7/093-lookup_config_info.sql.oracle
| 2 +-
schema/spacewalk/upgrade/spacewalk-schema-1.6-to-spacewalk-schema-1.7/093-lookup_config_info.sql.postgresql
| 2 +-
4 files changed, 4 insertions(+), 4 deletions(-)
New commits:
commit d547faafaceaf5be7fb698d0e683547b9286981d
Author: Milan Zazrivec <mzazrivec(a)redhat.com>
Date: Wed Feb 29 10:25:23 2012 +0100
fix lookup_config_info return
diff --git a/schema/spacewalk/oracle/procs/lookup_config_info.sql
b/schema/spacewalk/oracle/procs/lookup_config_info.sql
index 2525507..2731dc0 100644
--- a/schema/spacewalk/oracle/procs/lookup_config_info.sql
+++ b/schema/spacewalk/oracle/procs/lookup_config_info.sql
@@ -43,11 +43,11 @@ begin
filemode_in,
selinux_ctx_in,
symlink_target_id);
+ return v_id;
exception when dup_val_on_index then
for r in lookup_cursor loop
return r.id;
end loop;
- return v_id;
end lookup_config_info;
/
show errors
diff --git a/schema/spacewalk/postgres/procs/lookup_config_info.sql
b/schema/spacewalk/postgres/procs/lookup_config_info.sql
index 7e729bd..642db04 100644
--- a/schema/spacewalk/postgres/procs/lookup_config_info.sql
+++ b/schema/spacewalk/postgres/procs/lookup_config_info.sql
@@ -1,4 +1,4 @@
--- oracle equivalent source sha1 3f919d54835de5605f895ca1c76f90e6deb80bfb
+-- oracle equivalent source sha1 bd36e5005935406b069060be7b3bef8422f1df0e
--
-- Copyright (c) 2008--2010 Red Hat, Inc.
--
diff --git
a/schema/spacewalk/upgrade/spacewalk-schema-1.6-to-spacewalk-schema-1.7/093-lookup_config_info.sql.oracle
b/schema/spacewalk/upgrade/spacewalk-schema-1.6-to-spacewalk-schema-1.7/093-lookup_config_info.sql.oracle
index 3218dfa..f0e0f52 100644
---
a/schema/spacewalk/upgrade/spacewalk-schema-1.6-to-spacewalk-schema-1.7/093-lookup_config_info.sql.oracle
+++
b/schema/spacewalk/upgrade/spacewalk-schema-1.6-to-spacewalk-schema-1.7/093-lookup_config_info.sql.oracle
@@ -51,11 +51,11 @@ begin
filemode_in,
selinux_ctx_in,
symlink_target_id);
+ return v_id;
exception when dup_val_on_index then
for r in lookup_cursor loop
return r.id;
end loop;
- return v_id;
end lookup_config_info;
/
show errors
diff --git
a/schema/spacewalk/upgrade/spacewalk-schema-1.6-to-spacewalk-schema-1.7/093-lookup_config_info.sql.postgresql
b/schema/spacewalk/upgrade/spacewalk-schema-1.6-to-spacewalk-schema-1.7/093-lookup_config_info.sql.postgresql
index 5929d14..e338921 100644
---
a/schema/spacewalk/upgrade/spacewalk-schema-1.6-to-spacewalk-schema-1.7/093-lookup_config_info.sql.postgresql
+++
b/schema/spacewalk/upgrade/spacewalk-schema-1.6-to-spacewalk-schema-1.7/093-lookup_config_info.sql.postgresql
@@ -1,4 +1,4 @@
--- oracle equivalent source sha1 c342d6d7cd96eb4c99b64d8d8449aea4c89ad10a
+-- oracle equivalent source sha1 f118d31767f85c590d0b1278b91a65b317c8a895
--
-- Copyright (c) 2008--2010 Red Hat, Inc.
--