java/code/src/com/redhat/rhn/common/db/datasource/xml/Org_queries.xml | 2 +-
1 file changed, 1 insertion(+), 1 deletion(-)
New commits:
commit 17cf0aa87ebc5d2b783846e70dcc36e224f565ba
Author: Simon Lukasik <slukasik(a)redhat.com>
Date: Thu Dec 1 08:31:16 2011 +0100
758697 - PG syntax for trust_overview
Addressing:
com.redhat.rhn.common.db.datasource.CachedStatement - Error while processing
cached statement sql: SELECT org.id,
org.name,
(SELECT count(*)
FROM rhnTrustedOrgs tr
WHERE tr.org_trust_id = org.id AND
tr.org_id = ?) trusted
FROM web_customer org
WHERE org.id != ?
com.redhat.rhn.common.db.WrappedSQLException: ERROR: syntax error at or near
trusted
at
com.redhat.rhn.common.translation.SqlExceptionTranslator.postgreSqlException(SqlExceptionTranslator.java:56
at
com.redhat.rhn.common.translation.SqlExceptionTranslator.sqlException(SqlExceptionTranslator.java:45)
diff --git a/java/code/src/com/redhat/rhn/common/db/datasource/xml/Org_queries.xml
b/java/code/src/com/redhat/rhn/common/db/datasource/xml/Org_queries.xml
index 92ed6fb..eee5e4b 100644
--- a/java/code/src/com/redhat/rhn/common/db/datasource/xml/Org_queries.xml
+++ b/java/code/src/com/redhat/rhn/common/db/datasource/xml/Org_queries.xml
@@ -69,7 +69,7 @@ SELECT org.id,
(SELECT count(*)
FROM rhnTrustedOrgs tr
WHERE tr.org_trust_id = org.id AND
- tr.org_id = :org_id) trusted
+ tr.org_id = :org_id) as trusted
FROM web_customer org
WHERE org.id != :org_id
</query>
Show replies by date