Bug 1120707

Summary: Autocompletion for product on content search produces sql error
Product: Red Hat Satellite Reporter: Ivan Necas <inecas>
Component: Content ManagementAssignee: Brad Buckingham <bbuckingham>
Status: CLOSED DUPLICATE QA Contact: Katello QA List <katello-qa-list>
Severity: high Docs Contact:
Priority: unspecified    
Version: 6.0.3CC: bbuckingham, bkearney, djuran, sthirugn
Target Milestone: Unspecified   
Target Release: Unused   
Hardware: Unspecified   
OS: Unspecified   
Whiteboard:
Fixed In Version: Doc Type: Bug Fix
Doc Text:
Story Points: ---
Clone Of: Environment:
Last Closed: 2014-08-11 18:51:11 UTC Type: Bug
Regression: --- Mount Type: ---
Documentation: --- CRM:
Verified Versions: Category: ---
oVirt Team: --- RHEL 7.3 requirements from Atomic Host:
Cloudforms Team: --- Target Upstream Version:
Embargoed:
Attachments:
Description Flags
Product autocomplete error none

Description Ivan Necas 2014-07-17 14:06:43 UTC 
Steps to Reproduce:
1. UI -> Content Search
2. Search by Product
3. Type anything in the search part (autocomplete)


Actual results:
The exception:

PGError: ERROR: column reference "id" is ambiguous LINE 1: SELECT id FROM "katello_products" INNER JOIN "katello_reposi... ^ : SELECT id FROM "katello_products" INNER JOIN "katello_repositories" ON "katello_repositories"."product_id" = "katello_products"."id" INNER JOIN "katello_content_view_versions" ON "katello_content_view_versions"."id" = "katello_repositories"."content_view_version_id" WHERE "katello_content_view_versions"."content_view_id" IN (1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11) (ActiveRecord::StatementInvalid)

is shown

Expected results:
no exceptions

Additional info:
Comment 2 sthirugn@redhat.com 2014-07-29 19:25:36 UTC 
This also gives me an UI error (see attachment)
Comment 3 sthirugn@redhat.com 2014-07-29 19:26:07 UTC 
Created attachment 922297 [details]
Product autocomplete error
Comment 4 Brad Buckingham 2014-08-11 18:51:11 UTC 

*** This bug has been marked as a duplicate of bug 1115308 ***