rel-eng/packages/spacewalk-schema
| 2 +-
schema/spacewalk/common/views/rhnServerNeededView.sql
| 8 +++++---
schema/spacewalk/spacewalk-schema.spec
| 7 ++++++-
schema/spacewalk/upgrade/spacewalk-schema-1.5-to-spacewalk-schema-1.6/002-rhnServerNeededView.sql
| 8 +++++---
4 files changed, 17 insertions(+), 8 deletions(-)
New commits:
commit b4a6e16ffd94a0199219c3e8f04a52daf76f2ce0
Author: Tomas Lestach <tlestach(a)redhat.com>
Date: Wed Aug 17 13:16:28 2011 +0200
Automatic commit of package [spacewalk-schema] release [1.6.8-1].
diff --git a/rel-eng/packages/spacewalk-schema b/rel-eng/packages/spacewalk-schema
index e2e3ede..38bfa84 100644
--- a/rel-eng/packages/spacewalk-schema
+++ b/rel-eng/packages/spacewalk-schema
@@ -1 +1 @@
-1.6.7-1 schema/spacewalk/
+1.6.8-1 schema/spacewalk/
diff --git a/schema/spacewalk/spacewalk-schema.spec
b/schema/spacewalk/spacewalk-schema.spec
index b02d72b..cff8a0b 100644
--- a/schema/spacewalk/spacewalk-schema.spec
+++ b/schema/spacewalk/spacewalk-schema.spec
@@ -2,7 +2,7 @@ Name: spacewalk-schema
Group: Applications/Internet
Summary: Oracle SQL schema for Spacewalk server
-Version: 1.6.7
+Version: 1.6.8
Release: 1%{?dist}
Source0: %{name}-%{version}.tar.gz
@@ -66,6 +66,11 @@ rm -rf $RPM_BUILD_ROOT
%{_mandir}/man1/spacewalk-sql*
%changelog
+* Wed Aug 17 2011 Tomas Lestach <tlestach(a)redhat.com> 1.6.8-1
+- 722189 - adding upgrade script (tlestach(a)redhat.com)
+- 722189 - omit updates for packages installed in several versions (like
+ kernel) (tpapaioa(a)redhat.com)
+
* Tue Aug 16 2011 Simon Lukasik <slukasik(a)redhat.com> 1.6.7-1
- Drop the old function, when creating a new one with different argumeters
(slukasik(a)redhat.com)
commit ef99debe3667de0150c2d6ab5f1a46c95466474d
Author: Tomas Lestach <tlestach(a)redhat.com>
Date: Wed Aug 17 12:19:51 2011 +0200
722189 - adding upgrade script
diff --git
a/schema/spacewalk/upgrade/spacewalk-schema-1.5-to-spacewalk-schema-1.6/002-rhnServerNeededView.sql
b/schema/spacewalk/upgrade/spacewalk-schema-1.5-to-spacewalk-schema-1.6/002-rhnServerNeededView.sql
index 5223497..ca14c4b 100644
---
a/schema/spacewalk/upgrade/spacewalk-schema-1.5-to-spacewalk-schema-1.6/002-rhnServerNeededView.sql
+++
b/schema/spacewalk/upgrade/spacewalk-schema-1.5-to-spacewalk-schema-1.6/002-rhnServerNeededView.sql
@@ -16,10 +16,12 @@ SELECT s.org_id,
up.name_id,
x.channel_id
FROM rhnServer s
- join rhnServerPackage sp ON sp.server_id = s.id
- join rhnPackageEvr pe ON pe.id = sp.evr_id
+ join (SELECT sp_sp.server_id, sp_sp.name_id, sp_sp.package_arch_id,
max(sp_pe.evr) AS max_evr
+ FROM rhnServerPackage sp_sp
+ join rhnPackageEvr sp_pe ON sp_pe.id = sp_sp.evr_id
+ GROUP BY sp_sp.server_id, sp_sp.name_id, sp_sp.package_arch_id) sp ON
sp.server_id = s.id
join rhnPackage up ON up.name_id = sp.name_id
- join rhnPackageEvr upe ON upe.id = up.evr_id AND pe.evr < upe.evr
+ join rhnPackageEvr upe ON upe.id = up.evr_id AND sp.max_evr < upe.evr
join rhnPackageUpgradeArchCompat puac ON puac.package_arch_id =
sp.package_arch_id AND puac.package_upgrade_arch_id = up.package_arch_id
join rhnServerChannel sc ON sc.server_id = sp.server_id
join rhnChannelPackage cp ON cp.package_id = up.id AND cp.channel_id =
sc.channel_id
commit 55cde50db9cf57eaebf70ace8b19c6e7919cfc24
Author: Tasos Papaioannou <tpapaioa(a)redhat.com>
Date: Wed Aug 17 12:14:57 2011 +0200
722189 - omit updates for packages installed in several versions (like kernel)
diff --git a/schema/spacewalk/common/views/rhnServerNeededView.sql
b/schema/spacewalk/common/views/rhnServerNeededView.sql
index 3655574..89d2bab 100644
--- a/schema/spacewalk/common/views/rhnServerNeededView.sql
+++ b/schema/spacewalk/common/views/rhnServerNeededView.sql
@@ -34,10 +34,12 @@ SELECT s.org_id,
up.name_id,
x.channel_id
FROM rhnServer s
- join rhnServerPackage sp ON sp.server_id = s.id
- join rhnPackageEvr pe ON pe.id = sp.evr_id
+ join (SELECT sp_sp.server_id, sp_sp.name_id, sp_sp.package_arch_id,
max(sp_pe.evr) AS max_evr
+ FROM rhnServerPackage sp_sp
+ join rhnPackageEvr sp_pe ON sp_pe.id = sp_sp.evr_id
+ GROUP BY sp_sp.server_id, sp_sp.name_id, sp_sp.package_arch_id) sp ON
sp.server_id = s.id
join rhnPackage up ON up.name_id = sp.name_id
- join rhnPackageEvr upe ON upe.id = up.evr_id AND pe.evr < upe.evr
+ join rhnPackageEvr upe ON upe.id = up.evr_id AND sp.max_evr < upe.evr
join rhnPackageUpgradeArchCompat puac ON puac.package_arch_id =
sp.package_arch_id AND puac.package_upgrade_arch_id = up.package_arch_id
join rhnServerChannel sc ON sc.server_id = sp.server_id
join rhnChannelPackage cp ON cp.package_id = up.id AND cp.channel_id =
sc.channel_id
Show replies by date