Check firebird.log [no messages found for interval when this test was running]
Jump to: output_first_mismatch    outcomes_full_history    elapsed_time_chart
Show cross-report outcomes.

Annotation type Annotation details
2 @message
assert   
    select * from test where 5000 in (x, y)
    Select Expression
    ....-> Filter
  - ........-> Table "TEST" Access By ID
  + ........-> Table "PUBLIC"."TEST" Access By ID
    ............-> Bitmap Or
    ................-> Bitmap
  - ....................-> Index "TEST_X_ASC" Range Scan (full match)
  + ....................-> Index "PUBLIC"."TEST_X_ASC" Range Scan (full match)
    ................-> Bitmap
  - ....................-> Index "TEST_Y_ASC" Range Scan (full match)
  + ....................-> Index "PUBLIC"."TEST_Y_ASC" Range Scan (full match)
    select * from test where 5000 in (u, v)
    Select Expression
    ....-> Filter
  - ........-> Table "TEST" Access By ID
  + ........-> Table "PUBLIC"."TEST" Access By ID
    ............-> Bitmap Or
    ................-> Bitmap
  - ....................-> Index "TEST_U_DEC" Range Scan (full match)
  + ....................-> Index "PUBLIC"."TEST_U_DEC" Range Scan (full match)
    ................-> Bitmap
  - ....................-> Index "TEST_V_DEC" Range Scan (full match)
  + ....................-> Index "PUBLIC"."TEST_V_DEC" Range Scan (full match)
    select * from test where 5000 in (x, u)
    Select Expression
    ....-> Filter
  - ........-> Table "TEST" Access By ID
  + ........-> Table "PUBLIC"."TEST" Access By ID
    ............-> Bitmap Or
    ................-> Bitmap
  - ....................-> Index "TEST_X_ASC" Range Scan (full match)
  + ....................-> Index "PUBLIC"."TEST_X_ASC" Range Scan (full match)
    ................-> Bitmap
  - ....................-> Index "TEST_U_DEC" Range Scan (full match)
  + ....................-> Index "PUBLIC"."TEST_U_DEC" Range Scan (full match)
    select * from test where 5000 in (v, y)
    Select Expression
    ....-> Filter
  - ........-> Table "TEST" Access By ID
  + ........-> Table "PUBLIC"."TEST" Access By ID
    ............-> Bitmap Or
    ................-> Bitmap
  - ....................-> Index "TEST_V_DEC" Range Scan (full match)
  + ....................-> Index "PUBLIC"."TEST_V_DEC" Range Scan (full match)
    ................-> Bitmap
  - ....................-> Index "TEST_Y_ASC" Range Scan (full match)
  + ....................-> Index "PUBLIC"."TEST_Y_ASC" Range Scan (full match)
    select * from test where 5000 in (x+y, u-v)
    Select Expression
    ....-> Filter
  - ........-> Table "TEST" Access By ID
  + ........-> Table "PUBLIC"."TEST" Access By ID
    ............-> Bitmap Or
    ................-> Bitmap
  - ....................-> Index "TEST_C_ASC" Range Scan (full match)
  + ....................-> Index "PUBLIC"."TEST_C_ASC" Range Scan (full match)
    ................-> Bitmap
  - ....................-> Index "TEST_C_DEC" Range Scan (full match)
  + ....................-> Index "PUBLIC"."TEST_C_DEC" Range Scan (full match)
    select * from test where 5000 in (p, q) and p < 5001 and q > 4999
    Select Expression
    ....-> Filter
  - ........-> Table "TEST" Access By ID
  + ........-> Table "PUBLIC"."TEST" Access By ID
    ............-> Bitmap Or
    ................-> Bitmap
  - ....................-> Index "TEST_P_ASC" Range Scan (full match)
  + ....................-> Index "PUBLIC"."TEST_P_ASC" Range Scan (full match)
    ................-> Bitmap
  - ....................-> Index "TEST_Q_ASC" Range Scan (full match)
  + ....................-> Index "PUBLIC"."TEST_Q_ASC" Range Scan (full match)
    select * from test where 5000 in (p, q) and p > 4999 and q < 5001
    Select Expression
    ....-> Filter
  - ........-> Table "TEST" Access By ID
  + ........-> Table "PUBLIC"."TEST" Access By ID
    ............-> Bitmap Or
    ................-> Bitmap
  - ....................-> Index "TEST_P_DEC" Range Scan (full match)
  + ....................-> Index "PUBLIC"."TEST_P_DEC" Range Scan (full match)
    ................-> Bitmap
  - ....................-> Index "TEST_Q_DEC" Range Scan (full match)
  + ....................-> Index "PUBLIC"."TEST_Q_DEC" Range Scan (full match)

LOG DETAILS:

