Uploaded image for project: 'Red Hat Advanced Cluster Management'
  1. Red Hat Advanced Cluster Management
  2. ACM-30764

Search API queries boolean values as strings

XMLWordPrintable

    • Icon: Bug Bug
    • Resolution: Unresolved
    • Icon: Normal Normal
    • None
    • ACM 2.14.0
    • Search
    • None
    • Quality / Stability / Reliability
    • False
    • Hide

      None

      Show
      None
    • False
    • Mgmt Applications 2.17-1
    • Low
    • None

      Description of problem:

      As described in Slack thread, when querying via search kind: StorageClass allowVolumeExpansion:true, the SQL resolves to:

      WHERE data->'allowVolumeExpansion'?('true')

      The attribute is stored as a boolean and returns no results as that's not a boolean operation. The query to fetch the result should be:

      WHERE data?'allowVolumeExpanion' or WHERE data->'allowVolumeExpansion'='true'.

      We can add search-collector handling to convert booleans to strings, or modify the API to permit querying booleans, but that would go against our convention of storing most things as default text.

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

      How reproducible:

      Steps to Reproduce:

      1. ...

      Actual results:

      Expected results:

      Additional info:

              rh-ee-smcavey Spencer McAvey
              rh-ee-smcavey Spencer McAvey
              Votes:
              0 Vote for this issue
              Watchers:
              3 Start watching this issue

                Created:
                Updated: