Description of problem: not operator on string in the select clause is returning the same string instead of boolean value executing query-65: select ( not 'Ix8vrSP6MNFNMnjLG0XB' ) from s3object; Stats {'Details': {'BytesProcessed': 145, 'BytesReturned': 63, 'BytesScanned': 145}} End {} Ix8vrSP6MNFNMnjLG0XB Ix8vrSP6MNFNMnjLG0XB Ix8vrSP6MNFNMnjLG0XB Version-Release number of selected component (if applicable): ceph version 18.2.0-128.el9cp How reproducible: always Steps to Reproduce: 1.deploy rhcs7.0 cluster with rgw daemon 2.upload an s3select object 3.execute the above query and verify the results are correct Actual results: not operator on string in the select clause is returning the same string instead of boolean value Expected results: expected boolean value as result Additional info: query result validation script: https://docs.google.com/document/d/1UT8zTizHHVTWYmfXZdgChYJh7rT4bovOJmsecS86qYU/edit?usp=sharing
fix at https://github.com/ceph/ceph/pull/56279
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 (Critical: Red Hat Ceph Storage 7.1 security, enhancements, and bug fix update), 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-2024:3925
The needinfo request[s] on this closed bug have been removed as they have been unresolved for 120 days