schema/spacewalk/common/views/rhnOrgDistChannelMap.sql
| 8 ++++----
schema/spacewalk/upgrade/spacewalk-schema-1.7-to-spacewalk-schema-1.8/147-rhnOrgDistChannelMap.sql
| 8 ++++----
2 files changed, 8 insertions(+), 8 deletions(-)
New commits:
commit 2f9e75ced2aaf3c67b45ef19b239ddc4d73bc7f7
Author: Jan Pazdziora <jpazdziora(a)redhat.com>
Date: Wed Oct 31 09:08:15 2012 +0100
Fixing syntax.
Addressing
CREATE VIEW
ERROR: syntax error at or near "release"
LINE 17: ... NOT NULL THEN dcm_o.release ELSE dcm_n.release END release,
^
diff --git a/schema/spacewalk/common/views/rhnOrgDistChannelMap.sql
b/schema/spacewalk/common/views/rhnOrgDistChannelMap.sql
index 9777f4f..bbb6bd7 100644
--- a/schema/spacewalk/common/views/rhnOrgDistChannelMap.sql
+++ b/schema/spacewalk/common/views/rhnOrgDistChannelMap.sql
@@ -1,5 +1,5 @@
--
--- Copyright (c) 2008 Red Hat, Inc.
+-- Copyright (c) 2012 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
@@ -30,9 +30,9 @@ SELECT CASE WHEN dcm_o.org_id IS NOT NULL THEN dcm_o.id ELSE dcm_n.id
END id,
o.id as for_org_id,
dcm_o.org_id,
CASE WHEN dcm_o.org_id IS NOT NULL THEN dcm_o.os ELSE dcm_n.os END os,
- CASE WHEN dcm_o.org_id IS NOT NULL THEN dcm_o.release ELSE dcm_n.release END
release,
- CASE WHEN dcm_o.org_id IS NOT NULL THEN dcm_o.channel_arch_id ELSE
dcm_n.channel_arch_id END channel_arch_id,
- CASE WHEN dcm_o.org_id IS NOT NULL THEN dcm_o.channel_id ELSE dcm_n.channel_id
END channel_id
+ CASE WHEN dcm_o.org_id IS NOT NULL THEN dcm_o.release ELSE dcm_n.release END as
release,
+ CASE WHEN dcm_o.org_id IS NOT NULL THEN dcm_o.channel_arch_id ELSE
dcm_n.channel_arch_id END as channel_arch_id,
+ CASE WHEN dcm_o.org_id IS NOT NULL THEN dcm_o.channel_id ELSE dcm_n.channel_id
END as channel_id
FROM web_customer o
JOIN (SELECT DISTINCT release, channel_arch_id from rhnDistChannelMap) dcm ON 1 = 1
LEFT JOIN rhnDistChannelMap dcm_n ON dcm_n.org_id IS NULL
diff --git
a/schema/spacewalk/upgrade/spacewalk-schema-1.7-to-spacewalk-schema-1.8/147-rhnOrgDistChannelMap.sql
b/schema/spacewalk/upgrade/spacewalk-schema-1.7-to-spacewalk-schema-1.8/147-rhnOrgDistChannelMap.sql
index 9777f4f..bbb6bd7 100644
---
a/schema/spacewalk/upgrade/spacewalk-schema-1.7-to-spacewalk-schema-1.8/147-rhnOrgDistChannelMap.sql
+++
b/schema/spacewalk/upgrade/spacewalk-schema-1.7-to-spacewalk-schema-1.8/147-rhnOrgDistChannelMap.sql
@@ -1,5 +1,5 @@
--
--- Copyright (c) 2008 Red Hat, Inc.
+-- Copyright (c) 2012 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
@@ -30,9 +30,9 @@ SELECT CASE WHEN dcm_o.org_id IS NOT NULL THEN dcm_o.id ELSE dcm_n.id
END id,
o.id as for_org_id,
dcm_o.org_id,
CASE WHEN dcm_o.org_id IS NOT NULL THEN dcm_o.os ELSE dcm_n.os END os,
- CASE WHEN dcm_o.org_id IS NOT NULL THEN dcm_o.release ELSE dcm_n.release END
release,
- CASE WHEN dcm_o.org_id IS NOT NULL THEN dcm_o.channel_arch_id ELSE
dcm_n.channel_arch_id END channel_arch_id,
- CASE WHEN dcm_o.org_id IS NOT NULL THEN dcm_o.channel_id ELSE dcm_n.channel_id
END channel_id
+ CASE WHEN dcm_o.org_id IS NOT NULL THEN dcm_o.release ELSE dcm_n.release END as
release,
+ CASE WHEN dcm_o.org_id IS NOT NULL THEN dcm_o.channel_arch_id ELSE
dcm_n.channel_arch_id END as channel_arch_id,
+ CASE WHEN dcm_o.org_id IS NOT NULL THEN dcm_o.channel_id ELSE dcm_n.channel_id
END as channel_id
FROM web_customer o
JOIN (SELECT DISTINCT release, channel_arch_id from rhnDistChannelMap) dcm ON 1 = 1
LEFT JOIN rhnDistChannelMap dcm_n ON dcm_n.org_id IS NULL
Show replies by date