2025-07-03 06:40:53.435
2025-07-03 06:40:53.435 act = <firebird.qa.plugin.Action object at [hex]>
2025-07-03 06:40:53.435 capsys = <_pytest.capture.CaptureFixture object at [hex]>
2025-07-03 06:40:53.435
2025-07-03 06:40:53.435     @pytest.mark.version('>=5.0.2')
2025-07-03 06:40:53.435     def test_1(act: Action, capsys):
2025-07-03 06:40:53.435         queries_map = { i : x for i,x in enumerate
2025-07-03 06:40:53.435                           (
2025-07-03 06:40:53.435                               [
2025-07-03 06:40:53.435                                    'select * from test where 5000 in (x, y)'
2025-07-03 06:40:53.435                                   ,'select * from test where 5000 in (u, v)'
2025-07-03 06:40:53.435                                   ,'select * from test where 5000 in (x, u)'
2025-07-03 06:40:53.435                                   ,'select * from test where 5000 in (v, y)'
2025-07-03 06:40:53.435                                   ,'select * from test where 5000 in (x+y, u-v)'
2025-07-03 06:40:53.435                                   ,'select * from test where 5000 in (p, q) and p < 5001 and q > 4999'
2025-07-03 06:40:53.435                                   ,'select * from test where 5000 in (p, q) and p > 4999 and q < 5001'
2025-07-03 06:40:53.435                               ]
2025-07-03 06:40:53.435                           )
2025-07-03 06:40:53.436                       }
2025-07-03 06:40:53.436         with act.db.connect() as con:
2025-07-03 06:40:53.436             cur = con.cursor()
2025-07-03 06:40:53.436             for qry_idx, qry_txt in queries_map.items():
2025-07-03 06:40:53.436                 ps = None
2025-07-03 06:40:53.436                 try:
2025-07-03 06:40:53.436                     ps = cur.prepare(qry_txt)
2025-07-03 06:40:53.436
2025-07-03 06:40:53.436                     # Print explained plan with padding eash line by dots in order to see indentations:
2025-07-03 06:40:53.436                     print(qry_txt)
2025-07-03 06:40:53.436                     print( '\n'.join([replace_leading(s) for s in ps.detailed_plan.split('\n')]) )
2025-07-03 06:40:53.436                     print('\n')
2025-07-03 06:40:53.436                 except DatabaseError as e:
2025-07-03 06:40:53.436                     print(e.__str__())
2025-07-03 06:40:53.436                     print(e.gds_codes)
2025-07-03 06:40:53.436                 finally:
2025-07-03 06:40:53.436                     if ps:
2025-07-03 06:40:53.436                         ps.free()
2025-07-03 06:40:53.436
2025-07-03 06:40:53.436
2025-07-03 06:40:53.436         expected_stdout = f"""
2025-07-03 06:40:53.437             {queries_map[ 0 ]}
2025-07-03 06:40:53.437             Select Expression
2025-07-03 06:40:53.437             ....-> Filter
2025-07-03 06:40:53.437             ........-> Table "TEST" Access By ID
2025-07-03 06:40:53.437             ............-> Bitmap Or
2025-07-03 06:40:53.437             ................-> Bitmap
2025-07-03 06:40:53.437             ....................-> Index "TEST_X_ASC" Range Scan (full match)
2025-07-03 06:40:53.437             ................-> Bitmap
2025-07-03 06:40:53.437             ....................-> Index "TEST_Y_ASC" Range Scan (full match)
2025-07-03 06:40:53.437
2025-07-03 06:40:53.437             {queries_map[ 1 ]}
2025-07-03 06:40:53.437             Select Expression
2025-07-03 06:40:53.437             ....-> Filter
2025-07-03 06:40:53.437             ........-> Table "TEST" Access By ID
2025-07-03 06:40:53.437             ............-> Bitmap Or
2025-07-03 06:40:53.437             ................-> Bitmap
2025-07-03 06:40:53.437             ....................-> Index "TEST_U_DEC" Range Scan (full match)
2025-07-03 06:40:53.437             ................-> Bitmap
2025-07-03 06:40:53.437             ....................-> Index "TEST_V_DEC" Range Scan (full match)
2025-07-03 06:40:53.437
2025-07-03 06:40:53.438             {queries_map[ 2 ]}
2025-07-03 06:40:53.438             Select Expression
2025-07-03 06:40:53.438             ....-> Filter
2025-07-03 06:40:53.438             ........-> Table "TEST" Access By ID
2025-07-03 06:40:53.438             ............-> Bitmap Or
2025-07-03 06:40:53.438             ................-> Bitmap
2025-07-03 06:40:53.438             ....................-> Index "TEST_X_ASC" Range Scan (full match)
2025-07-03 06:40:53.438             ................-> Bitmap
2025-07-03 06:40:53.438             ....................-> Index "TEST_U_DEC" Range Scan (full match)
2025-07-03 06:40:53.438
2025-07-03 06:40:53.438             {queries_map[ 3 ]}
2025-07-03 06:40:53.438             Select Expression
2025-07-03 06:40:53.438             ....-> Filter
2025-07-03 06:40:53.438             ........-> Table "TEST" Access By ID
2025-07-03 06:40:53.438             ............-> Bitmap Or
2025-07-03 06:40:53.438             ................-> Bitmap
2025-07-03 06:40:53.438             ....................-> Index "TEST_V_DEC" Range Scan (full match)
2025-07-03 06:40:53.438             ................-> Bitmap
2025-07-03 06:40:53.438             ....................-> Index "TEST_Y_ASC" Range Scan (full match)
2025-07-03 06:40:53.439
2025-07-03 06:40:53.439             {queries_map[ 4 ]}
2025-07-03 06:40:53.439             Select Expression
2025-07-03 06:40:53.439             ....-> Filter
2025-07-03 06:40:53.439             ........-> Table "TEST" Access By ID
2025-07-03 06:40:53.439             ............-> Bitmap Or
2025-07-03 06:40:53.439             ................-> Bitmap
2025-07-03 06:40:53.439             ....................-> Index "TEST_C_ASC" Range Scan (full match)
2025-07-03 06:40:53.439             ................-> Bitmap
2025-07-03 06:40:53.439             ....................-> Index "TEST_C_DEC" Range Scan (full match)
2025-07-03 06:40:53.439
2025-07-03 06:40:53.439             {queries_map[ 5 ]}
2025-07-03 06:40:53.439             Select Expression
2025-07-03 06:40:53.439             ....-> Filter
2025-07-03 06:40:53.439             ........-> Table "TEST" Access By ID
2025-07-03 06:40:53.439             ............-> Bitmap Or
2025-07-03 06:40:53.439             ................-> Bitmap
2025-07-03 06:40:53.439             ....................-> Index "TEST_P_ASC" Range Scan (full match)
2025-07-03 06:40:53.439             ................-> Bitmap
2025-07-03 06:40:53.439             ....................-> Index "TEST_Q_ASC" Range Scan (full match)
2025-07-03 06:40:53.440
2025-07-03 06:40:53.440             {queries_map[ 6 ]}
2025-07-03 06:40:53.440             Select Expression
2025-07-03 06:40:53.440             ....-> Filter
2025-07-03 06:40:53.440             ........-> Table "TEST" Access By ID
2025-07-03 06:40:53.440             ............-> Bitmap Or
2025-07-03 06:40:53.440             ................-> Bitmap
2025-07-03 06:40:53.440             ....................-> Index "TEST_P_DEC" Range Scan (full match)
2025-07-03 06:40:53.440             ................-> Bitmap
2025-07-03 06:40:53.440             ....................-> Index "TEST_Q_DEC" Range Scan (full match)
2025-07-03 06:40:53.440         """
2025-07-03 06:40:53.440
2025-07-03 06:40:53.440         act.expected_stdout = expected_stdout
2025-07-03 06:40:53.440         act.stdout = capsys.readouterr().out
2025-07-03 06:40:53.440 >       assert act.clean_stdout == act.clean_expected_stdout
2025-07-03 06:40:53.440 E       assert
2025-07-03 06:40:53.440 E           select * from test where 5000 in (x, y)
2025-07-03 06:40:53.440 E           Select Expression
2025-07-03 06:40:53.440 E           ....-> Filter
2025-07-03 06:40:53.440 E         - ........-> Table "TEST" Access By ID
2025-07-03 06:40:53.441 E         + ........-> Table "PUBLIC"."TEST" Access By ID
2025-07-03 06:40:53.441 E           ............-> Bitmap Or
2025-07-03 06:40:53.441 E           ................-> Bitmap
2025-07-03 06:40:53.441 E         - ....................-> Index "TEST_X_ASC" Range Scan (full match)
2025-07-03 06:40:53.441 E         + ....................-> Index "PUBLIC"."TEST_X_ASC" Range Scan (full match)
2025-07-03 06:40:53.441 E           ................-> Bitmap
2025-07-03 06:40:53.441 E         - ....................-> Index "TEST_Y_ASC" Range Scan (full match)
2025-07-03 06:40:53.441 E         + ....................-> Index "PUBLIC"."TEST_Y_ASC" Range Scan (full match)
2025-07-03 06:40:53.441 E           select * from test where 5000 in (u, v)
2025-07-03 06:40:53.441 E           Select Expression
2025-07-03 06:40:53.441 E           ....-> Filter
2025-07-03 06:40:53.441 E         - ........-> Table "TEST" Access By ID
2025-07-03 06:40:53.441 E         + ........-> Table "PUBLIC"."TEST" Access By ID
2025-07-03 06:40:53.441 E           ............-> Bitmap Or
2025-07-03 06:40:53.441 E           ................-> Bitmap
2025-07-03 06:40:53.441 E         - ....................-> Index "TEST_U_DEC" Range Scan (full match)
2025-07-03 06:40:53.442 E         + ....................-> Index "PUBLIC"."TEST_U_DEC" Range Scan (full match)
2025-07-03 06:40:53.442 E           ................-> Bitmap
2025-07-03 06:40:53.442 E         - ....................-> Index "TEST_V_DEC" Range Scan (full match)
2025-07-03 06:40:53.442 E         + ....................-> Index "PUBLIC"."TEST_V_DEC" Range Scan (full match)
2025-07-03 06:40:53.442 E           select * from test where 5000 in (x, u)
2025-07-03 06:40:53.442 E           Select Expression
2025-07-03 06:40:53.442 E           ....-> Filter
2025-07-03 06:40:53.442 E         - ........-> Table "TEST" Access By ID
2025-07-03 06:40:53.442 E         + ........-> Table "PUBLIC"."TEST" Access By ID
2025-07-03 06:40:53.442 E           ............-> Bitmap Or
2025-07-03 06:40:53.442 E           ................-> Bitmap
2025-07-03 06:40:53.442 E         - ....................-> Index "TEST_X_ASC" Range Scan (full match)
2025-07-03 06:40:53.442 E         + ....................-> Index "PUBLIC"."TEST_X_ASC" Range Scan (full match)
2025-07-03 06:40:53.442 E           ................-> Bitmap
2025-07-03 06:40:53.442 E         - ....................-> Index "TEST_U_DEC" Range Scan (full match)
2025-07-03 06:40:53.442 E         + ....................-> Index "PUBLIC"."TEST_U_DEC" Range Scan (full match)
2025-07-03 06:40:53.443 E           select * from test where 5000 in (v, y)
2025-07-03 06:40:53.443 E           Select Expression
2025-07-03 06:40:53.443 E           ....-> Filter
2025-07-03 06:40:53.443 E         - ........-> Table "TEST" Access By ID
2025-07-03 06:40:53.443 E         + ........-> Table "PUBLIC"."TEST" Access By ID
2025-07-03 06:40:53.443 E           ............-> Bitmap Or
2025-07-03 06:40:53.443 E           ................-> Bitmap
2025-07-03 06:40:53.443 E         - ....................-> Index "TEST_V_DEC" Range Scan (full match)
2025-07-03 06:40:53.443 E         + ....................-> Index "PUBLIC"."TEST_V_DEC" Range Scan (full match)
2025-07-03 06:40:53.443 E           ................-> Bitmap
2025-07-03 06:40:53.443 E         - ....................-> Index "TEST_Y_ASC" Range Scan (full match)
2025-07-03 06:40:53.443 E         + ....................-> Index "PUBLIC"."TEST_Y_ASC" Range Scan (full match)
2025-07-03 06:40:53.443 E           select * from test where 5000 in (x+y, u-v)
2025-07-03 06:40:53.443 E           Select Expression
2025-07-03 06:40:53.443 E           ....-> Filter
2025-07-03 06:40:53.443 E         - ........-> Table "TEST" Access By ID
2025-07-03 06:40:53.443 E         + ........-> Table "PUBLIC"."TEST" Access By ID
2025-07-03 06:40:53.444 E           ............-> Bitmap Or
2025-07-03 06:40:53.444 E           ................-> Bitmap
2025-07-03 06:40:53.444 E         - ....................-> Index "TEST_C_ASC" Range Scan (full match)
2025-07-03 06:40:53.444 E         + ....................-> Index "PUBLIC"."TEST_C_ASC" Range Scan (full match)
2025-07-03 06:40:53.444 E           ................-> Bitmap
2025-07-03 06:40:53.444 E         - ....................-> Index "TEST_C_DEC" Range Scan (full match)
2025-07-03 06:40:53.444 E         + ....................-> Index "PUBLIC"."TEST_C_DEC" Range Scan (full match)
2025-07-03 06:40:53.444 E           select * from test where 5000 in (p, q) and p < 5001 and q > 4999
2025-07-03 06:40:53.444 E           Select Expression
2025-07-03 06:40:53.444 E           ....-> Filter
2025-07-03 06:40:53.444 E         - ........-> Table "TEST" Access By ID
2025-07-03 06:40:53.444 E         + ........-> Table "PUBLIC"."TEST" Access By ID
2025-07-03 06:40:53.444 E           ............-> Bitmap Or
2025-07-03 06:40:53.444 E           ................-> Bitmap
2025-07-03 06:40:53.444 E         - ....................-> Index "TEST_P_ASC" Range Scan (full match)
2025-07-03 06:40:53.445 E         + ....................-> Index "PUBLIC"."TEST_P_ASC" Range Scan (full match)
2025-07-03 06:40:53.445 E           ................-> Bitmap
2025-07-03 06:40:53.445 E         - ....................-> Index "TEST_Q_ASC" Range Scan (full match)
2025-07-03 06:40:53.445 E         + ....................-> Index "PUBLIC"."TEST_Q_ASC" Range Scan (full match)
2025-07-03 06:40:53.445 E           select * from test where 5000 in (p, q) and p > 4999 and q < 5001
2025-07-03 06:40:53.445 E           Select Expression
2025-07-03 06:40:53.445 E           ....-> Filter
2025-07-03 06:40:53.445 E         - ........-> Table "TEST" Access By ID
2025-07-03 06:40:53.445 E         + ........-> Table "PUBLIC"."TEST" Access By ID
2025-07-03 06:40:53.445 E           ............-> Bitmap Or
2025-07-03 06:40:53.445 E           ................-> Bitmap
2025-07-03 06:40:53.445 E         - ....................-> Index "TEST_P_DEC" Range Scan (full match)
2025-07-03 06:40:53.445 E         + ....................-> Index "PUBLIC"."TEST_P_DEC" Range Scan (full match)
2025-07-03 06:40:53.445 E           ................-> Bitmap
2025-07-03 06:40:53.445 E         - ....................-> Index "TEST_Q_DEC" Range Scan (full match)
2025-07-03 06:40:53.445 E         + ....................-> Index "PUBLIC"."TEST_Q_DEC" Range Scan (full match)
2025-07-03 06:40:53.446
2025-07-03 06:40:53.446 tests\bugs\gh_8109_test.py:155: AssertionError
2025-07-03 06:40:53.446 ---------------------------- Captured stdout setup ----------------------------
2025-07-03 06:40:53.446 Creating db: localhost:H:\QA\temp\qa2024.tmp\fbqa\test_11712\test.fdb [page_size=None, sql_dialect=None, charset='NONE', user=SYSDBA, password=masterkey]
3 #text
act = <firebird.qa.plugin.Action pytest object at [hex]>
capsys = <_pytest.capture.CaptureFixture pytest object at [hex]>

    @pytest.mark.version('>=5.0.2')
    def test_1(act: Action, capsys):
        queries_map = { i : x for i,x in enumerate
                          (
                              [
                                   'select * from test where 5000 in (x, y)'
                                  ,'select * from test where 5000 in (u, v)'
                                  ,'select * from test where 5000 in (x, u)'
                                  ,'select * from test where 5000 in (v, y)'
                                  ,'select * from test where 5000 in (x+y, u-v)'
                                  ,'select * from test where 5000 in (p, q) and p < 5001 and q > 4999'
                                  ,'select * from test where 5000 in (p, q) and p > 4999 and q < 5001'
                              ]
                          )
                      }
        with act.db.connect() as con:
            cur = con.cursor()
            for qry_idx, qry_txt in queries_map.items():
                ps = None
                try:
                    ps = cur.prepare(qry_txt)
    
                    # Print explained plan with padding eash line by dots in order to see indentations:
                    print(qry_txt)
                    print( '\n'.join([replace_leading(s) for s in ps.detailed_plan.split('\n')]) )
                    print('\n')
                except DatabaseError as e:
                    print(e.__str__())
                    print(e.gds_codes)
                finally:
                    if ps:
                        ps.free()
    
    
        expected_stdout = f"""
            {queries_map[ 0 ]}
            Select Expression
            ....-> Filter
            ........-> Table "TEST" Access By ID
            ............-> Bitmap Or
            ................-> Bitmap
            ....................-> Index "TEST_X_ASC" Range Scan (full match)
            ................-> Bitmap
            ....................-> Index "TEST_Y_ASC" Range Scan (full match)
    
            {queries_map[ 1 ]}
            Select Expression
            ....-> Filter
            ........-> Table "TEST" Access By ID
            ............-> Bitmap Or
            ................-> Bitmap
            ....................-> Index "TEST_U_DEC" Range Scan (full match)
            ................-> Bitmap
            ....................-> Index "TEST_V_DEC" Range Scan (full match)
    
            {queries_map[ 2 ]}
            Select Expression
            ....-> Filter
            ........-> Table "TEST" Access By ID
            ............-> Bitmap Or
            ................-> Bitmap
            ....................-> Index "TEST_X_ASC" Range Scan (full match)
            ................-> Bitmap
            ....................-> Index "TEST_U_DEC" Range Scan (full match)
    
            {queries_map[ 3 ]}
            Select Expression
            ....-> Filter
            ........-> Table "TEST" Access By ID
            ............-> Bitmap Or
            ................-> Bitmap
            ....................-> Index "TEST_V_DEC" Range Scan (full match)
            ................-> Bitmap
            ....................-> Index "TEST_Y_ASC" Range Scan (full match)
    
            {queries_map[ 4 ]}
            Select Expression
            ....-> Filter
            ........-> Table "TEST" Access By ID
            ............-> Bitmap Or
            ................-> Bitmap
            ....................-> Index "TEST_C_ASC" Range Scan (full match)
            ................-> Bitmap
            ....................-> Index "TEST_C_DEC" Range Scan (full match)
    
            {queries_map[ 5 ]}
            Select Expression
            ....-> Filter
            ........-> Table "TEST" Access By ID
            ............-> Bitmap Or
            ................-> Bitmap
            ....................-> Index "TEST_P_ASC" Range Scan (full match)
            ................-> Bitmap
            ....................-> Index "TEST_Q_ASC" Range Scan (full match)
    
            {queries_map[ 6 ]}
            Select Expression
            ....-> Filter
            ........-> Table "TEST" Access By ID
            ............-> Bitmap Or
            ................-> Bitmap
            ....................-> Index "TEST_P_DEC" Range Scan (full match)
            ................-> Bitmap
            ....................-> Index "TEST_Q_DEC" Range Scan (full match)
        """
    
        act.expected_stdout = expected_stdout
        act.stdout = capsys.readouterr().out
