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
    ............-> Bitmap Or
    ................-> Bitmap
  + ....................-> Index "TEST_Y_ASC" Range Scan (full match)
  + ................-> Bitmap
    ....................-> Index "TEST_X_ASC" Range Scan (full match)
  + select * from test where 5000 in (u, v)
  + Select Expression
  + ....-> Filter
  + ........-> Table "TEST" Access By ID
  + ............-> Bitmap Or
    ................-> Bitmap
  - ....................-> Index "TEST_Y_ASC" Range Scan (full match)
  + ....................-> Index "TEST_V_DEC" Range Scan (full match)
  + ................-> Bitmap
  + ....................-> Index "TEST_U_DEC" Range Scan (full match)
  - select * from test where 5000 in (u, v)
  + select * from test where 5000 in (x, u)
    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)
  - select * from test where 5000 in (x, u)
  - 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)
    select * from test where 5000 in (v, y)
    Select Expression
    ....-> Filter
    ........-> Table "TEST" Access By ID
    ............-> Bitmap Or
    ................-> Bitmap
  + ....................-> Index "TEST_Y_ASC" Range Scan (full match)
  + ................-> Bitmap
    ....................-> Index "TEST_V_DEC" Range Scan (full match)
  - ................-> Bitmap
  - ....................-> Index "TEST_Y_ASC" Range Scan (full match)
    select * from test where 5000 in (x+y, u-v)
    Select Expression
    ....-> Filter
  + ........-> Table "TEST" Full Scan
  - ........-> 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)
    select * from test where 5000 in (p, q) and p < 5001 and q > 4999
    Select Expression
    ....-> Filter
    ........-> Table "TEST" Access By ID
    ............-> Bitmap Or
    ................-> Bitmap
  + ....................-> Index "TEST_Q_ASC" Range Scan (full match)
  + ................-> Bitmap
    ....................-> Index "TEST_P_ASC" Range Scan (full match)
  - ................-> Bitmap
  - ....................-> Index "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
    ............-> Bitmap Or
    ................-> Bitmap
  + ....................-> Index "TEST_Q_DEC" Range Scan (full match)
  + ................-> Bitmap
    ....................-> Index "TEST_P_DEC" Range Scan (full match)
  - ................-> Bitmap
  - ....................-> Index "TEST_Q_DEC" Range Scan (full match)

LOG DETAILS:

