| Summary: | Attempting to Filter on Organizations throws postgresql error | ||
|---|---|---|---|
| Product: | Red Hat Satellite | Reporter: | Corey Welton <cwelton> |
| Component: | WebUI | Assignee: | Brad Buckingham <bbuckingham> |
| Status: | CLOSED CURRENTRELEASE | QA Contact: | Katello QA List <katello-qa-list> |
| Severity: | unspecified | Docs Contact: | |
| Priority: | unspecified | ||
| Version: | 6.0.1 | CC: | abenari, esammons, gkhachik, gstoecke, mmccune |
| Target Milestone: | Unspecified | Keywords: | TestBlocker, Triaged |
| Target Release: | Unused | ||
| Hardware: | Unspecified | ||
| OS: | Unspecified | ||
| Whiteboard: | |||
| Fixed In Version: | Doc Type: | Bug Fix | |
| Doc Text: | Story Points: | --- | |
| Clone Of: | Environment: |
postgresql
|
|
| Last Closed: | 2012-08-22 18:03:39 UTC | Type: | --- |
| Regression: | --- | Mount Type: | --- |
| Documentation: | --- | CRM: | |
| Verified Versions: | Category: | --- | |
| oVirt Team: | --- | RHEL 7.3 requirements from Atomic Host: | |
| Cloudforms Team: | --- | Target Upstream Version: | |
| Bug Depends On: | |||
| Bug Blocks: | 747354 | ||
cswiii will get us the search gem version since this may be fixed in the latest *** Bug 753095 has been marked as a duplicate of this bug. *** fixed in scoped_search version 2.3.6. moving back to assigned... this particular issue is actually an error in the application code vs the scope_search gem git commit: da81ac130c6cdc4fe32abbd870415e5bf71161a0 Verified in katello-headpin-all-0.1.104-1.git.0.2ec5e64.el6.noarch *** Bug 753170 has been marked as a duplicate of this bug. *** Verified. getting rid of 6.0.0 version since that doesn't exist |
Description of problem: Trying to run a filter on orgs throws nasty error. Version-Release number of selected component (if applicable): How reproducible: Steps to Reproduce: 1. Navigate to Administration Organizations 2. Enter "AC" in the filter box and submit 3. 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 '%AC%' OR "organizations"."description" ILIKE '%AC%' OR "environments"."name" ILIKE '%AC%' OR "environments"."description" ILIKE '%AC%' OR "providers"."name" ILIKE '%AC%' OR "providers"."description" ILIKE '%AC%' OR "providers"."repository_url" ILIKE '%AC%'))) AS id_list ORDER BY id_list.alias_0 LIMIT 25 OFFSET 0 Expected results: Some sort of proper result. Additional info: