| Summary: | Search on Organization returns Postgres error. | ||
|---|---|---|---|
| Product: | [Retired] Katello | Reporter: | Eric Sammons <esammons> |
| Component: | WebUI | Assignee: | Jason E. Rist <jrist> |
| Status: | CLOSED DUPLICATE | QA Contact: | Katello QA List <katello-qa-list> |
| Severity: | urgent | Docs Contact: | |
| Priority: | urgent | ||
| Version: | 1.0 | CC: | cwelton, mmccune |
| Target Milestone: | --- | ||
| Target Release: | --- | ||
| Hardware: | Unspecified | ||
| OS: | Unspecified | ||
| Whiteboard: | |||
| Fixed In Version: | Doc Type: | Bug Fix | |
| Doc Text: | Story Points: | --- | |
| 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 | Type: | --- |
| Regression: | --- | Mount Type: | --- |
| Documentation: | --- | CRM: | |
| Verified Versions: | Category: | --- | |
| oVirt Team: | --- | RHEL 7.3 requirements from Atomic Host: | |
| Cloudforms Team: | --- | Target Upstream Version: | |
Possibly a dupe of bug #750120 Can this get re-tested since 750120 is MODIFIED? *** This bug has been marked as a duplicate of bug 750120 *** |
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.