>       assert act.clean_stdout == act.clean_expected_stdout
E       assert   
E           select * from test where 5000 in (x, y)
E           Select Expression
E           ....-> Filter
E         - ........-> Table "TEST" Access By ID
E         + ........-> Table "PUBLIC"."TEST" Access By ID
E           ............-> Bitmap Or
E           ................-> Bitmap
E         - ....................-> Index "TEST_X_ASC" Range Scan (full match)
E         + ....................-> Index "PUBLIC"."TEST_X_ASC" Range Scan (full match)
E           ................-> Bitmap
E         - ....................-> Index "TEST_Y_ASC" Range Scan (full match)
E         + ....................-> Index "PUBLIC"."TEST_Y_ASC" Range Scan (full match)
E           select * from test where 5000 in (u, v)
E           Select Expression
E           ....-> Filter
E         - ........-> Table "TEST" Access By ID
E         + ........-> Table "PUBLIC"."TEST" Access By ID
E           ............-> Bitmap Or
E           ................-> Bitmap
E         - ....................-> Index "TEST_U_DEC" Range Scan (full match)
E         + ....................-> Index "PUBLIC"."TEST_U_DEC" Range Scan (full match)
E           ................-> Bitmap
E         - ....................-> Index "TEST_V_DEC" Range Scan (full match)
E         + ....................-> Index "PUBLIC"."TEST_V_DEC" Range Scan (full match)
E           select * from test where 5000 in (x, u)
E           Select Expression
E           ....-> Filter
E         - ........-> Table "TEST" Access By ID
E         + ........-> Table "PUBLIC"."TEST" Access By ID
E           ............-> Bitmap Or
E           ................-> Bitmap
E         - ....................-> Index "TEST_X_ASC" Range Scan (full match)
E         + ....................-> Index "PUBLIC"."TEST_X_ASC" Range Scan (full match)
E           ................-> Bitmap
E         - ....................-> Index "TEST_U_DEC" Range Scan (full match)
E         + ....................-> Index "PUBLIC"."TEST_U_DEC" Range Scan (full match)
E           select * from test where 5000 in (v, y)
E           Select Expression
E           ....-> Filter
E         - ........-> Table "TEST" Access By ID
E         + ........-> Table "PUBLIC"."TEST" Access By ID
E           ............-> Bitmap Or
E           ................-> Bitmap
E         - ....................-> Index "TEST_V_DEC" Range Scan (full match)
E         + ....................-> Index "PUBLIC"."TEST_V_DEC" Range Scan (full match)
E           ................-> Bitmap
E         - ....................-> Index "TEST_Y_ASC" Range Scan (full match)
E         + ....................-> Index "PUBLIC"."TEST_Y_ASC" Range Scan (full match)
E           select * from test where 5000 in (x+y, u-v)
E           Select Expression
E           ....-> Filter
E         - ........-> Table "TEST" Access By ID
E         + ........-> Table "PUBLIC"."TEST" Access By ID
E           ............-> Bitmap Or
E           ................-> Bitmap
E         - ....................-> Index "TEST_C_ASC" Range Scan (full match)
E         + ....................-> Index "PUBLIC"."TEST_C_ASC" Range Scan (full match)
E           ................-> Bitmap
E         - ....................-> Index "TEST_C_DEC" Range Scan (full match)
E         + ....................-> Index "PUBLIC"."TEST_C_DEC" Range Scan (full match)
E           select * from test where 5000 in (p, q) and p < 5001 and q > 4999
E           Select Expression
E           ....-> Filter
E         - ........-> Table "TEST" Access By ID
E         + ........-> Table "PUBLIC"."TEST" Access By ID
E           ............-> Bitmap Or
E           ................-> Bitmap
E         - ....................-> Index "TEST_P_ASC" Range Scan (full match)
E         + ....................-> Index "PUBLIC"."TEST_P_ASC" Range Scan (full match)
E           ................-> Bitmap
E         - ....................-> Index "TEST_Q_ASC" Range Scan (full match)
E         + ....................-> Index "PUBLIC"."TEST_Q_ASC" Range Scan (full match)
E           select * from test where 5000 in (p, q) and p > 4999 and q < 5001
E           Select Expression
E           ....-> Filter
E         - ........-> Table "TEST" Access By ID
E         + ........-> Table "PUBLIC"."TEST" Access By ID
E           ............-> Bitmap Or
E           ................-> Bitmap
E         - ....................-> Index "TEST_P_DEC" Range Scan (full match)
E         + ....................-> Index "PUBLIC"."TEST_P_DEC" Range Scan (full match)
E           ................-> Bitmap
E         - ....................-> Index "TEST_Q_DEC" Range Scan (full match)
E         + ....................-> Index "PUBLIC"."TEST_Q_DEC" Range Scan (full match)

