Bug 1615465

Summary: Using database wildcard `%25` in VM queries causes exception, returns 500 to client
Product: Red Hat CloudForms Management Engine Reporter: Satoe Imaishi <simaishi>
Component: APIAssignee: Yuri Rudman <yrudman>
Status: CLOSED ERRATA QA Contact: Niyaz Akhtar Ansari <nansari>
Severity: medium Docs Contact:
Priority: high    
Version: 5.9.0CC: cpelland, dluong, obarenbo, smallamp, yrudman
Target Milestone: GAKeywords: ZStream
Target Release: 5.9.5   
Hardware: Unspecified   
OS: Unspecified   
Whiteboard:
Fixed In Version: 5.9.5.0 Doc Type: If docs needed, set a value
Doc Text:
Story Points: ---
Clone Of: 1581853 Environment:
Last Closed: 2018-11-05 13:58:28 UTC Type: ---
Regression: --- Mount Type: ---
Documentation: --- CRM:
Verified Versions: Category: ---
oVirt Team: --- RHEL 7.3 requirements from Atomic Host:
Cloudforms Team: CFME Core Target Upstream Version:
Embargoed:
Bug Depends On: 1581853    
Bug Blocks:    

Comment 1 CFME Bot 2018-09-11 20:21:29 UTC 
New commit detected on ManageIQ/manageiq/gaprindashvili:

https://github.com/ManageIQ/manageiq/commit/85b2eb61b57efe68664026b6607f80d62a3c1c9e
commit 85b2eb61b57efe68664026b6607f80d62a3c1c9e
Author:     Gregg Tanzillo <gtanzill>
AuthorDate: Thu Aug  9 09:37:02 2018 -0400
Commit:     Gregg Tanzillo <gtanzill>
CommitDate: Thu Aug  9 09:37:02 2018 -0400

    Merge pull request #17801 from kbrock/check-if-valid-field

    New and improved Field.is_field?()
    (cherry picked from commit ec091b9a98735b8a5b91aef77d04ef34955a219b)

    https://bugzilla.redhat.com/show_bug.cgi?id=1615465

 lib/miq_expression/field.rb | 15 +-
 lib/miq_expression/target.rb | 7 +-
 spec/lib/miq_expression/field_spec.rb | 6 +-
 3 files changed, 14 insertions(+), 14 deletions(-)
Comment 2 Niyaz Akhtar Ansari 2018-10-03 14:44:41 UTC 
It works fine with no error.
Verified in Version 5.9.5.0.20180927190514_e161d8f
Comment 4 errata-xmlrpc 2018-11-05 13:58:28 UTC 
Since the problem described in this bug report should be
resolved in a recent advisory, it has been closed with a
resolution of ERRATA.

For information on the advisory, and where to find the updated
files, follow the link below.

If the solution does not work for you, open a new bug report.

https://access.redhat.com/errata/RHSA-2018:3466