java/code/src/com/redhat/rhn/common/db/datasource/xml/config_queries.xml | 21
++++------
1 file changed, 9 insertions(+), 12 deletions(-)
New commits:
commit f7f3e189d88729f2d0fea552b1dd012ff6793a20
Author: Partha Aji <paji(a)redhat.com>
Date: Fri Aug 27 16:33:51 2010 -0400
Removed unnecessary NVLs from a config query
diff --git a/java/code/src/com/redhat/rhn/common/db/datasource/xml/config_queries.xml
b/java/code/src/com/redhat/rhn/common/db/datasource/xml/config_queries.xml
index c007ac1..f814f88 100644
--- a/java/code/src/com/redhat/rhn/common/db/datasource/xml/config_queries.xml
+++ b/java/code/src/com/redhat/rhn/common/db/datasource/xml/config_queries.xml
@@ -1943,33 +1943,30 @@ SELECT CC.id AS ID,
<query name="elaborator_config_channel_file_dir_count">
SELECT CC.id AS ID,
- NVL( (
- SELECT COUNT(CF.id)
+ (SELECT COUNT(CF.id)
FROM rhnConfigFile CF
INNER JOIN rhnConfigRevision CR ON CR.id = CF.latest_config_revision_id
INNER JOIN rhnConfigFileType CFT ON CFT.ID = CR.CONFIG_FILE_TYPE_ID
WHERE CF.config_channel_id = CC.id
AND CF.latest_config_revision_id IS NOT NULL
- AND CFT.LABEL = 'file'
- ), 0) AS files_only_count,
- NVL( (
- SELECT COUNT(CF.id)
+ AND CFT.LABEL = 'file')
+ AS files_only_count,
+ (SELECT COUNT(CF.id)
FROM rhnConfigFile CF
INNER JOIN rhnConfigRevision CR ON CR.id = CF.latest_config_revision_id
INNER JOIN rhnConfigFileType CFT ON CFT.ID = CR.CONFIG_FILE_TYPE_ID
WHERE CF.config_channel_id = CC.id
AND CF.latest_config_revision_id IS NOT NULL
- AND CFT.LABEL = 'symlink'
- ), 0) AS symlinks_only_count,
- NVL( (
- SELECT COUNT(CF.id)
+ AND CFT.LABEL = 'symlink')
+ AS symlinks_only_count,
+ (SELECT COUNT(CF.id)
FROM rhnConfigFile CF
INNER JOIN rhnConfigRevision CR ON CR.id = CF.latest_config_revision_id
INNER JOIN rhnConfigFileType CFT ON CFT.ID = CR.CONFIG_FILE_TYPE_ID
WHERE CF.config_channel_id = CC.id
AND CF.latest_config_revision_id IS NOT NULL
- AND CFT.LABEL = 'directory'
- ), 0) AS dirs_only_count
+ AND CFT.LABEL = 'directory')
+ AS dirs_only_count
FROM rhnConfigChannel CC
WHERE CC.id IN (%s)
</query>
Show replies by date