backend/server/rhnChannel.py | 18 +++++++++---------
1 file changed, 9 insertions(+), 9 deletions(-)
New commits:
commit 3cf5d524129038e68cf4daf4d6191e6e7ddcfff4
Author: Michael Mraka <michael.mraka(a)redhat.com>
Date: Tue Aug 16 14:48:37 2011 +0200
730452 - fixed table aliasses
fixing
SQL Error generated: ('ORA-00904: "PR"."SENSE": invalid
identifier\n', 904,
"select pp.package_id, 'provides', pp.capability_id, pp.sense, pc.name,
pc.version from rhnPackageProvides pp, rhnPackageCapability pc where
pp.package_id = :package_id and pp.capability_id = pc.id union all select
...
diff --git a/backend/server/rhnChannel.py b/backend/server/rhnChannel.py
index d3bb81f..c8af77d 100644
--- a/backend/server/rhnChannel.py
+++ b/backend/server/rhnChannel.py
@@ -1123,10 +1123,10 @@ def list_all_packages_complete_sql(channel_id):
and pr.capability_id = pc.id
union all
select
- pr.package_id,
+ prec.package_id,
'recommends',
- pr.capability_id,
- pr.sense,
+ prec.capability_id,
+ prec.sense,
pc.name,
pc.version
from
@@ -1137,10 +1137,10 @@ def list_all_packages_complete_sql(channel_id):
and prec.capability_id = pc.id
union all
select
- pr.package_id,
+ sugg.package_id,
'suggests',
- pr.capability_id,
- pr.sense,
+ sugg.capability_id,
+ sugg.sense,
pc.name,
pc.version
from
@@ -1151,10 +1151,10 @@ def list_all_packages_complete_sql(channel_id):
and sugg.capability_id = pc.id
union all
select
- pr.package_id,
+ supp.package_id,
'supplements',
- pr.capability_id,
- pr.sense,
+ supp.capability_id,
+ supp.sense,
pc.name,
pc.version
from
Show replies by date