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@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>