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-06-30 05:41:06.618
2025-06-30 05:41:06.625 act = <firebird.qa.plugin.Action object at [hex]>
2025-06-30 05:41:06.632 capsys = <_pytest.capture.CaptureFixture object at [hex]>
2025-06-30 05:41:06.638
2025-06-30 05:41:06.644 @pytest.mark.version('>=5.0.2')
2025-06-30 05:41:06.651 def test_1(act: Action, capsys):
2025-06-30 05:41:06.663 queries_map = { i : x for i,x in enumerate
2025-06-30 05:41:06.673 (
2025-06-30 05:41:06.680 [
2025-06-30 05:41:06.686 'select * from test where 5000 in (x, y)'
2025-06-30 05:41:06.696 ,'select * from test where 5000 in (u, v)'
2025-06-30 05:41:06.704 ,'select * from test where 5000 in (x, u)'
2025-06-30 05:41:06.718 ,'select * from test where 5000 in (v, y)'
2025-06-30 05:41:06.731 ,'select * from test where 5000 in (x+y, u-v)'
2025-06-30 05:41:06.739 ,'select * from test where 5000 in (p, q) and p < 5001 and q > 4999'
2025-06-30 05:41:06.750 ,'select * from test where 5000 in (p, q) and p > 4999 and q < 5001'
2025-06-30 05:41:06.761 ]
2025-06-30 05:41:06.769 )
2025-06-30 05:41:06.779 }
2025-06-30 05:41:06.792 with act.db.connect() as con:
2025-06-30 05:41:06.801 cur = con.cursor()
2025-06-30 05:41:06.808 for qry_idx, qry_txt in queries_map.items():
2025-06-30 05:41:06.815 ps = None
2025-06-30 05:41:06.822 try:
2025-06-30 05:41:06.829 ps = cur.prepare(qry_txt)
2025-06-30 05:41:06.836
2025-06-30 05:41:06.842 # Print explained plan with padding eash line by dots in order to see indentations:
2025-06-30 05:41:06.848 print(qry_txt)
2025-06-30 05:41:06.855 print( '\n'.join([replace_leading(s) for s in ps.detailed_plan.split('\n')]) )
2025-06-30 05:41:06.861 print('\n')
2025-06-30 05:41:06.870 except DatabaseError as e:
2025-06-30 05:41:06.878 print(e.__str__())
2025-06-30 05:41:06.886 print(e.gds_codes)
2025-06-30 05:41:06.894 finally:
2025-06-30 05:41:06.901 if ps:
2025-06-30 05:41:06.909 ps.free()
2025-06-30 05:41:06.916
2025-06-30 05:41:06.924
2025-06-30 05:41:06.935 expected_stdout = f"""
2025-06-30 05:41:06.948 {queries_map[ 0 ]}
2025-06-30 05:41:06.958 Select Expression
2025-06-30 05:41:06.964 ....-> Filter
2025-06-30 05:41:06.970 ........-> Table "TEST" Access By ID
2025-06-30 05:41:06.979 ............-> Bitmap Or
2025-06-30 05:41:06.989 ................-> Bitmap
2025-06-30 05:41:06.998 ....................-> Index "TEST_X_ASC" Range Scan (full match)
2025-06-30 05:41:07.005 ................-> Bitmap
2025-06-30 05:41:07.014 ....................-> Index "TEST_Y_ASC" Range Scan (full match)
2025-06-30 05:41:07.026
2025-06-30 05:41:07.036 {queries_map[ 1 ]}
2025-06-30 05:41:07.045 Select Expression
2025-06-30 05:41:07.051 ....-> Filter
2025-06-30 05:41:07.057 ........-> Table "TEST" Access By ID
2025-06-30 05:41:07.063 ............-> Bitmap Or
2025-06-30 05:41:07.069 ................-> Bitmap
2025-06-30 05:41:07.075 ....................-> Index "TEST_U_DEC" Range Scan (full match)
2025-06-30 05:41:07.081 ................-> Bitmap
2025-06-30 05:41:07.089 ....................-> Index "TEST_V_DEC" Range Scan (full match)
2025-06-30 05:41:07.102
2025-06-30 05:41:07.113 {queries_map[ 2 ]}
2025-06-30 05:41:07.122 Select Expression
2025-06-30 05:41:07.133 ....-> Filter
2025-06-30 05:41:07.143 ........-> Table "TEST" Access By ID
2025-06-30 05:41:07.153 ............-> Bitmap Or
2025-06-30 05:41:07.165 ................-> Bitmap
2025-06-30 05:41:07.176 ....................-> Index "TEST_X_ASC" Range Scan (full match)
2025-06-30 05:41:07.190 ................-> Bitmap
2025-06-30 05:41:07.201 ....................-> Index "TEST_U_DEC" Range Scan (full match)
2025-06-30 05:41:07.209
2025-06-30 05:41:07.216 {queries_map[ 3 ]}
2025-06-30 05:41:07.223 Select Expression
2025-06-30 05:41:07.229 ....-> Filter
2025-06-30 05:41:07.236 ........-> Table "TEST" Access By ID
2025-06-30 05:41:07.243 ............-> Bitmap Or
2025-06-30 05:41:07.253 ................-> Bitmap
2025-06-30 05:41:07.266 ....................-> Index "TEST_V_DEC" Range Scan (full match)
2025-06-30 05:41:07.276 ................-> Bitmap
2025-06-30 05:41:07.289 ....................-> Index "TEST_Y_ASC" Range Scan (full match)
2025-06-30 05:41:07.301
2025-06-30 05:41:07.310 {queries_map[ 4 ]}
2025-06-30 05:41:07.317 Select Expression
2025-06-30 05:41:07.326 ....-> Filter
2025-06-30 05:41:07.337 ........-> Table "TEST" Access By ID
2025-06-30 05:41:07.351 ............-> Bitmap Or
2025-06-30 05:41:07.363 ................-> Bitmap
2025-06-30 05:41:07.373 ....................-> Index "TEST_C_ASC" Range Scan (full match)
2025-06-30 05:41:07.381 ................-> Bitmap
2025-06-30 05:41:07.395 ....................-> Index "TEST_C_DEC" Range Scan (full match)
2025-06-30 05:41:07.407
2025-06-30 05:41:07.415 {queries_map[ 5 ]}
2025-06-30 05:41:07.422 Select Expression
2025-06-30 05:41:07.435 ....-> Filter
2025-06-30 05:41:07.445 ........-> Table "TEST" Access By ID
2025-06-30 05:41:07.454 ............-> Bitmap Or
2025-06-30 05:41:07.460 ................-> Bitmap
2025-06-30 05:41:07.467 ....................-> Index "TEST_P_ASC" Range Scan (full match)
2025-06-30 05:41:07.474 ................-> Bitmap
2025-06-30 05:41:07.480 ....................-> Index "TEST_Q_ASC" Range Scan (full match)
2025-06-30 05:41:07.487
2025-06-30 05:41:07.493 {queries_map[ 6 ]}
2025-06-30 05:41:07.500 Select Expression
2025-06-30 05:41:07.508 ....-> Filter
2025-06-30 05:41:07.515 ........-> Table "TEST" Access By ID
2025-06-30 05:41:07.523 ............-> Bitmap Or
2025-06-30 05:41:07.531 ................-> Bitmap
2025-06-30 05:41:07.539 ....................-> Index "TEST_P_DEC" Range Scan (full match)
2025-06-30 05:41:07.547 ................-> Bitmap
2025-06-30 05:41:07.555 ....................-> Index "TEST_Q_DEC" Range Scan (full match)
2025-06-30 05:41:07.563 """
2025-06-30 05:41:07.571
2025-06-30 05:41:07.579 act.expected_stdout = expected_stdout
2025-06-30 05:41:07.587 act.stdout = capsys.readouterr().out
2025-06-30 05:41:07.600 >       assert act.clean_stdout == act.clean_expected_stdout
2025-06-30 05:41:07.609 E       assert
2025-06-30 05:41:07.622 E           select * from test where 5000 in (x, y)
2025-06-30 05:41:07.631 E           Select Expression
2025-06-30 05:41:07.638 E           ....-> Filter
2025-06-30 05:41:07.646 E         - ........-> Table "TEST" Access By ID
2025-06-30 05:41:07.654 E         + ........-> Table "PUBLIC"."TEST" Access By ID
2025-06-30 05:41:07.676 E           ............-> Bitmap Or
2025-06-30 05:41:07.688 E           ................-> Bitmap
2025-06-30 05:41:07.698 E         - ....................-> Index "TEST_X_ASC" Range Scan (full match)
2025-06-30 05:41:07.707 E         + ....................-> Index "PUBLIC"."TEST_X_ASC" Range Scan (full match)
2025-06-30 05:41:07.724 E           ................-> Bitmap
2025-06-30 05:41:07.733 E         - ....................-> Index "TEST_Y_ASC" Range Scan (full match)
2025-06-30 05:41:07.744 E         + ....................-> Index "PUBLIC"."TEST_Y_ASC" Range Scan (full match)
2025-06-30 05:41:07.768 E           select * from test where 5000 in (u, v)
2025-06-30 05:41:07.779 E           Select Expression
2025-06-30 05:41:07.787 E           ....-> Filter
2025-06-30 05:41:07.795 E         - ........-> Table "TEST" Access By ID
2025-06-30 05:41:07.804 E         + ........-> Table "PUBLIC"."TEST" Access By ID
2025-06-30 05:41:07.822 E           ............-> Bitmap Or
2025-06-30 05:41:07.834 E           ................-> Bitmap
2025-06-30 05:41:07.845 E         - ....................-> Index "TEST_U_DEC" Range Scan (full match)
2025-06-30 05:41:07.853 E         + ....................-> Index "PUBLIC"."TEST_U_DEC" Range Scan (full match)
2025-06-30 05:41:07.866 E           ................-> Bitmap
2025-06-30 05:41:07.874 E         - ....................-> Index "TEST_V_DEC" Range Scan (full match)
2025-06-30 05:41:07.882 E         + ....................-> Index "PUBLIC"."TEST_V_DEC" Range Scan (full match)
2025-06-30 05:41:07.897 E           select * from test where 5000 in (x, u)
2025-06-30 05:41:07.905 E           Select Expression
2025-06-30 05:41:07.913 E           ....-> Filter
2025-06-30 05:41:07.921 E         - ........-> Table "TEST" Access By ID
2025-06-30 05:41:07.929 E         + ........-> Table "PUBLIC"."TEST" Access By ID
2025-06-30 05:41:07.953 E           ............-> Bitmap Or
2025-06-30 05:41:07.966 E           ................-> Bitmap
2025-06-30 05:41:07.976 E         - ....................-> Index "TEST_X_ASC" Range Scan (full match)
2025-06-30 05:41:07.991 E         + ....................-> Index "PUBLIC"."TEST_X_ASC" Range Scan (full match)
2025-06-30 05:41:08.009 E           ................-> Bitmap
2025-06-30 05:41:08.023 E         - ....................-> Index "TEST_U_DEC" Range Scan (full match)
2025-06-30 05:41:08.034 E         + ....................-> Index "PUBLIC"."TEST_U_DEC" Range Scan (full match)
2025-06-30 05:41:08.050 E           select * from test where 5000 in (v, y)
2025-06-30 05:41:08.056 E           Select Expression
2025-06-30 05:41:08.062 E           ....-> Filter
2025-06-30 05:41:08.070 E         - ........-> Table "TEST" Access By ID
2025-06-30 05:41:08.084 E         + ........-> Table "PUBLIC"."TEST" Access By ID
2025-06-30 05:41:08.102 E           ............-> Bitmap Or
2025-06-30 05:41:08.107 E           ................-> Bitmap
2025-06-30 05:41:08.116 E         - ....................-> Index "TEST_V_DEC" Range Scan (full match)
2025-06-30 05:41:08.122 E         + ....................-> Index "PUBLIC"."TEST_V_DEC" Range Scan (full match)
2025-06-30 05:41:08.142 E           ................-> Bitmap
2025-06-30 05:41:08.150 E         - ....................-> Index "TEST_Y_ASC" Range Scan (full match)
2025-06-30 05:41:08.159 E         + ....................-> Index "PUBLIC"."TEST_Y_ASC" Range Scan (full match)
2025-06-30 05:41:08.182 E           select * from test where 5000 in (x+y, u-v)
2025-06-30 05:41:08.190 E           Select Expression
2025-06-30 05:41:08.196 E           ....-> Filter
2025-06-30 05:41:08.202 E         - ........-> Table "TEST" Access By ID
2025-06-30 05:41:08.209 E         + ........-> Table "PUBLIC"."TEST" Access By ID
2025-06-30 05:41:08.222 E           ............-> Bitmap Or
2025-06-30 05:41:08.234 E           ................-> Bitmap
2025-06-30 05:41:08.243 E         - ....................-> Index "TEST_C_ASC" Range Scan (full match)
2025-06-30 05:41:08.254 E         + ....................-> Index "PUBLIC"."TEST_C_ASC" Range Scan (full match)
2025-06-30 05:41:08.278 E           ................-> Bitmap
2025-06-30 05:41:08.285 E         - ....................-> Index "TEST_C_DEC" Range Scan (full match)
2025-06-30 05:41:08.293 E         + ....................-> Index "PUBLIC"."TEST_C_DEC" Range Scan (full match)
2025-06-30 05:41:08.309 E           select * from test where 5000 in (p, q) and p < 5001 and q > 4999
2025-06-30 05:41:08.317 E           Select Expression
2025-06-30 05:41:08.323 E           ....-> Filter
2025-06-30 05:41:08.329 E         - ........-> Table "TEST" Access By ID
2025-06-30 05:41:08.336 E         + ........-> Table "PUBLIC"."TEST" Access By ID
2025-06-30 05:41:08.349 E           ............-> Bitmap Or
2025-06-30 05:41:08.356 E           ................-> Bitmap
2025-06-30 05:41:08.363 E         - ....................-> Index "TEST_P_ASC" Range Scan (full match)
2025-06-30 05:41:08.378 E         + ....................-> Index "PUBLIC"."TEST_P_ASC" Range Scan (full match)
2025-06-30 05:41:08.406 E           ................-> Bitmap
2025-06-30 05:41:08.416 E         - ....................-> Index "TEST_Q_ASC" Range Scan (full match)
2025-06-30 05:41:08.423 E         + ....................-> Index "PUBLIC"."TEST_Q_ASC" Range Scan (full match)
2025-06-30 05:41:08.445 E           select * from test where 5000 in (p, q) and p > 4999 and q < 5001
2025-06-30 05:41:08.452 E           Select Expression
2025-06-30 05:41:08.459 E           ....-> Filter
2025-06-30 05:41:08.467 E         - ........-> Table "TEST" Access By ID
2025-06-30 05:41:08.477 E         + ........-> Table "PUBLIC"."TEST" Access By ID
2025-06-30 05:41:08.500 E           ............-> Bitmap Or
2025-06-30 05:41:08.513 E           ................-> Bitmap
2025-06-30 05:41:08.526 E         - ....................-> Index "TEST_P_DEC" Range Scan (full match)
2025-06-30 05:41:08.539 E         + ....................-> Index "PUBLIC"."TEST_P_DEC" Range Scan (full match)
2025-06-30 05:41:08.557 E           ................-> Bitmap
2025-06-30 05:41:08.564 E         - ....................-> Index "TEST_Q_DEC" Range Scan (full match)
2025-06-30 05:41:08.573 E         + ....................-> Index "PUBLIC"."TEST_Q_DEC" Range Scan (full match)
2025-06-30 05:41:08.589
2025-06-30 05:41:08.597 tests/bugs/gh_8109_test.py:155: AssertionError
2025-06-30 05:41:08.605 ---------------------------- Captured stdout setup -----------------------------
2025-06-30 05:41:08.613 Creating db: localhost:/var/tmp/qa_2024/test_11689/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.881 2025.06.27 7035d F F 1935 2098 2025.06.30 02:04:17.354 2025.06.30 02:04:19.289 2025.06.29 23:19:41.876 2025.06.29 23:19:43.974
2 6.0.0.877 2025.06.26 8e38f F F 1707 2003 2025.06.27 01:43:18.092 2025.06.27 01:43:19.799 2025.06.26 23:10:41.954 2025.06.26 23:10:43.957
3 6.0.0.876 2025.06.25 b1bec F F 1769 1875 2025.06.26 01:47:08.416 2025.06.26 01:47:10.185 2025.06.25 23:12:37.583 2025.06.25 23:12:39.458
4 6.0.0.863 2025.06.24 c3c20 F F 1809 2314 2025.06.25 01:47:26.223 2025.06.25 01:47:28.032 2025.06.24 23:12:21.898 2025.06.24 23:12:24.212
5 6.0.0.858 2025.06.23 8d6f7 F F 1983 1760 2025.06.24 01:47:47.723 2025.06.24 01:47:49.706 2025.06.23 23:12:29.662 2025.06.23 23:12:31.422
6 6.0.0.849 2025.06.20 7b79c F F 1786 1807 2025.06.21 01:59:20.356 2025.06.21 01:59:22.142 2025.06.20 23:21:42.348 2025.06.20 23:21:44.155
7 6.0.0.848 2025.06.19 c483c F F 1771 2236 2025.06.20 01:55:41.153 2025.06.20 01:55:42.924 2025.06.19 23:18:29.958 2025.06.19 23:18:32.194
8 6.0.0.845 2025.06.18 22b12 F F 1814 1957 2025.06.19 02:04:20.993 2025.06.19 02:04:22.807 2025.06.18 23:21:37.791 2025.06.18 23:21:39.748
9 6.0.0.843 2025.06.16 995f4 F F 1914 1198 2025.06.18 02:02:35.767 2025.06.18 02:02:37.681 2025.06.17 23:23:49.287 2025.06.17 23:23:50.485
10 6.0.0.840 2025.06.14 29bca F F 1688 1896 2025.06.16 01:54:24.066 2025.06.16 01:54:25.754 2025.06.15 23:15:54.930 2025.06.15 23:15:56.826
11 6.0.0.838 2025.06.13 0e28a F F 1861 1738 2025.06.14 02:07:27.758 2025.06.14 02:07:29.619 2025.06.13 23:23:34.400 2025.06.13 23:23:36.138
12 6.0.0.835 2025.06.12 2cf29 F F 1757 2005 2025.06.13 02:07:24.234 2025.06.13 02:07:25.991 2025.06.12 23:27:37.538 2025.06.12 23:27:39.543
13 6.0.0.834 2025.06.11 e889f F F 1747 2133 2025.06.12 02:02:36.899 2025.06.12 02:02:38.646 2025.06.11 23:23:47.032 2025.06.11 23:23:49.165
14 6.0.0.800 2025.06.10 1f226 P P 2970 2192 2025.06.11 00:29:42.496 2025.06.11 00:29:45.466 2025.06.10 22:21:57.278 2025.06.10 22:21:59.470
15 6.0.0.799 2025.06.07 be644 P P 1798 2147 2025.06.10 00:31:06.772 2025.06.10 00:31:08.570 2025.06.09 22:21:31.950 2025.06.09 22:21:34.097
16 6.0.0.797 2025.06.06 303e8 P P 1678 2480 2025.06.07 00:34:50.195 2025.06.07 00:34:51.873 2025.06.06 22:21:04.071 2025.06.06 22:21:06.551
17 6.0.0.795 2025.05.29 7a71a P P 1690 2184 2025.06.06 00:29:39.906 2025.06.06 00:29:41.596 2025.06.05 22:20:13.335 2025.06.05 22:20:15.519
18 6.0.0.792 2025.05.28 b4327 P P 1832 2630 2025.05.29 00:43:52.190 2025.05.29 00:43:54.022 2025.05.28 22:23:11.224 2025.05.28 22:23:13.854
19 6.0.0.791 2025.05.27 02db8 P P 3198 2209 2025.05.28 00:40:51.711 2025.05.28 00:40:54.909 2025.05.27 22:22:14.706 2025.05.27 22:22:16.915
20 6.0.0.789 2025.05.21 64051 P P 1832 2416 2025.05.25 00:33:31.483 2025.05.25 00:33:33.315 2025.05.24 22:21:25.283 2025.05.24 22:21:27.699
21 6.0.0.787 2025.05.20 230ad P P 3008 2376 2025.05.21 00:30:43.110 2025.05.21 00:30:46.118 2025.05.20 22:19:52.023 2025.05.20 22:19:54.399
22 6.0.0.783 2025.05.12 37320 P P 2127 1722 2025.05.19 12:04:05.769 2025.05.19 12:04:07.896 2025.05.19 10:08:34.982 2025.05.19 10:08:36.704
23 6.0.0.779 2025.05.11 136fa P P 3043 2139 2025.05.12 00:26:05.264 2025.05.12 00:26:08.307 2025.05.11 22:19:21.679 2025.05.11 22:19:23.818
24 6.0.0.778 2025.05.07 d735e P P 3137 2206 2025.05.08 00:28:17.198 2025.05.08 00:28:20.335 2025.05.07 22:18:09.805 2025.05.07 22:18:12.011
25 6.0.0.776 2025.05.06 007cd P P 3333 1449 2025.05.07 00:22:36.889 2025.05.07 00:22:40.222 2025.05.06 22:18:05.798 2025.05.06 22:18:07.247
26 6.0.0.770 2025.05.05 82c4a P P 3100 1374 2025.05.06 00:21:50.358 2025.05.06 00:21:53.458 2025.05.05 22:17:20.622 2025.05.05 22:17:21.996
27 6.0.0.767 2025.05.01 cdd29 P P 1751 1500 2025.05.02 00:18:52.646 2025.05.02 00:18:54.397 2025.05.01 22:16:53.434 2025.05.01 22:16:54.934
28 6.0.0.762 2025.04.30 5cb15 P P 2104 2067 2025.05.01 00:14:59.995 2025.05.01 00:15:02.099 2025.04.30 22:15:40.948 2025.04.30 22:15:43.015
29 6.0.0.755 2025.04.29 739c6 P P 1823 1380 2025.04.30 00:17:42.840 2025.04.30 00:17:44.663 2025.04.29 22:16:56.854 2025.04.29 22:16:58.234
30 6.0.0.753 2025.04.27 29ab3 P P 3319 2691 2025.04.28 00:19:59.439 2025.04.28 00:20:02.758 2025.04.27 22:16:20.244 2025.04.27 22:16:22.935
31 6.0.0.745 2025.04.21 78ad8 P P 2748 2467 2025.04.26 00:15:50.734 2025.04.26 00:15:53.482 2025.04.25 22:17:39.466 2025.04.25 22:17:41.933
32 6.0.0.744 2025.04.19 e883a P P 1644 1411 2025.04.20 00:17:50.071 2025.04.20 00:17:51.715 2025.04.19 22:17:06.843 2025.04.19 22:17:08.254
33 6.0.0.742 2025.04.17 abc3b P P 1680 1379 2025.04.19 00:19:36.639 2025.04.19 00:19:38.319 2025.04.18 22:17:23.521 2025.04.18 22:17:24.900
34 6.0.0.737 2025.04.16 fe52b P P 1647 1487 2025.04.17 00:16:32.065 2025.04.17 00:16:33.712 2025.04.16 22:17:25.086 2025.04.16 22:17:26.573
35 6.0.0.736 2025.04.14 3e6be P P 2301 1605 2025.04.14 23:57:49.450 2025.04.14 23:57:51.751 2025.04.14 22:09:03.142 2025.04.14 22:09:04.747
36 6.0.0.735 2025.04.13 6635c P P 2785 2074 2025.04.14 00:01:05.898 2025.04.14 00:01:08.683 2025.04.13 22:10:16.391 2025.04.13 22:10:18.465
37 6.0.0.734 2025.04.12 12f3f P P 1757 1856 2025.04.12 23:58:35.555 2025.04.12 23:58:37.312 2025.04.12 22:09:31.166 2025.04.12 22:09:33.022
38 6.0.0.730 2025.04.11 240b8 P P 3004 2019 2025.04.12 00:00:37.550 2025.04.12 00:00:40.554 2025.04.11 22:09:04.123 2025.04.11 22:09:06.142
39 6.0.0.726 2025.04.10 d79c6 P P 2887 2064 2025.04.11 00:00:13.845 2025.04.11 00:00:16.732 2025.04.10 22:09:07.459 2025.04.10 22:09:09.523
40 6.0.0.725 2025.04.09 a2b05 P P 2803 1973 2025.04.10 00:01:23.704 2025.04.10 00:01:26.507 2025.04.09 22:10:47.294 2025.04.09 22:10:49.267
41 6.0.0.722 2025.04.08 a8b86 P P 2884 1527 2025.04.09 00:17:08.250 2025.04.09 00:17:11.134 2025.04.08 22:16:50.618 2025.04.08 22:16:52.145
42 6.0.0.719 2025.04.06 90fd9 P P 1755 2395 2025.04.07 00:14:33.161 2025.04.07 00:14:34.916 2025.04.06 22:15:34.407 2025.04.06 22:15:36.802
43 6.0.0.717 2025.04.04 53d70 P P 1718 2083 2025.04.05 00:09:45.021 2025.04.05 00:09:46.739 2025.04.04 22:14:56.430 2025.04.04 22:14:58.513
44 6.0.0.716 2025.04.03 fc636 P P 1907 1353 2025.04.04 00:14:27.842 2025.04.04 00:14:29.749 2025.04.03 22:16:22.900 2025.04.03 22:16:24.253
45 6.0.0.715 2025.04.02 907ed P P 2836 1390 2025.04.03 00:14:04.562 2025.04.03 00:14:07.398 2025.04.02 22:16:27.648 2025.04.02 22:16:29.038
46 6.0.0.710 2025.04.01 40651 P P 2864 1494 2025.04.02 00:12:52.478 2025.04.02 00:12:55.342 2025.04.01 22:15:37.694 2025.04.01 22:15:39.188
47 6.0.0.708 2025.03.31 cb069 P P 3067 2388 2025.04.01 00:03:14.774 2025.04.01 00:03:17.841 2025.03.31 22:10:19.326 2025.03.31 22:10:21.714
48 6.0.0.707 2025.03.28 4bd4f P P 2817 1951 2025.03.31 00:03:48.576 2025.03.31 00:03:51.393 2025.03.30 22:10:56.536 2025.03.30 22:10:58.487
49 6.0.0.698 2025.03.26 d72a7 P P 3168 1686 2025.03.28 00:26:16.591 2025.03.28 00:26:19.759 2025.03.27 22:16:59.948 2025.03.27 22:17:01.634
50 6.0.0.693 2025.03.24 0b559 P P 2736 1985 2025.03.25 00:12:36.206 2025.03.25 00:12:38.942 2025.03.24 22:13:47.318 2025.03.24 22:13:49.303
51 6.0.0.687 2025.03.22 730aa P P 1790 1908 2025.03.24 00:22:57.240 2025.03.24 00:22:59.030 2025.03.23 22:20:06.411 2025.03.23 22:20:08.319
52 6.0.0.686 2025.03.20 71bf6 P P 3231 2182 2025.03.21 00:29:25.734 2025.03.21 00:29:28.965 2025.03.20 22:22:21.627 2025.03.20 22:22:23.809
53 6.0.0.685 2025.03.19 a8577 P P 3140 2810 2025.03.20 00:32:34.286 2025.03.20 00:32:37.426 2025.03.19 22:20:19.616 2025.03.19 22:20:22.426
54 6.0.0.680 2025.03.18 90d29 P P 834 454 2025.03.19 10:51:50.143 2025.03.19 10:51:50.977 2025.03.19 09:06:15.473 2025.03.19 09:06:15.927
55 6.0.0.677 2025.03.16 c0a60 P P 695 624 2025.03.17 00:21:26.253 2025.03.17 00:21:26.948 2025.03.16 22:19:57.386 2025.03.16 22:19:58.010
56 6.0.0.676 2025.03.15 3034f P P 861 472 2025.03.16 15:53:49.225 2025.03.16 15:53:50.086 2025.03.16 14:10:50.493 2025.03.16 14:10:50.965
57 6.0.0.673 2025.03.13 40f5b P P 742 663 2025.03.14 00:19:56.619 2025.03.14 00:19:57.361 2025.03.13 22:18:46.103 2025.03.13 22:18:46.766
58 6.0.0.671 2025.03.12 a4fff P P 753 668 2025.03.13 00:23:30.852 2025.03.13 00:23:31.605 2025.03.12 22:21:43.870 2025.03.12 22:21:44.538
59 6.0.0.663 2025.03.11 daad2 P P 622 735 2025.03.12 00:21:43.417 2025.03.12 00:21:44.039 2025.03.11 22:21:05.923 2025.03.11 22:21:06.658
60 6.0.0.661 2025.03.07 b9869 P P 1176 590 2025.03.11 00:00:43.218 2025.03.11 00:00:44.394 2025.03.10 22:12:58.253 2025.03.10 22:12:58.843
61 6.0.0.660 2025.03.04 a6700 P P 1115 326 2025.03.07 00:09:58.795 2025.03.07 00:09:59.910 2025.03.06 22:16:28.643 2025.03.06 22:16:28.969
62 6.0.0.658 2025.03.03 f15f8 P P 658 605 2025.03.04 00:04:24.333 2025.03.04 00:04:24.991 2025.03.03 22:13:08.306 2025.03.03 22:13:08.911
63 6.0.0.656 2025.02.27 25fb4 P P 709 572 2025.03.03 00:32:51.288 2025.03.03 00:32:51.997 2025.03.02 22:23:10.253 2025.03.02 22:23:10.825
64 6.0.0.655 2025.02.25 6e3e0 P P 1239 367 2025.02.27 00:08:35.378 2025.02.27 00:08:36.617 2025.02.26 22:15:04.237 2025.02.26 22:15:04.604
65 6.0.0.654 2025.02.24 b7141 P P 632 329 2025.02.25 00:11:43.507 2025.02.25 00:11:44.139 2025.02.24 22:16:14.274 2025.02.24 22:16:14.603
66 6.0.0.652 2025.02.22 22662 P P 850 404 2025.02.24 07:29:07.462 2025.02.24 07:29:08.312 2025.02.24 00:29:29.838 2025.02.24 00:29:30.242
67 6.0.0.647 2025.02.21 9fccb P P 664 616 2025.02.22 00:12:58.565 2025.02.22 00:12:59.229 2025.02.21 22:20:14.891 2025.02.21 22:20:15.507
68 6.0.0.640 2025.02.19 9b8ac P P 691 430 2025.02.20 00:11:00.794 2025.02.20 00:11:01.485 2025.02.19 22:15:01.575 2025.02.19 22:15:02.005
69 6.0.0.639 2025.02.18 201a4 P P 684 460 2025.02.19 00:03:00.935 2025.02.19 00:03:01.619 2025.02.18 22:14:06.258 2025.02.18 22:14:06.718
70 6.0.0.637 2025.02.12 6d0f5 P P 756 683 2025.02.14 00:20:48.783 2025.02.14 00:20:49.539 2025.02.13 22:19:59.167 2025.02.13 22:19:59.850
71 6.0.0.636 2025.02.11 0424f P P 674 695 2025.02.12 00:18:27.296 2025.02.12 00:18:27.970 2025.02.11 22:19:25.922 2025.02.11 22:19:26.617
72 6.0.0.635 2025.02.10 f640f P P 1120 508 2025.02.11 00:15:57.318 2025.02.11 00:15:58.438 2025.02.10 22:20:03.499 2025.02.10 22:20:04.007
73 6.0.0.629 2025.02.07 194f9 P P 718 677 2025.02.08 00:16:16.334 2025.02.08 00:16:17.052 2025.02.07 22:18:31.358 2025.02.07 22:18:32.035
74 6.0.0.628 2025.02.06 859d5 P P 742 541 2025.02.07 00:32:22.770 2025.02.07 00:32:23.512 2025.02.06 22:26:37.654 2025.02.06 22:26:38.195
75 6.0.0.621 2025.02.05 34fe7 P P 1287 623 2025.02.06 00:28:44.030 2025.02.06 00:28:45.317 2025.02.05 22:27:06.031 2025.02.05 22:27:06.654
76 6.0.0.609 2025.02.04 76d57 P P 636 593 2025.02.05 00:21:38.576 2025.02.05 00:21:39.212 2025.02.04 22:24:07.794 2025.02.04 22:24:08.387
77 6.0.0.607 2025.02.03 1985b P P 1238 344 2025.02.04 00:20:20.875 2025.02.04 00:20:22.113 2025.02.03 22:24:35.313 2025.02.03 22:24:35.657

Elapsed time, ms. Chart for last 77 runs:

Last commits information (all timestamps in UTC):