tests\bugs\gh_8109_test.py:155: AssertionError
Full history of outcomes and elapsed time, ms:
NN SNAP_INFO CS_outcome SS_outcome CS_run_time SS_run_time CS_run_beg CS_run_end SS_run_beg SS_run_end
1 6.0.0.892 2025.07.02 10f7d F F 1318 1053 2025.07.03 03:14:43.835 2025.07.03 03:14:45.153 2025.07.03 01:29:58.589 2025.07.03 01:29:59.642
2 6.0.0.889 2025.07.02 4b4e6 F F 1322 1024 2025.07.02 11:12:15.741 2025.07.02 11:12:17.063 2025.07.02 09:30:33.367 2025.07.02 09:30:34.391
3 6.0.0.889 2025.07.01 969ac F F 1313 1073 2025.07.02 03:17:51.001 2025.07.02 03:17:52.314 2025.07.02 01:32:50.842 2025.07.02 01:32:51.915
4 6.0.0.881 2025.06.27 7035d F F 1388 1038 2025.07.01 03:11:40.314 2025.07.01 03:11:41.702 2025.07.01 01:29:42.461 2025.07.01 01:29:43.499
5 6.0.0.877 2025.06.26 8e38f F F 1315 1046 2025.06.27 03:13:01.583 2025.06.27 03:13:02.898 2025.06.27 01:30:28.154 2025.06.27 01:30:29.200
6 6.0.0.876 2025.06.25 b1bec F F 1322 1028 2025.06.26 03:18:20.481 2025.06.26 03:18:21.803 2025.06.26 01:36:06.349 2025.06.26 01:36:07.377
7 6.0.0.863 2025.06.24 c3c20 F F 1393 1055 2025.06.25 08:02:29.701 2025.06.25 08:02:31.094 2025.06.25 01:30:08.539 2025.06.25 01:30:09.594
8 6.0.0.858 2025.06.24 cbbbf F F 1526 1066 2025.06.24 17:45:02.060 2025.06.24 17:45:03.586 2025.06.24 16:02:06.512 2025.06.24 16:02:07.578
9 6.0.0.858 2025.06.23 d377c F F 1509 1046 2025.06.24 08:57:03.284 2025.06.24 08:57:04.793 2025.06.24 07:14:28.615 2025.06.24 07:14:29.661
10 6.0.0.854 2025.06.23 10b58 F F 1351 1048 2025.06.23 15:37:56.108 2025.06.23 15:37:57.459 2025.06.23 13:54:01.615 2025.06.23 13:54:02.663
11 6.0.0.849 2025.06.20 7b79c F F 1318 1029 2025.06.21 03:16:14.984 2025.06.21 03:16:16.302 2025.06.21 01:30:41.259 2025.06.21 01:30:42.288
12 6.0.0.848 2025.06.19 c483c F F 1302 1064 2025.06.20 03:15:52.531 2025.06.20 03:15:53.833 2025.06.20 01:30:26.300 2025.06.20 01:30:27.364
13 6.0.0.845 2025.06.18 20191 F F 1432 1041 2025.06.19 03:15:29.857 2025.06.19 03:15:31.289 2025.06.19 01:30:12.911 2025.06.19 01:30:13.952
14 6.0.0.843 2025.06.16 995f4 F F 1294 1036 2025.06.18 03:15:17.969 2025.06.18 03:15:19.263 2025.06.18 01:29:56.154 2025.06.18 01:29:57.190
15 6.0.0.840 2025.06.14 29bca F F 1307 1050 2025.06.15 03:23:48.245 2025.06.15 03:23:49.552 2025.06.15 01:32:59.213 2025.06.15 01:33:00.263
16 6.0.0.838 2025.06.13 0e28a F F 1361 1078 2025.06.14 03:21:31.801 2025.06.14 03:21:33.162 2025.06.14 01:31:18.730 2025.06.14 01:31:19.808
17 6.0.0.834 2025.06.11 e889f F F 1324 1039 2025.06.12 03:19:04.139 2025.06.12 03:19:05.463 2025.06.12 01:31:49.894 2025.06.12 01:31:50.933
18 6.0.0.800 2025.06.10 1f226 P P 1238 992 2025.06.11 02:03:10.352 2025.06.11 02:03:11.590 2025.06.11 00:54:37.499 2025.06.11 00:54:38.491
19 6.0.0.799 2025.06.07 be644 P P 1243 1029 2025.06.10 02:02:46.357 2025.06.10 02:02:47.600 2025.06.10 00:54:14.684 2025.06.10 00:54:15.713
20 6.0.0.797 2025.06.06 303e8 P P 1257 1004 2025.06.07 02:01:38.809 2025.06.07 02:01:40.066 2025.06.07 00:54:03.065 2025.06.07 00:54:04.069
21 6.0.0.795 2025.05.29 7a71a P P 1292 986 2025.06.06 02:01:29.401 2025.06.06 02:01:30.693 2025.06.06 00:54:00.787 2025.06.06 00:54:01.773
22 6.0.0.792 2025.05.28 ee5a8 P P 1236 988 2025.05.29 02:00:35.125 2025.05.29 02:00:36.361 2025.05.29 00:54:07.343 2025.05.29 00:54:08.331
23 6.0.0.791 2025.05.27 02db8 P P 1269 988 2025.05.28 02:01:04.041 2025.05.28 02:01:05.310 2025.05.28 00:53:50.372 2025.05.28 00:53:51.360
24 6.0.0.789 2025.05.21 64051 P P 1247 1015 2025.05.25 02:00:47.418 2025.05.25 02:00:48.665 2025.05.25 00:54:15.192 2025.05.25 00:54:16.207
25 6.0.0.787 2025.05.20 230ad P P 1242 1000 2025.05.21 01:59:43.067 2025.05.21 01:59:44.309 2025.05.21 00:53:24.929 2025.05.21 00:53:25.929
26 6.0.0.783 2025.05.12 37320 P P 1231 979 2025.05.19 01:59:30.401 2025.05.19 01:59:31.632 2025.05.19 00:53:32.583 2025.05.19 00:53:33.562
27 6.0.0.779 2025.05.11 136fa P P 1244 1009 2025.05.12 02:01:37.225 2025.05.12 02:01:38.469 2025.05.12 00:54:09.625 2025.05.12 00:54:10.634
28 6.0.0.778 2025.05.07 d735e P P 1274 971 2025.05.11 02:01:01.960 2025.05.11 02:01:03.234 2025.05.11 00:54:23.701 2025.05.11 00:54:24.672
29 6.0.0.776 2025.05.06 007cd P P 1294 985 2025.05.07 02:00:16.476 2025.05.07 02:00:17.770 2025.05.07 00:54:00.646 2025.05.07 00:54:01.631
30 6.0.0.770 2025.05.05 82c4a P P 1235 978 2025.05.06 02:00:35.572 2025.05.06 02:00:36.807 2025.05.06 00:54:06.933 2025.05.06 00:54:07.911
31 6.0.0.767 2025.05.01 cdd29 P P 1226 989 2025.05.02 02:01:11.381 2025.05.02 02:01:12.607 2025.05.02 00:54:58.022 2025.05.02 00:54:59.011
32 6.0.0.762 2025.04.30 5cb15 P P 1225 975 2025.05.01 01:59:38.522 2025.05.01 01:59:39.747 2025.05.01 00:54:19.661 2025.05.01 00:54:20.636
33 6.0.0.755 2025.04.29 739c6 P P 1228 966 2025.04.30 01:59:51.931 2025.04.30 01:59:53.159 2025.04.30 00:54:02.214 2025.04.30 00:54:03.180
34 6.0.0.753 2025.04.27 29ab3 P P 1235 1085 2025.04.29 02:00:02.301 2025.04.29 02:00:03.536 2025.04.29 00:54:05.750 2025.04.29 00:54:06.835
35 6.0.0.745 2025.04.21 78ad8 P P 1245 1010 2025.04.26 02:01:26.598 2025.04.26 02:01:27.843 2025.04.26 00:54:25.321 2025.04.26 00:54:26.331
36 6.0.0.744 2025.04.19 e883a P P 1254 1002 2025.04.20 02:00:53.798 2025.04.20 02:00:55.052 2025.04.20 00:54:18.405 2025.04.20 00:54:19.407
37 6.0.0.742 2025.04.17 abc3b P P 1286 987 2025.04.19 02:00:21.517 2025.04.19 02:00:22.803 2025.04.19 00:53:53.490 2025.04.19 00:53:54.477
38 6.0.0.737 2025.04.16 fe52b P P 1297 1060 2025.04.17 02:00:46.127 2025.04.17 02:00:47.424 2025.04.17 00:54:06.760 2025.04.17 00:54:07.820
39 6.0.0.736 2025.04.14 3e6be P P 1258 1016 2025.04.15 02:01:40.121 2025.04.15 02:01:41.379 2025.04.15 00:54:24.283 2025.04.15 00:54:25.299
40 6.0.0.735 2025.04.13 6635c P P 1252 989 2025.04.14 02:00:51.804 2025.04.14 02:00:53.056 2025.04.14 00:54:39.483 2025.04.14 00:54:40.472
41 6.0.0.734 2025.04.12 e2fd1 P P 1235 969 2025.04.13 01:58:41.164 2025.04.13 01:58:42.399 2025.04.13 00:53:36.796 2025.04.13 00:53:37.765
42 6.0.0.730 2025.04.11 240b8 P P 1239 998 2025.04.12 02:05:14.516 2025.04.12 02:05:15.755 2025.04.12 00:55:05.442 2025.04.12 00:55:06.440
43 6.0.0.726 2025.04.10 d79c6 P P 1264 1031 2025.04.11 02:05:36.072 2025.04.11 02:05:37.336 2025.04.11 00:54:54.614 2025.04.11 00:54:55.645
44 6.0.0.725 2025.04.09 a2b05 P P 1285 998 2025.04.10 02:04:48.308 2025.04.10 02:04:49.593 2025.04.10 00:54:47.430 2025.04.10 00:54:48.428
45 6.0.0.722 2025.04.08 a8b86 P P 1248 999 2025.04.09 02:01:26.442 2025.04.09 02:01:27.690 2025.04.09 00:54:26.220 2025.04.09 00:54:27.219
46 6.0.0.719 2025.04.06 90fd9 P P 1261 1000 2025.04.08 02:01:23.177 2025.04.08 02:01:24.438 2025.04.08 00:54:19.596 2025.04.08 00:54:20.596
47 6.0.0.717 2025.04.04 53d70 P P 1245 1046 2025.04.05 02:01:28.072 2025.04.05 02:01:29.317 2025.04.05 00:54:30.385 2025.04.05 00:54:31.431
48 6.0.0.716 2025.04.03 fc636 P P 1288 993 2025.04.04 02:01:26.499 2025.04.04 02:01:27.787 2025.04.04 00:54:34.568 2025.04.04 00:54:35.561
49 6.0.0.715 2025.04.02 907ed P P 1268 1060 2025.04.03 02:01:34.672 2025.04.03 02:01:35.940 2025.04.03 00:54:24.927 2025.04.03 00:54:25.987
50 6.0.0.710 2025.04.01 40651 P P 1255 1003 2025.04.02 02:01:40.433 2025.04.02 02:01:41.688 2025.04.02 00:55:08.156 2025.04.02 00:55:09.159
51 6.0.0.708 2025.03.31 cb069 P P 1254 978 2025.04.01 02:00:58.105 2025.04.01 02:00:59.359 2025.04.01 00:54:24.488 2025.04.01 00:54:25.466
52 6.0.0.707 2025.03.28 4bd4f P P 1303 999 2025.03.31 02:01:24.270 2025.03.31 02:01:25.573 2025.03.31 00:54:21.844 2025.03.31 00:54:22.843
53 6.0.0.702 2025.03.27 86f4d P P 1292 1027 2025.03.28 02:18:37.260 2025.03.28 02:18:38.552 2025.03.28 00:55:33.024 2025.03.28 00:55:34.051
54 6.0.0.698 2025.03.26 d72a7 P P 1281 996 2025.03.27 15:44:43.726 2025.03.27 15:44:45.007 2025.03.27 14:35:47.270 2025.03.27 14:35:48.266
55 6.0.0.693 2025.03.25 8aac2 P P 1288 1020 2025.03.26 02:05:20.940 2025.03.26 02:05:22.228 2025.03.26 00:56:13.278 2025.03.26 00:56:14.298
56 6.0.0.693 2025.03.24 0b559 P P 1290 1006 2025.03.25 02:05:56.642 2025.03.25 02:05:57.932 2025.03.25 00:56:13.993 2025.03.25 00:56:14.999
57 6.0.0.687 2025.03.22 730aa P P 1270 1037 2025.03.24 02:05:41.135 2025.03.24 02:05:42.405 2025.03.24 00:56:37.000 2025.03.24 00:56:38.037
58 6.0.0.686 2025.03.20 71bf6 P P 1246 1047 2025.03.21 02:02:11.706 2025.03.21 02:02:12.952 2025.03.21 00:55:01.907 2025.03.21 00:55:02.954
59 6.0.0.685 2025.03.19 a8577 P P 1249 1005 2025.03.20 02:02:25.951 2025.03.20 02:02:27.200 2025.03.20 00:55:33.786 2025.03.20 00:55:34.791
60 6.0.0.680 2025.03.18 90d29 P P 1244 1006 2025.03.19 02:02:44.310 2025.03.19 02:02:45.554 2025.03.19 00:55:40.155 2025.03.19 00:55:41.161
61 6.0.0.677 2025.03.16 c0a60 P P 1266 1007 2025.03.18 02:00:56.591 2025.03.18 02:00:57.857 2025.03.18 00:55:33.767 2025.03.18 00:55:34.774
62 6.0.0.676 2025.03.15 11cfb P P 1261 1006 2025.03.16 02:00:19.611 2025.03.16 02:00:20.872 2025.03.16 00:54:38.872 2025.03.16 00:54:39.878
63 6.0.0.674 2025.03.14 7d82c P P 1280 976 2025.03.15 01:58:54.579 2025.03.15 01:58:55.859 2025.03.15 00:55:08.778 2025.03.15 00:55:09.754
64 6.0.0.673 2025.03.13 40f5b P P 1235 1000 2025.03.14 14:29:57.924 2025.03.14 14:29:59.159 2025.03.14 13:25:00.570 2025.03.14 13:25:01.570
65 6.0.0.671 2025.03.12 a4fff P P 1291 1036 2025.03.13 02:04:21.602 2025.03.13 02:04:22.893 2025.03.13 00:56:45.938 2025.03.13 00:56:46.974
66 6.0.0.663 2025.03.11 65970 P P 1273 1075 2025.03.12 02:03:47.284 2025.03.12 02:03:48.557 2025.03.12 00:56:23.998 2025.03.12 00:56:25.073
67 6.0.0.661 2025.03.07 b9869 P P 1276 1043 2025.03.11 02:04:06.516 2025.03.11 02:04:07.792 2025.03.11 00:56:34.880 2025.03.11 00:56:35.923
68 6.0.0.660 2025.03.04 a6700 P P 1302 993 2025.03.06 02:04:16.792 2025.03.06 02:04:18.094 2025.03.06 00:56:22.580 2025.03.06 00:56:23.573
69 6.0.0.658 2025.03.03 f15f8 P P 1300 1003 2025.03.04 02:01:04.242 2025.03.04 02:01:05.542 2025.03.04 00:55:37.612 2025.03.04 00:55:38.615
70 6.0.0.656 2025.02.27 25fb4 P P 1257 1042 2025.03.03 02:01:15.423 2025.03.03 02:01:16.680 2025.03.03 00:55:42.772 2025.03.03 00:55:43.814
71 6.0.0.655 2025.02.25 6e3e0 P P 1363 1022 2025.02.27 02:02:51.770 2025.02.27 02:02:53.133 2025.02.27 00:56:18.491 2025.02.27 00:56:19.513
72 6.0.0.654 2025.02.24 b7141 P P 1254 1028 2025.02.25 01:59:41.545 2025.02.25 01:59:42.799 2025.02.25 00:55:04.169 2025.02.25 00:55:05.197
73 6.0.0.652 2025.02.22 22662 P P 1322 1014 2025.02.24 01:59:03.987 2025.02.24 01:59:05.309 2025.02.24 00:54:39.402 2025.02.24 00:54:40.416
74 6.0.0.647 2025.02.21 9fccb P P 1274 996 2025.02.22 01:58:03.497 2025.02.22 01:58:04.771 2025.02.22 00:54:18.073 2025.02.22 00:54:19.069
75 6.0.0.640 2025.02.19 9b8ac P P 1320 1001 2025.02.20 01:59:32.865 2025.02.20 01:59:34.185 2025.02.20 00:54:48.189 2025.02.20 00:54:49.190
76 6.0.0.639 2025.02.18 201a4 P P 1349 997 2025.02.19 02:00:21.582 2025.02.19 02:00:22.931 2025.02.19 00:55:29.080 2025.02.19 00:55:30.077
77 6.0.0.637 2025.02.12 6d0f5 P P 1249 1058 2025.02.14 02:01:00.272 2025.02.14 02:01:01.521 2025.02.14 00:55:51.570 2025.02.14 00:55:52.628
78 6.0.0.636 2025.02.11 0424f P P 1265 1007 2025.02.12 02:00:29.406 2025.02.12 02:00:30.671 2025.02.12 00:55:16.504 2025.02.12 00:55:17.511
79 6.0.0.635 2025.02.10 f640f P P 1263 1009 2025.02.11 01:59:58.204 2025.02.11 01:59:59.467 2025.02.11 00:55:05.705 2025.02.11 00:55:06.714
80 6.0.0.629 2025.02.07 194f9 P P 1244 995 2025.02.08 01:59:52.368 2025.02.08 01:59:53.612 2025.02.08 00:55:02.590 2025.02.08 00:55:03.585
81 6.0.0.628 2025.02.06 859d5 P P 1260 1005 2025.02.07 11:03:34.056 2025.02.07 11:03:35.316 2025.02.07 09:52:23.951 2025.02.07 09:52:24.956
82 6.0.0.621 2025.02.05 34fe7 P P 1240 1007 2025.02.07 02:13:36.241 2025.02.07 02:13:37.481 2025.02.07 01:02:05.094 2025.02.07 01:02:06.101
83 6.0.0.609 2025.02.04 76d57 P P 1253 1010 2025.02.05 02:13:25.314 2025.02.05 02:13:26.567 2025.02.05 01:02:11.076 2025.02.05 01:02:12.086
84 6.0.0.607 2025.02.03 1985b P P 1257 1014 2025.02.04 02:13:16.630 2025.02.04 02:13:17.887 2025.02.04 01:01:49.462 2025.02.04 01:01:50.476

Elapsed time, ms. Chart for last 84 runs:

Last commits information (all timestamps in UTC):