Ceph » rgw

Example run: https://qa-proxy.ceph.com/teuthology/hyelloji-2025-03-12_09:28:17-rgw-wip-hemanth-testing-2025-03-03-1505-squid-distro-default-smithi/8183687/teuthology.log
Reproduced frequently: https://pulpito.ceph.com/hyelloji-2025-03-12_09:28:17-rgw-wip-hemanth-testing-2025-03-03-1505-squid-distro-default-smithi/

=================================== FAILURES ===================================
____________________ test_schema_definition ____________________

    @pytest.mark.s3select
    def test_schema_definition():

        number_of_rows = 10000

        # purpose of test is to validate functionality using csv header info
        csv_obj = create_random_csv_object(number_of_rows,10,csv_schema="c1,c2,c3,c4,c5,c6,c7,c8,c9,c10")

        csv_obj_name = get_random_string()
        bucket_name = get_new_bucket_name()

        upload_object(bucket_name,csv_obj_name,csv_obj)

        # ignoring the schema on first line and retrieve using generic column number
        res_ignore = remove_xml_tags_from_result( run_s3select(bucket_name,csv_obj_name,"select _1,_3 from s3object;",csv_header_info="IGNORE") ).replace("\n","")

        # using the scheme on first line, query is using the attach schema
        res_use = remove_xml_tags_from_result( run_s3select(bucket_name,csv_obj_name,"select c1,c3 from s3object;",csv_header_info="USE") ).replace("\n","")
        # result of both queries should be the same
        s3select_assert_result( res_ignore, res_use)

        # using column-name not exist in schema
        res_multiple_defintion = remove_xml_tags_from_result( run_s3select(bucket_name,csv_obj_name,"select c1,c10,int(c11) from s3object;",csv_header_info="USE") ).replace("\n","")

        assert ((res_multiple_defintion.find("alias {c11} or column not exist in schema")) >= 0)

        #find_processing_error = res_multiple_defintion.find("ProcessingTimeError")
>       assert ((res_multiple_defintion.find("ProcessingTimeError")) >= 0)
E       AssertionError: assert -1 >= 0
E        +  where -1 = <built-in method find of str object at 0x7fad80b2f840>('ProcessingTimeError')
E        +    where <built-in method find of str object at 0x7fad80b2f840> = 'An error occurred (s3select-ProcessingTime-Error) when calling the SelectObjectContent operation: [int failed : alias {c11} or column not exist in schema]'.find