rel-eng/packages/spacewalk-schema
| 2 +-
schema/spacewalk/spacewalk-schema.spec
| 5 ++++-
schema/spacewalk/upgrade/spacewalk-schema-1.1-to-spacewalk-schema-1.2/041-update_kickstart_partitions.sql
| 2 +-
3 files changed, 6 insertions(+), 3 deletions(-)
New commits:
commit 3e75bfb56bbd3747e2ed43ad38fff11e5ca0ace5
Author: Jan Pazdziora <jpazdziora(a)redhat.com>
Date: Fri Jun 29 14:12:29 2012 +0200
Automatic commit of package [spacewalk-schema] release [1.8.57-1].
diff --git a/rel-eng/packages/spacewalk-schema b/rel-eng/packages/spacewalk-schema
index 12fb93a..da74957 100644
--- a/rel-eng/packages/spacewalk-schema
+++ b/rel-eng/packages/spacewalk-schema
@@ -1 +1 @@
-1.8.56-1 schema/spacewalk/
+1.8.57-1 schema/spacewalk/
diff --git a/schema/spacewalk/spacewalk-schema.spec
b/schema/spacewalk/spacewalk-schema.spec
index 8b04acc..4054db1 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.8.56
+Version: 1.8.57
Release: 1%{?dist}
Source0: %{name}-%{version}.tar.gz
@@ -68,6 +68,9 @@ rm -rf $RPM_BUILD_ROOT
%{_mandir}/man1/spacewalk-sql*
%changelog
+* Fri Jun 29 2012 Jan Pazdziora 1.8.57-1
+- Make the resulting data order more deterministic.
+
* Wed Jun 27 2012 Jan Pazdziora 1.8.56-1
- Besides rhnServerGroupNotes, the table source was also creating sequence --
dropping.
commit 3e4635c3507ddc002a12f5759b2dbc5708babf43
Author: Jan Pazdziora <jpazdziora(a)redhat.com>
Date: Fri Jun 29 12:14:04 2012 +0200
Make the resulting data order more deterministic.
diff --git
a/schema/spacewalk/upgrade/spacewalk-schema-1.1-to-spacewalk-schema-1.2/041-update_kickstart_partitions.sql
b/schema/spacewalk/upgrade/spacewalk-schema-1.1-to-spacewalk-schema-1.2/041-update_kickstart_partitions.sql
index a79600b..26dc560 100644
---
a/schema/spacewalk/upgrade/spacewalk-schema-1.1-to-spacewalk-schema-1.2/041-update_kickstart_partitions.sql
+++
b/schema/spacewalk/upgrade/spacewalk-schema-1.1-to-spacewalk-schema-1.2/041-update_kickstart_partitions.sql
@@ -46,7 +46,7 @@ begin
on kcn.id = kc.ks_command_name_id
where kcn.name in ('partitions', 'raids',
'volgroups', 'logvols', 'include', 'custom_partition')
and kc.kickstart_id = kickstart.kickstart_id
- order by kcn.sort_order
+ order by kcn.sort_order, kc.arguments
) loop
if length(lob_data) > 0 then
dbms_lob.append(lob_data, utl_raw.cast_to_raw(chr(10)));