Bug 750120 - Attempting to Filter on Organizations throws postgresql error
Summary: Attempting to Filter on Organizations throws postgresql error
Keywords:
Status: CLOSED CURRENTRELEASE
Alias: None
Product: Red Hat Satellite
Classification: Red Hat
Component: WebUI
Version: 6.0.1
Hardware: Unspecified
OS: Unspecified
unspecified
unspecified vote
Target Milestone: Unspecified
Assignee: Brad Buckingham
QA Contact: Katello QA List
URL:
Whiteboard:
: 753095 753170 (view as bug list)
Depends On:
Blocks: katello-blockers
TreeView+ depends on / blocked
 
Reported: 2011-10-31 03:49 UTC by Corey Welton
Modified: 2019-09-26 13:23 UTC (History)
5 users (show)

Fixed In Version:
Doc Type: Bug Fix
Doc Text:
Clone Of:
Environment:
postgresql
Last Closed: 2012-08-22 18:03:39 UTC
Target Upstream Version:


Attachments (Terms of Use)

Description Corey Welton 2011-10-31 03:49:53 UTC
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:

Comment 1 Mike McCune 2011-11-02 15:18:41 UTC
cswiii will get us the search gem version since this may be fixed in the latest

Comment 2 Brad Buckingham 2011-11-11 14:41:21 UTC
*** Bug 753095 has been marked as a duplicate of this bug. ***

Comment 3 Amos Benari 2011-11-13 10:40:36 UTC
fixed in scoped_search version 2.3.6.

Comment 4 Brad Buckingham 2011-11-14 19:56:07 UTC
moving back to assigned... this particular issue is actually an error in the application code vs the scope_search gem

Comment 5 Brad Buckingham 2011-11-14 21:01:41 UTC
git commit: da81ac130c6cdc4fe32abbd870415e5bf71161a0

Comment 6 Eric Sammons 2011-11-15 13:48:15 UTC
Verified in katello-headpin-all-0.1.104-1.git.0.2ec5e64.el6.noarch

Comment 7 Mike McCune 2011-11-30 16:12:58 UTC
*** Bug 753170 has been marked as a duplicate of this bug. ***

Comment 8 Corey Welton 2011-12-16 14:54:15 UTC
Verified.

Comment 11 Mike McCune 2013-08-16 18:04:16 UTC
getting rid of 6.0.0 version since that doesn't exist


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