2025-02-14 14:31:18.616
2025-02-14 14:31:18.624 act = <firebird.qa.plugin.Action object at [hex]>
2025-02-14 14:31:18.633 capsys = <_pytest.capture.CaptureFixture object at [hex]>
2025-02-14 14:31:18.639
2025-02-14 14:31:18.646 @pytest.mark.version('>=5.0.2')
2025-02-14 14:31:18.652 def test_1(act: Action, capsys):
2025-02-14 14:31:18.659 queries_map = { i : x for i,x in enumerate
2025-02-14 14:31:18.666 (
2025-02-14 14:31:18.676 [
2025-02-14 14:31:18.684 'select * from test where 5000 in (x, y)'
2025-02-14 14:31:18.691 ,'select * from test where 5000 in (u, v)'
2025-02-14 14:31:18.697 ,'select * from test where 5000 in (x, u)'
2025-02-14 14:31:18.704 ,'select * from test where 5000 in (v, y)'
2025-02-14 14:31:18.709 ,'select * from test where 5000 in (x+y, u-v)'
2025-02-14 14:31:18.715 ,'select * from test where 5000 in (p, q) and p < 5001 and q > 4999'
2025-02-14 14:31:18.721 ,'select * from test where 5000 in (p, q) and p > 4999 and q < 5001'
2025-02-14 14:31:18.727 ]
2025-02-14 14:31:18.733 )
2025-02-14 14:31:18.738 }
2025-02-14 14:31:18.744 with act.db.connect() as con:
2025-02-14 14:31:18.749 cur = con.cursor()
2025-02-14 14:31:18.755 for qry_idx, qry_txt in queries_map.items():
2025-02-14 14:31:18.761 ps = None
2025-02-14 14:31:18.766 try:
2025-02-14 14:31:18.771 ps = cur.prepare(qry_txt)
2025-02-14 14:31:18.776
2025-02-14 14:31:18.782 # Print explained plan with padding eash line by dots in order to see indentations:
2025-02-14 14:31:18.787 print(qry_txt)
2025-02-14 14:31:18.794 print( '\n'.join([replace_leading(s) for s in ps.detailed_plan.split('\n')]) )
2025-02-14 14:31:18.800 print('\n')
2025-02-14 14:31:18.807 except DatabaseError as e:
2025-02-14 14:31:18.813 print(e.__str__())
2025-02-14 14:31:18.819 print(e.gds_codes)
2025-02-14 14:31:18.826 finally:
2025-02-14 14:31:18.832 if ps:
2025-02-14 14:31:18.840 ps.free()
2025-02-14 14:31:18.846
2025-02-14 14:31:18.852
2025-02-14 14:31:18.860 expected_stdout = f"""
2025-02-14 14:31:18.866 {queries_map[ 0 ]}
2025-02-14 14:31:18.873 Select Expression
2025-02-14 14:31:18.881 ....-> Filter
2025-02-14 14:31:18.888 ........-> Table "TEST" Access By ID
2025-02-14 14:31:18.896 ............-> Bitmap Or
2025-02-14 14:31:18.903 ................-> Bitmap
2025-02-14 14:31:18.910 ....................-> Index "TEST_X_ASC" Range Scan (full match)
2025-02-14 14:31:18.916 ................-> Bitmap
2025-02-14 14:31:18.925 ....................-> Index "TEST_Y_ASC" Range Scan (full match)
2025-02-14 14:31:18.931
2025-02-14 14:31:18.939 {queries_map[ 1 ]}
2025-02-14 14:31:18.946 Select Expression
2025-02-14 14:31:18.953 ....-> Filter
2025-02-14 14:31:18.960 ........-> Table "TEST" Access By ID
2025-02-14 14:31:18.968 ............-> Bitmap Or
2025-02-14 14:31:18.976 ................-> Bitmap
2025-02-14 14:31:18.991 ....................-> Index "TEST_U_DEC" Range Scan (full match)
2025-02-14 14:31:19.007 ................-> Bitmap
2025-02-14 14:31:19.017 ....................-> Index "TEST_V_DEC" Range Scan (full match)
2025-02-14 14:31:19.024
2025-02-14 14:31:19.031 {queries_map[ 2 ]}
2025-02-14 14:31:19.038 Select Expression
2025-02-14 14:31:19.046 ....-> Filter
2025-02-14 14:31:19.054 ........-> Table "TEST" Access By ID
2025-02-14 14:31:19.063 ............-> Bitmap Or
2025-02-14 14:31:19.071 ................-> Bitmap
2025-02-14 14:31:19.078 ....................-> Index "TEST_X_ASC" Range Scan (full match)
2025-02-14 14:31:19.086 ................-> Bitmap
2025-02-14 14:31:19.093 ....................-> Index "TEST_U_DEC" Range Scan (full match)
2025-02-14 14:31:19.100
2025-02-14 14:31:19.107 {queries_map[ 3 ]}
2025-02-14 14:31:19.115 Select Expression
2025-02-14 14:31:19.122 ....-> Filter
2025-02-14 14:31:19.130 ........-> Table "TEST" Access By ID
2025-02-14 14:31:19.137 ............-> Bitmap Or
2025-02-14 14:31:19.144 ................-> Bitmap
2025-02-14 14:31:19.151 ....................-> Index "TEST_V_DEC" Range Scan (full match)
2025-02-14 14:31:19.157 ................-> Bitmap
2025-02-14 14:31:19.165 ....................-> Index "TEST_Y_ASC" Range Scan (full match)
2025-02-14 14:31:19.171
2025-02-14 14:31:19.178 {queries_map[ 4 ]}
2025-02-14 14:31:19.184 Select Expression
2025-02-14 14:31:19.191 ....-> Filter
2025-02-14 14:31:19.198 ........-> Table "TEST" Access By ID
2025-02-14 14:31:19.205 ............-> Bitmap Or
2025-02-14 14:31:19.212 ................-> Bitmap
2025-02-14 14:31:19.220 ....................-> Index "TEST_C_ASC" Range Scan (full match)
2025-02-14 14:31:19.226 ................-> Bitmap
2025-02-14 14:31:19.233 ....................-> Index "TEST_C_DEC" Range Scan (full match)
2025-02-14 14:31:19.240
2025-02-14 14:31:19.247 {queries_map[ 5 ]}
2025-02-14 14:31:19.254 Select Expression
2025-02-14 14:31:19.261 ....-> Filter
2025-02-14 14:31:19.267 ........-> Table "TEST" Access By ID
2025-02-14 14:31:19.276 ............-> Bitmap Or
2025-02-14 14:31:19.284 ................-> Bitmap
2025-02-14 14:31:19.291 ....................-> Index "TEST_P_ASC" Range Scan (full match)
2025-02-14 14:31:19.297 ................-> Bitmap
2025-02-14 14:31:19.305 ....................-> Index "TEST_Q_ASC" Range Scan (full match)
2025-02-14 14:31:19.312
2025-02-14 14:31:19.319 {queries_map[ 6 ]}
2025-02-14 14:31:19.326 Select Expression
2025-02-14 14:31:19.334 ....-> Filter
2025-02-14 14:31:19.341 ........-> Table "TEST" Access By ID
2025-02-14 14:31:19.349 ............-> Bitmap Or
2025-02-14 14:31:19.355 ................-> Bitmap
2025-02-14 14:31:19.361 ....................-> Index "TEST_P_DEC" Range Scan (full match)
2025-02-14 14:31:19.368 ................-> Bitmap
2025-02-14 14:31:19.374 ....................-> Index "TEST_Q_DEC" Range Scan (full match)
2025-02-14 14:31:19.380 """
2025-02-14 14:31:19.386
2025-02-14 14:31:19.391 act.expected_stdout = expected_stdout
2025-02-14 14:31:19.397 act.stdout = capsys.readouterr().out
2025-02-14 14:31:19.403 >       assert act.clean_stdout == act.clean_expected_stdout
2025-02-14 14:31:19.409 E       assert
2025-02-14 14:31:19.414 E           select * from test where 5000 in (x, y)
2025-02-14 14:31:19.422 E           Select Expression
2025-02-14 14:31:19.429 E           ....-> Filter
2025-02-14 14:31:19.437 E           ........-> Table "TEST" Access By ID
2025-02-14 14:31:19.444 E           ............-> Bitmap Or
2025-02-14 14:31:19.459 E           ................-> Bitmap
2025-02-14 14:31:19.470 E         + ....................-> Index "TEST_Y_ASC" Range Scan (full match)
2025-02-14 14:31:19.482 E         + ................-> Bitmap
2025-02-14 14:31:19.497 E           ....................-> Index "TEST_X_ASC" Range Scan (full match)
2025-02-14 14:31:19.505 E         + select * from test where 5000 in (u, v)
2025-02-14 14:31:19.514 E         + Select Expression
2025-02-14 14:31:19.522 E         + ....-> Filter
2025-02-14 14:31:19.532 E         + ........-> Table "TEST" Access By ID
2025-02-14 14:31:19.548 E         + ............-> Bitmap Or
2025-02-14 14:31:19.559 E           ................-> Bitmap
2025-02-14 14:31:19.571 E         - ....................-> Index "TEST_Y_ASC" Range Scan (full match)
2025-02-14 14:31:19.594 E         + ....................-> Index "TEST_V_DEC" Range Scan (full match)
2025-02-14 14:31:19.610 E         + ................-> Bitmap
2025-02-14 14:31:19.625 E         + ....................-> Index "TEST_U_DEC" Range Scan (full match)
2025-02-14 14:31:19.636 E         - select * from test where 5000 in (u, v)
2025-02-14 14:31:19.660 E         + select * from test where 5000 in (x, u)
2025-02-14 14:31:19.680 E           Select Expression
2025-02-14 14:31:19.688 E           ....-> Filter
2025-02-14 14:31:19.695 E           ........-> Table "TEST" Access By ID
2025-02-14 14:31:19.703 E           ............-> Bitmap Or
2025-02-14 14:31:19.711 E           ................-> Bitmap
2025-02-14 14:31:19.721 E           ....................-> Index "TEST_U_DEC" Range Scan (full match)
2025-02-14 14:31:19.730 E           ................-> Bitmap
2025-02-14 14:31:19.737 E         - ....................-> Index "TEST_V_DEC" Range Scan (full match)
2025-02-14 14:31:19.744 E         - select * from test where 5000 in (x, u)
2025-02-14 14:31:19.750 E         - Select Expression
2025-02-14 14:31:19.757 E         - ....-> Filter
2025-02-14 14:31:19.764 E         - ........-> Table "TEST" Access By ID
2025-02-14 14:31:19.771 E         - ............-> Bitmap Or
2025-02-14 14:31:19.780 E         - ................-> Bitmap
2025-02-14 14:31:19.790 E           ....................-> Index "TEST_X_ASC" Range Scan (full match)
2025-02-14 14:31:19.799 E         - ................-> Bitmap
2025-02-14 14:31:19.808 E         - ....................-> Index "TEST_U_DEC" Range Scan (full match)
2025-02-14 14:31:19.817 E           select * from test where 5000 in (v, y)
2025-02-14 14:31:19.828 E           Select Expression
2025-02-14 14:31:19.841 E           ....-> Filter
2025-02-14 14:31:19.851 E           ........-> Table "TEST" Access By ID
2025-02-14 14:31:19.862 E           ............-> Bitmap Or
2025-02-14 14:31:19.873 E           ................-> Bitmap
2025-02-14 14:31:19.883 E         + ....................-> Index "TEST_Y_ASC" Range Scan (full match)
2025-02-14 14:31:19.893 E         + ................-> Bitmap
2025-02-14 14:31:19.909 E           ....................-> Index "TEST_V_DEC" Range Scan (full match)
2025-02-14 14:31:19.921 E         - ................-> Bitmap
2025-02-14 14:31:19.931 E         - ....................-> Index "TEST_Y_ASC" Range Scan (full match)
2025-02-14 14:31:19.942 E           select * from test where 5000 in (x+y, u-v)
2025-02-14 14:31:19.957 E           Select Expression
2025-02-14 14:31:19.973 E           ....-> Filter
2025-02-14 14:31:19.983 E         + ........-> Table "TEST" Full Scan
2025-02-14 14:31:19.998 E         - ........-> Table "TEST" Access By ID
2025-02-14 14:31:20.009 E         - ............-> Bitmap Or
2025-02-14 14:31:20.019 E         - ................-> Bitmap
2025-02-14 14:31:20.028 E         - ....................-> Index "TEST_C_ASC" Range Scan (full match)
2025-02-14 14:31:20.036 E         - ................-> Bitmap
2025-02-14 14:31:20.044 E         - ....................-> Index "TEST_C_DEC" Range Scan (full match)
2025-02-14 14:31:20.052 E           select * from test where 5000 in (p, q) and p < 5001 and q > 4999
2025-02-14 14:31:20.060 E           Select Expression
2025-02-14 14:31:20.068 E           ....-> Filter
2025-02-14 14:31:20.076 E           ........-> Table "TEST" Access By ID
2025-02-14 14:31:20.083 E           ............-> Bitmap Or
2025-02-14 14:31:20.096 E           ................-> Bitmap
2025-02-14 14:31:20.110 E         + ....................-> Index "TEST_Q_ASC" Range Scan (full match)
2025-02-14 14:31:20.123 E         + ................-> Bitmap
2025-02-14 14:31:20.134 E           ....................-> Index "TEST_P_ASC" Range Scan (full match)
2025-02-14 14:31:20.143 E         - ................-> Bitmap
2025-02-14 14:31:20.158 E         - ....................-> Index "TEST_Q_ASC" Range Scan (full match)
2025-02-14 14:31:20.171 E           select * from test where 5000 in (p, q) and p > 4999 and q < 5001
2025-02-14 14:31:20.180 E           Select Expression
2025-02-14 14:31:20.191 E           ....-> Filter
2025-02-14 14:31:20.199 E           ........-> Table "TEST" Access By ID
2025-02-14 14:31:20.212 E           ............-> Bitmap Or
2025-02-14 14:31:20.221 E           ................-> Bitmap
2025-02-14 14:31:20.229 E         + ....................-> Index "TEST_Q_DEC" Range Scan (full match)
2025-02-14 14:31:20.239 E         + ................-> Bitmap
2025-02-14 14:31:20.247 E           ....................-> Index "TEST_P_DEC" Range Scan (full match)
2025-02-14 14:31:20.258 E         - ................-> Bitmap
2025-02-14 14:31:20.272 E         - ....................-> Index "TEST_Q_DEC" Range Scan (full match)
2025-02-14 14:31:20.285
2025-02-14 14:31:20.298 tests/bugs/gh_8109_test.py:155: AssertionError
2025-02-14 14:31:20.307 ---------------------------- Captured stdout setup -----------------------------
2025-02-14 14:31:20.316 Creating db: localhost:/var/tmp/qa_2024/test_11647/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           ............-> Bitmap Or
E           ................-> Bitmap
E         + ....................-> Index "TEST_Y_ASC" Range Scan (full match)
E         + ................-> Bitmap
E           ....................-> Index "TEST_X_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         + ............-> Bitmap Or
E           ................-> Bitmap
E         - ....................-> Index "TEST_Y_ASC" Range Scan (full match)
E         + ....................-> Index "TEST_V_DEC" Range Scan (full match)
E         + ................-> Bitmap
E         + ....................-> Index "TEST_U_DEC" Range Scan (full match)
E         - select * from test where 5000 in (u, v)
E         + select * from test where 5000 in (x, u)
E           Select Expression
E           ....-> Filter
E           ........-> Table "TEST" Access By ID
E           ............-> Bitmap Or
E           ................-> Bitmap
E           ....................-> Index "TEST_U_DEC" Range Scan (full match)
E           ................-> Bitmap
E         - ....................-> Index "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         - ............-> Bitmap Or
E         - ................-> Bitmap
E           ....................-> Index "TEST_X_ASC" Range Scan (full match)
E         - ................-> Bitmap
E         - ....................-> Index "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           ............-> Bitmap Or
E           ................-> Bitmap
E         + ....................-> Index "TEST_Y_ASC" Range Scan (full match)
E         + ................-> Bitmap
E           ....................-> Index "TEST_V_DEC" Range Scan (full match)
E         - ................-> Bitmap
E         - ....................-> Index "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" Full Scan
E         - ........-> Table "TEST" Access By ID
E         - ............-> Bitmap Or
E         - ................-> Bitmap
E         - ....................-> Index "TEST_C_ASC" Range Scan (full match)
E         - ................-> Bitmap
E         - ....................-> Index "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           ............-> Bitmap Or
E           ................-> Bitmap
E         + ....................-> Index "TEST_Q_ASC" Range Scan (full match)
E         + ................-> Bitmap
E           ....................-> Index "TEST_P_ASC" Range Scan (full match)
E         - ................-> Bitmap
E         - ....................-> Index "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           ............-> Bitmap Or
E           ................-> Bitmap
E         + ....................-> Index "TEST_Q_DEC" Range Scan (full match)
E         + ................-> Bitmap
E           ....................-> Index "TEST_P_DEC" Range Scan (full match)
E         - ................-> Bitmap
E         - ....................-> Index "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 5.0.3.1674 2025.06.27 3ee5c P P 1912 1378 2025.06.29 13:06:42.352 2025.06.29 13:06:44.264 2025.06.29 11:42:06.310 2025.06.29 11:42:07.688
2 5.0.3.1657 2025.06.19 4bd4c P P 1739 1377 2025.06.27 12:19:42.364 2025.06.27 12:19:44.103 2025.06.27 11:00:56.924 2025.06.27 11:00:58.301
3 5.0.3.1657 2025.06.11 dae6f P P 1821 1360 2025.06.17 07:24:44.586 2025.06.17 07:24:46.407 2025.06.17 06:04:48.639 2025.06.17 06:04:49.999
4 5.0.3.1657 2025.06.10 dbc92 P P 1804 1622 2025.06.11 12:15:12.184 2025.06.11 12:15:13.988 2025.06.11 10:46:22.413 2025.06.11 10:46:24.035
5 5.0.3.1656 2025.05.20 c4b11 P P 1923 1533 2025.06.10 12:08:54.409 2025.06.10 12:08:56.332 2025.06.10 10:44:57.697 2025.06.10 10:44:59.230
6 5.0.3.1652 2025.05.13 f51c6 P P 2165 1740 2025.05.20 05:12:55.518 2025.05.20 05:12:57.683 2025.05.20 03:37:08.786 2025.05.20 03:37:10.526
7 5.0.3.1651 2025.04.30 141ef P P 2151 1596 2025.05.13 12:10:55.378 2025.05.13 12:10:57.529 2025.05.13 10:34:06.149 2025.05.13 10:34:07.745
8 5.0.3.1650 2025.04.28 4cbff P P 2289 1586 2025.05.01 11:44:44.567 2025.05.01 11:44:46.856 2025.05.01 10:08:51.081 2025.05.01 10:08:52.667
9 5.0.3.1649 2025.04.21 5b2d0 P P 2031 1603 2025.04.28 05:42:32.633 2025.04.28 05:42:34.664 2025.04.28 04:08:35.959 2025.04.28 04:08:37.562
10 5.0.3.1648 2025.04.18 2f4c5 P P 2169 1645 2025.04.20 05:34:17.734 2025.04.20 05:34:19.903 2025.04.20 04:03:01.121 2025.04.20 04:03:02.766
11 5.0.3.1635 2025.03.31 22ec6 P P 2122 1612 2025.04.18 11:57:21.192 2025.04.18 11:57:23.314 2025.04.18 10:22:05.495 2025.04.18 10:22:07.107
12 5.0.3.1633 2025.03.28 3123a P P 1940 1495 2025.03.31 10:31:24.854 2025.03.31 10:31:26.794 2025.03.31 09:02:22.962 2025.03.31 09:02:24.457
13 5.0.3.1633 2025.03.27 e0fb8 P P 2323 1656 2025.03.28 11:06:38.440 2025.03.28 11:06:40.763 2025.03.28 09:34:33.499 2025.03.28 09:34:35.155
14 5.0.3.1631 2025.03.21 1925b P P 2253 1651 2025.03.27 10:54:21.817 2025.03.27 10:54:24.070 2025.03.27 09:23:27.764 2025.03.27 09:23:29.415
15 5.0.3.1628 2025.03.14 16d05 P P 960 528 2025.03.17 08:27:20.411 2025.03.17 08:27:21.371 2025.03.17 06:47:34.526 2025.03.17 06:47:35.054
16 5.0.3.1627 2025.02.26 4e218 P P 904 519 2025.03.14 11:41:44.102 2025.03.14 11:41:45.006 2025.03.14 10:00:52.370 2025.03.14 10:00:52.889
17 5.0.3.1624 2025.02.25 dc3b2 P P 868 447 2025.02.26 10:32:20.161 2025.02.26 10:32:21.029 2025.02.26 08:56:59.325 2025.02.26 08:56:59.772
18 5.0.2.1615 2025.02.20 4a726 P P 843 479 2025.02.25 10:59:45.150 2025.02.25 10:59:45.993 2025.02.25 09:22:35.856 2025.02.25 09:22:36.335
19 5.0.2.1615 2025.02.14 9cb76 P P 891 525 2025.02.20 07:48:57.850 2025.02.20 07:48:58.741 2025.02.20 06:15:32.426 2025.02.20 06:15:32.951
20 5.0.2.1577 2024.12.24 3c80e F F 951 510 2025.02.14 11:02:48.089 2025.02.14 11:02:49.040 2025.02.14 09:29:08.031 2025.02.14 09:29:08.541

Elapsed time, ms. Chart for last 20 runs:

Last commits information (all timestamps in UTC):