Description of problem: wrong output seen for below queries if the operator is in caps it is returning wrong output [cephuser@extensa022 ~]$ time venv/bin/aws s3api --endpoint-url http://extensa027.ceph.redhat.com:80 select-object-content --bucket query-validation-bkt1 --key csv_file1 --expression-type 'SQL' --input-serialization '{"CSV": {}, "CompressionType": "NONE"}' --output-serialization '{"CSV": {}}' --expression "select (true AND false) from s3object;" /dev/stdout true true true real 0m0.428s user 0m0.359s sys 0m0.066s [cephuser@extensa022 ~]$ [cephuser@extensa022 ~]$ time venv/bin/aws s3api --endpoint-url http://extensa027.ceph.redhat.com:80 select-object-content --bucket query-validation-bkt1 --key csv_file1 --expression-type 'SQL' --input-serialization '{"CSV": {}, "CompressionType": "NONE"}' --output-serialization '{"CSV": {}}' --expression "select (true and false) from s3object;" /dev/stdout false false false real 0m0.438s user 0m0.372s sys 0m0.062s [cephuser@extensa022 ~]$ [cephuser@extensa022 ~]$ time venv/bin/aws s3api --endpoint-url http://extensa027.ceph.redhat.com:80 select-object-content --bucket query-validation-bkt1 --key csv_file1 --expression-type 'SQL' --input-serialization '{"CSV": {}, "CompressionType": "NONE"}' --output-serialization '{"CSV": {}}' --expression "select ( true and null ) from s3object;" /dev/stdout null null null real 0m0.444s user 0m0.386s sys 0m0.054s [cephuser@extensa022 ~]$ [cephuser@extensa022 ~]$ [cephuser@extensa022 ~]$ time venv/bin/aws s3api --endpoint-url http://extensa027.ceph.redhat.com:80 select-object-content --bucket query-validation-bkt1 --key csv_file1 --expression-type 'SQL' --input-serialization '{"CSV": {}, "CompressionType": "NONE"}' --output-serialization '{"CSV": {}}' --expression "select ( true AND null ) from s3object;" /dev/stdout true true true real 0m0.430s user 0m0.371s sys 0m0.055s [cephuser@extensa022 ~]$ [cephuser@extensa022 ~]$ time venv/bin/aws s3api --endpoint-url http://extensa027.ceph.redhat.com:80 select-object-content --bucket query-validation-bkt1 --key csv_file1 --expression-type 'SQL' --input-serialization '{"CSV": {}, "CompressionType": "NONE"}' --output-serialization '{"CSV": {}}' --expression "select ( null AND false ) from s3object;" /dev/stdout null null null real 0m0.434s user 0m0.379s sys 0m0.050s [cephuser@extensa022 ~]$ [cephuser@extensa022 ~]$ [cephuser@extensa022 ~]$ time venv/bin/aws s3api --endpoint-url http://extensa027.ceph.redhat.com:80 select-object-content --bucket query-validation-bkt1 --key csv_file1 --expression-type 'SQL' --input-serialization '{"CSV": {}, "CompressionType": "NONE"}' --output-serialization '{"CSV": {}}' --expression "select ( null and false ) from s3object;" /dev/stdout false false false real 0m0.435s user 0m0.369s sys 0m0.062s [cephuser@extensa022 ~]$ 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 queries, it should correct output if the operator in caps also Actual results: seeing wrong output when operator in caps and correct output when operator in small letters Expected results: should return correct output for queries having operator in caps as well Additional info: automation script: https://docs.google.com/document/d/1_eALVAP5erwl1v-bhHuyu0XX6T7776Xg9fIC2Uj8Jg8/edit?usp=sharing queries generated and executed: https://drive.google.com/drive/folders/1Xin784T6mumv6MXF0MfGce074Lw1STPl
fixed on https://github.com/ceph/ceph/pull/55183
Gal, just getting confirmation that we're awaiting downstream cherry-picks to ceph-7.1-rhel-patches for this BZ? Including a submodule update like you did in the ceph-7.0-rhel-patches branch (for the 7.0 z2 release)? https://gitlab.cee.redhat.com/ceph/ceph/-/commit/ec3742261bb1223dfe96f8658ea66814ae2f2113#fb32792b6e3b62f26d90c2a52c3d1392f67f82ea_2_1 Thanks, Thomas
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