rel-eng/packages/spacewalk-schema
| 2
schema/spacewalk/spacewalk-schema.spec
| 6 +
schema/spacewalk/upgrade/spacewalk-schema-2.0-to-spacewalk-schema-2.1/051-rhnServerOutdatedPackages.sql
| 44 ++++++++++
3 files changed, 50 insertions(+), 2 deletions(-)
New commits:
commit 392f66c0de52d0ac69a45936d6923083b0c6114b
Author: Michael Mraka <michael.mraka(a)redhat.com>
Date: Fri Feb 21 11:52:00 2014 +0100
Automatic commit of package [spacewalk-schema] release [2.1.48-1].
diff --git a/rel-eng/packages/spacewalk-schema b/rel-eng/packages/spacewalk-schema
index 7bfff01..5d711ef 100644
--- a/rel-eng/packages/spacewalk-schema
+++ b/rel-eng/packages/spacewalk-schema
@@ -1 +1 @@
-2.1.47-1 schema/spacewalk/
+2.1.48-1 schema/spacewalk/
diff --git a/schema/spacewalk/spacewalk-schema.spec
b/schema/spacewalk/spacewalk-schema.spec
index 61721cd..2f00a65 100644
--- a/schema/spacewalk/spacewalk-schema.spec
+++ b/schema/spacewalk/spacewalk-schema.spec
@@ -4,7 +4,7 @@ Name: spacewalk-schema
Group: Applications/Internet
Summary: Oracle SQL schema for Spacewalk server
-Version: 2.1.47
+Version: 2.1.48
Release: 1%{?dist}
Source0: %{name}-%{version}.tar.gz
@@ -71,6 +71,10 @@ rm -rf $RPM_BUILD_ROOT
%{_mandir}/man1/spacewalk-sql*
%changelog
+* Fri Feb 21 2014 Michael Mraka <michael.mraka(a)redhat.com> 2.1.48-1
+- improved performance of system.listLatestUpgradeablePackages and
+ UpgradableList.do
+
* Tue Feb 18 2014 Milan Zazrivec <mzazrivec(a)redhat.com> 2.1.47-1
- 1063821 - update rhnServer after queue_server to avoid a deadlock
commit d3525546d50eda2d02f2b81eb14094ff4e3b8f30
Author: Michael Mraka <michael.mraka(a)redhat.com>
Date: Fri Feb 21 11:49:57 2014 +0100
rhnServerOutdatedPackages schema upgrade script
for change 2a11191e20de5d0fa751f61fd59e82d903242238
diff --git
a/schema/spacewalk/upgrade/spacewalk-schema-2.0-to-spacewalk-schema-2.1/051-rhnServerOutdatedPackages.sql
b/schema/spacewalk/upgrade/spacewalk-schema-2.0-to-spacewalk-schema-2.1/051-rhnServerOutdatedPackages.sql
new file mode 100644
index 0000000..d1a4ba4
--- /dev/null
+++
b/schema/spacewalk/upgrade/spacewalk-schema-2.0-to-spacewalk-schema-2.1/051-rhnServerOutdatedPackages.sql
@@ -0,0 +1,44 @@
+--
+-- Copyright (c) 2008 Red Hat, Inc.
+--
+-- This software is licensed to you under the GNU General Public License,
+-- version 2 (GPLv2). There is NO WARRANTY for this software, express or
+-- implied, including the implied warranties of MERCHANTABILITY or FITNESS
+-- FOR A PARTICULAR PURPOSE. You should have received a copy of GPLv2
+-- along with this software; if not, see
+--
http://www.gnu.org/licenses/old-licenses/gpl-2.0.txt.
+--
+-- Red Hat trademarks are not licensed under GPLv2. No permission is
+-- granted to use or replicate Red Hat trademarks that are incorporated
+-- in this software or its documentation.
+--
+
+CREATE OR REPLACE VIEW
+rhnServerOutdatedPackages
+(
+ server_id,
+ package_name_id,
+ package_evr_id,
+ package_arch_id,
+ package_nvre,
+ errata_id,
+ errata_advisory
+)
+AS
+SELECT DISTINCT SNPC.server_id,
+ P.name_id,
+ P.evr_id,
+ PN.name || '-' || evr_t_as_vre_simple( PE.evr ),
+ E.id,
+ E.advisory
+ FROM rhnPackageName PN,
+ rhnPackageEVR PE,
+ rhnPackage P,
+ rhnServerNeededPackageCache SNPC
+ left outer join
+ rhnErrata E
+ on SNPC.errata_id = E.id
+ WHERE SNPC.package_id = P.id
+ AND P.name_id = PN.id
+ AND P.evr_id = PE.id;
+