Bug 753170 - Search on Organization returns Postgres error.
Summary: Search on Organization returns Postgres error.
Keywords:
Status: CLOSED DUPLICATE of bug 750120
Alias: None
Product: Katello
Classification: Retired
Component: WebUI
Version: 1.0
Hardware: Unspecified
OS: Unspecified
urgent
urgent
Target Milestone: ---
: ---
Assignee: Jason E. Rist
QA Contact: Katello QA List
URL:
Whiteboard:
Depends On:
Blocks:
TreeView+ depends on / blocked
 
Reported: 2011-11-11 14:08 UTC by Eric Sammons
Modified: 2011-11-30 16:12 UTC (History)
2 users (show)

Fixed In Version:
Clone Of:
Environment:
katello-headpin-0.1.103-1.git.0.2f8b500.el6.noarch katello-headpin-all-0.1.103-1.git.0.2f8b500.el6.noarch katello-cli-headpin-0.1.12-1.git.0.cd192f2.el6.noarch
Last Closed: 2011-11-30 16:12:58 UTC
Embargoed:


Attachments (Terms of Use)

Description Eric Sammons 2011-11-11 14:08:05 UTC
Description of problem:
Applying a filter (aka a search) on organization returns a postgres error.

Version-Release number of selected component (if applicable):
katello-headpin-0.1.103-1.git.0.2f8b500.el6.noarch
katello-headpin-all-0.1.103-1.git.0.2f8b500.el6.noarch
katello-cli-headpin-0.1.12-1.git.0.cd192f2.el6.noarch


Steps to Reproduce:
1. Navigate to Organization
2. In the search box enter criteria
3. Apply filter
  
Actual results:
PGError: ERROR: column reference "name" is ambiguous LINE 1: ...ON ("organizations".id) "organizations".id, lower(name) AS a... ^ : SELECT * FROM (SELECT DISTINCT ON ("organizations".id) "organizations".id, lower(name) AS alias_0 FROM "organizations" LEFT OUTER JOIN "environments" ON "environments"."organization_id" = "organizations"."id" AND "environments"."locker" = 'f' LEFT OUTER JOIN "providers" ON "providers"."organization_id" = "organizations"."id" WHERE (("organizations"."name" ILIKE '%test%' OR "organizations"."description" ILIKE '%test%' OR "environments"."name" ILIKE '%test%' OR "environments"."description" ILIKE '%test%' OR "providers"."name" ILIKE '%test%' OR "providers"."description" ILIKE '%test%' OR "providers"."repository_url" ILIKE '%test%'))) AS id_list ORDER BY id_list.alias_0 LIMIT 25 OFFSET 0

Expected results:
Filter applied and left pane list displays only items matching criteria.


Additional info:
This appears to be a regression.

Comment 1 Corey Welton 2011-11-11 14:31:09 UTC
Possibly a dupe of bug #750120

Comment 2 Mike McCune 2011-11-30 16:12:58 UTC
Can this get re-tested since 750120 is MODIFIED?

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


Note You need to log in before you can comment on or make changes to this bug.