java/code/src/com/redhat/rhn/common/db/datasource/xml/Errata_queries.xml | 2 +-
1 file changed, 1 insertion(+), 1 deletion(-)
New commits:
commit 66ca926bea3e7f48e6b40532648df0cbe58999b2
Author: Milan Zazrivec <mzazrivec(a)redhat.com>
Date: Mon Dec 23 13:55:20 2013 +0100
Remove extraneous character from query
This is to fix:
...
java.sql.SQLSyntaxErrorException: ORA-00911: invalid character
diff --git a/java/code/src/com/redhat/rhn/common/db/datasource/xml/Errata_queries.xml b/java/code/src/com/redhat/rhn/common/db/datasource/xml/Errata_queries.xml
index bf964c3..8e3af2b 100644
--- a/java/code/src/com/redhat/rhn/common/db/datasource/xml/Errata_queries.xml
+++ b/java/code/src/com/redhat/rhn/common/db/datasource/xml/Errata_queries.xml
@@ -487,7 +487,7 @@ SELECT DISTINCT E.id, E.advisory_name AS advisory,
and S.user_id = :user_id
and S.label = 'channels_for_errata'
and E.id not in (select errata_id from rhnChannelErrata where channel_id = :custom_cid)
- and E.id not in (select original_id from rhnChannelErrata CE, rhnErrataCloned EC where CE.errata_id = EC.id and CE.channel_id = :custom_cid);
+ and E.id not in (select original_id from rhnChannelErrata CE, rhnErrataCloned EC where CE.errata_id = EC.id and CE.channel_id = :custom_cid)
</query>
</mode>