java/code/src/com/redhat/rhn/common/db/datasource/xml/Package_queries.xml | 8
++++----
1 file changed, 4 insertions(+), 4 deletions(-)
New commits:
commit 3e7398371a0222ac9c93b63f47a7d48aac8e934a
Author: Jan Pazdziora <jpazdziora(a)redhat.com>
Date: Thu Mar 10 14:11:29 2011 +0100
Subquery in FROM must have an alias in PostgreSQL.
Addressing
Caused by: com.redhat.rhn.common.db.WrappedSQLException: ERROR: subquery in FROM must
have an alias
Hint: For example, FROM (SELECT ...) [AS] foo.
Position: 59
at
com.redhat.rhn.common.translation.SqlExceptionTranslator.postgreSqlException(SqlExceptionTranslator.java:56)
at
com.redhat.rhn.common.translation.SqlExceptionTranslator.sqlException(SqlExceptionTranslator.java:45)
at
com.redhat.rhn.common.db.NamedPreparedStatement.execute(NamedPreparedStatement.java:141)
at
com.redhat.rhn.common.db.datasource.CachedStatement.execute(CachedStatement.java:453)
at
com.redhat.rhn.common.db.datasource.CachedStatement.execute(CachedStatement.java:430)
at
com.redhat.rhn.common.db.datasource.CachedStatement.execute(CachedStatement.java:336)
at
com.redhat.rhn.common.db.datasource.CachedStatement.execute(CachedStatement.java:289)
at
com.redhat.rhn.common.db.datasource.SelectMode.execute(SelectMode.java:142)
at
com.redhat.rhn.manager.rhnpackage.PackageManager.lookupPackageNameOverview(PackageManager.java:793)
at
com.redhat.rhn.frontend.action.channel.PackageNameOverviewAction.execute(PackageNameOverviewAction.java:75)
at
org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcessor.java:425)
... 40 more
diff --git a/java/code/src/com/redhat/rhn/common/db/datasource/xml/Package_queries.xml
b/java/code/src/com/redhat/rhn/common/db/datasource/xml/Package_queries.xml
index 88948a3..53bbd39 100644
--- a/java/code/src/com/redhat/rhn/common/db/datasource/xml/Package_queries.xml
+++ b/java/code/src/com/redhat/rhn/common/db/datasource/xml/Package_queries.xml
@@ -1478,7 +1478,7 @@ SELECT NVREA, PACKAGE_ID, CHANNEL_NAME, CHANNEL_ID
AND P.id = CP.package_id
AND C.id = AC.channel_id
AND PA.id = P.package_arch_id
- )
+ ) X
ORDER BY CHANNEL_NAME DESC, EVR DESC
</query>
@@ -1514,7 +1514,7 @@ SELECT NVREA, PACKAGE_ID, CHANNEL_NAME, CHANNEL_ID
AND P.id = CP.package_id
AND C.id = AC.channel_id
AND PA.id = P.package_arch_id
- )
+ ) X
ORDER BY CHANNEL_NAME DESC, EVR DESC
</query>
</mode>
@@ -1549,7 +1549,7 @@ SELECT NVREA, PACKAGE_ID, CHANNEL_NAME, CHANNEL_ID
AND P.id = CP.package_id
AND C.id = AC.channel_id
AND PA.id = P.package_arch_id
- )
+ ) X
ORDER BY CHANNEL_NAME DESC, EVR DESC
</query>
</mode>
@@ -1584,7 +1584,7 @@ SELECT NVREA, PACKAGE_ID, CHANNEL_NAME, CHANNEL_ID
AND P.id = CP.package_id
AND C.id = AC.channel_id
AND PA.id = P.package_arch_id
- )
+ ) X
ORDER BY CHANNEL_NAME DESC, EVR DESC
</query>
</mode>