[prev in list] [next in list] [prev in thread] [next in thread] 

List:       spacewalk-commits
Subject:    schema/spacewalk
From:       mzazrive () fedoraproject ! org (Milan Zazrivec)
Date:       2012-02-29 9:26:14
Message-ID: 20120229092614.625421586 () lists ! fedorahosted ! org
[Download RAW message or body]

 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 at 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.
 --


[prev in list] [next in list] [prev in thread] [next in thread]