Project

General

Profile

Actions

Bug #36394

closed

Passing invalid value to infrasturcture_facet search key leads to PG::InvalidTextRepresentation error

Added by Adam Ruzicka 11 months ago. Updated 11 months ago.

Status:
Closed
Priority:
Normal
Assignee:
Category:
Search
Target version:
-
Difficulty:
Triaged:
Yes
Fixed in Releases:
Found in Releases:

Description

Description of problem:

Host search can error out on infrasturcture_facet related queries

Version-Release number of selected component (if applicable):

Satellite 6.11 snap 14

How reproducible:
always

Steps to Reproduce:
1. in satellite UI, go to the hosts page
2. in the search field put "infrastructure_facet.foreman=test" or "infrastructure_facet.smart_proxy_id=test"

Actual results:
Error screen with:

Oops, we're sorry but something went wrong PG::InvalidTextRepresentation: ERROR: invalid input syntax for type boolean: "test" LINE 1: ...acets_infrastructure_facets"."foreman_instance" = 'test')) O... ^

(same happens when searching through hammer CLI)

Expected results:
no error, host page with no results (as it is when passing wrong values to other search keys"

Additional info:

Actions #1

Updated by Adam Ruzicka 11 months ago

  • Bugzilla link set to 2069666
Actions #2

Updated by The Foreman Bot 11 months ago

  • Status changed from New to Ready For Testing
  • Pull request https://github.com/theforeman/foreman/pull/9706 added
Actions #3

Updated by The Foreman Bot 11 months ago

  • Fixed in Releases 3.7.0 added
Actions #4

Updated by Adam Ruzicka 11 months ago

  • Status changed from Ready For Testing to Closed
Actions #5

Updated by Ewoud Kohl van Wijngaarden 11 months ago

  • Triaged changed from No to Yes
Actions

Also available in: Atom PDF