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 09:37:03.826
2025-02-14 09:37:03.827 act = <firebird.qa.plugin.Action object at [hex]>
2025-02-14 09:37:03.827 capsys = <_pytest.capture.CaptureFixture object at [hex]>
2025-02-14 09:37:03.827
2025-02-14 09:37:03.827     @pytest.mark.version('>=5.0.2')
2025-02-14 09:37:03.827     def test_1(act: Action, capsys):
2025-02-14 09:37:03.827         queries_map = { i : x for i,x in enumerate
2025-02-14 09:37:03.827                           (
2025-02-14 09:37:03.827                               [
2025-02-14 09:37:03.827                                    'select * from test where 5000 in (x, y)'
2025-02-14 09:37:03.827                                   ,'select * from test where 5000 in (u, v)'
2025-02-14 09:37:03.827                                   ,'select * from test where 5000 in (x, u)'
2025-02-14 09:37:03.827                                   ,'select * from test where 5000 in (v, y)'
2025-02-14 09:37:03.827                                   ,'select * from test where 5000 in (x+y, u-v)'
2025-02-14 09:37:03.827                                   ,'select * from test where 5000 in (p, q) and p < 5001 and q > 4999'
2025-02-14 09:37:03.827                                   ,'select * from test where 5000 in (p, q) and p > 4999 and q < 5001'
2025-02-14 09:37:03.827                               ]
2025-02-14 09:37:03.827                           )
2025-02-14 09:37:03.827                       }
2025-02-14 09:37:03.827         with act.db.connect() as con:
2025-02-14 09:37:03.828             cur = con.cursor()
2025-02-14 09:37:03.828             for qry_idx, qry_txt in queries_map.items():
2025-02-14 09:37:03.828                 ps = None
2025-02-14 09:37:03.828                 try:
2025-02-14 09:37:03.828                     ps = cur.prepare(qry_txt)
2025-02-14 09:37:03.828
2025-02-14 09:37:03.828                     # Print explained plan with padding eash line by dots in order to see indentations:
2025-02-14 09:37:03.828                     print(qry_txt)
2025-02-14 09:37:03.828                     print( '\n'.join([replace_leading(s) for s in ps.detailed_plan.split('\n')]) )
2025-02-14 09:37:03.828                     print('\n')
2025-02-14 09:37:03.828                 except DatabaseError as e:
2025-02-14 09:37:03.828                     print(e.__str__())
2025-02-14 09:37:03.828                     print(e.gds_codes)
2025-02-14 09:37:03.828                 finally:
2025-02-14 09:37:03.828                     if ps:
2025-02-14 09:37:03.828                         ps.free()
2025-02-14 09:37:03.828
2025-02-14 09:37:03.828
2025-02-14 09:37:03.828         expected_stdout = f"""
2025-02-14 09:37:03.828             {queries_map[ 0 ]}
2025-02-14 09:37:03.829             Select Expression
2025-02-14 09:37:03.829             ....-> Filter
2025-02-14 09:37:03.829             ........-> Table "TEST" Access By ID
2025-02-14 09:37:03.829             ............-> Bitmap Or
2025-02-14 09:37:03.829             ................-> Bitmap
2025-02-14 09:37:03.829             ....................-> Index "TEST_X_ASC" Range Scan (full match)
2025-02-14 09:37:03.829             ................-> Bitmap
2025-02-14 09:37:03.829             ....................-> Index "TEST_Y_ASC" Range Scan (full match)
2025-02-14 09:37:03.829
2025-02-14 09:37:03.829             {queries_map[ 1 ]}
2025-02-14 09:37:03.829             Select Expression
2025-02-14 09:37:03.829             ....-> Filter
2025-02-14 09:37:03.829             ........-> Table "TEST" Access By ID
2025-02-14 09:37:03.829             ............-> Bitmap Or
2025-02-14 09:37:03.829             ................-> Bitmap
2025-02-14 09:37:03.829             ....................-> Index "TEST_U_DEC" Range Scan (full match)
2025-02-14 09:37:03.829             ................-> Bitmap
2025-02-14 09:37:03.830             ....................-> Index "TEST_V_DEC" Range Scan (full match)
2025-02-14 09:37:03.830
2025-02-14 09:37:03.830             {queries_map[ 2 ]}
2025-02-14 09:37:03.830             Select Expression
2025-02-14 09:37:03.830             ....-> Filter
2025-02-14 09:37:03.830             ........-> Table "TEST" Access By ID
2025-02-14 09:37:03.830             ............-> Bitmap Or
2025-02-14 09:37:03.830             ................-> Bitmap
2025-02-14 09:37:03.830             ....................-> Index "TEST_X_ASC" Range Scan (full match)
2025-02-14 09:37:03.830             ................-> Bitmap
2025-02-14 09:37:03.830             ....................-> Index "TEST_U_DEC" Range Scan (full match)
2025-02-14 09:37:03.830
2025-02-14 09:37:03.830             {queries_map[ 3 ]}
2025-02-14 09:37:03.830             Select Expression
2025-02-14 09:37:03.830             ....-> Filter
2025-02-14 09:37:03.830             ........-> Table "TEST" Access By ID
2025-02-14 09:37:03.830             ............-> Bitmap Or
2025-02-14 09:37:03.830             ................-> Bitmap
2025-02-14 09:37:03.830             ....................-> Index "TEST_V_DEC" Range Scan (full match)
2025-02-14 09:37:03.830             ................-> Bitmap
2025-02-14 09:37:03.831             ....................-> Index "TEST_Y_ASC" Range Scan (full match)
2025-02-14 09:37:03.831
2025-02-14 09:37:03.831             {queries_map[ 4 ]}
2025-02-14 09:37:03.831             Select Expression
2025-02-14 09:37:03.831             ....-> Filter
2025-02-14 09:37:03.831             ........-> Table "TEST" Access By ID
2025-02-14 09:37:03.831             ............-> Bitmap Or
2025-02-14 09:37:03.831             ................-> Bitmap
2025-02-14 09:37:03.831             ....................-> Index "TEST_C_ASC" Range Scan (full match)
2025-02-14 09:37:03.831             ................-> Bitmap
2025-02-14 09:37:03.831             ....................-> Index "TEST_C_DEC" Range Scan (full match)
2025-02-14 09:37:03.831
2025-02-14 09:37:03.831             {queries_map[ 5 ]}
2025-02-14 09:37:03.831             Select Expression
2025-02-14 09:37:03.831             ....-> Filter
2025-02-14 09:37:03.831             ........-> Table "TEST" Access By ID
2025-02-14 09:37:03.831             ............-> Bitmap Or
2025-02-14 09:37:03.831             ................-> Bitmap
2025-02-14 09:37:03.831             ....................-> Index "TEST_P_ASC" Range Scan (full match)
2025-02-14 09:37:03.832             ................-> Bitmap
2025-02-14 09:37:03.832             ....................-> Index "TEST_Q_ASC" Range Scan (full match)
2025-02-14 09:37:03.832
2025-02-14 09:37:03.832             {queries_map[ 6 ]}
2025-02-14 09:37:03.832             Select Expression
2025-02-14 09:37:03.832             ....-> Filter
2025-02-14 09:37:03.832             ........-> Table "TEST" Access By ID
2025-02-14 09:37:03.832             ............-> Bitmap Or
2025-02-14 09:37:03.832             ................-> Bitmap
2025-02-14 09:37:03.832             ....................-> Index "TEST_P_DEC" Range Scan (full match)
2025-02-14 09:37:03.832             ................-> Bitmap
2025-02-14 09:37:03.832             ....................-> Index "TEST_Q_DEC" Range Scan (full match)
2025-02-14 09:37:03.832         """
2025-02-14 09:37:03.832
2025-02-14 09:37:03.832         act.expected_stdout = expected_stdout
2025-02-14 09:37:03.832         act.stdout = capsys.readouterr().out
2025-02-14 09:37:03.832 >       assert act.clean_stdout == act.clean_expected_stdout
2025-02-14 09:37:03.832 E       assert
2025-02-14 09:37:03.832 E           select * from test where 5000 in (x, y)
2025-02-14 09:37:03.833 E           Select Expression
2025-02-14 09:37:03.833 E           ....-> Filter
2025-02-14 09:37:03.833 E           ........-> Table "TEST" Access By ID
2025-02-14 09:37:03.833 E           ............-> Bitmap Or
2025-02-14 09:37:03.833 E           ................-> Bitmap
2025-02-14 09:37:03.833 E         + ....................-> Index "TEST_Y_ASC" Range Scan (full match)
2025-02-14 09:37:03.833 E         + ................-> Bitmap
2025-02-14 09:37:03.833 E           ....................-> Index "TEST_X_ASC" Range Scan (full match)
2025-02-14 09:37:03.833 E         + select * from test where 5000 in (u, v)
2025-02-14 09:37:03.833 E         + Select Expression
2025-02-14 09:37:03.833 E         + ....-> Filter
2025-02-14 09:37:03.833 E         + ........-> Table "TEST" Access By ID
2025-02-14 09:37:03.833 E         + ............-> Bitmap Or
2025-02-14 09:37:03.833 E           ................-> Bitmap
2025-02-14 09:37:03.833 E         - ....................-> Index "TEST_Y_ASC" Range Scan (full match)
2025-02-14 09:37:03.833 E         + ....................-> Index "TEST_V_DEC" Range Scan (full match)
2025-02-14 09:37:03.833 E         + ................-> Bitmap
2025-02-14 09:37:03.834 E         + ....................-> Index "TEST_U_DEC" Range Scan (full match)
2025-02-14 09:37:03.834 E         - select * from test where 5000 in (u, v)
2025-02-14 09:37:03.834 E         + select * from test where 5000 in (x, u)
2025-02-14 09:37:03.834 E           Select Expression
2025-02-14 09:37:03.834 E           ....-> Filter
2025-02-14 09:37:03.834 E           ........-> Table "TEST" Access By ID
2025-02-14 09:37:03.834 E           ............-> Bitmap Or
2025-02-14 09:37:03.834 E           ................-> Bitmap
2025-02-14 09:37:03.834 E           ....................-> Index "TEST_U_DEC" Range Scan (full match)
2025-02-14 09:37:03.834 E           ................-> Bitmap
2025-02-14 09:37:03.834 E         - ....................-> Index "TEST_V_DEC" Range Scan (full match)
2025-02-14 09:37:03.834 E         - select * from test where 5000 in (x, u)
2025-02-14 09:37:03.834 E         - Select Expression
2025-02-14 09:37:03.834 E         - ....-> Filter
2025-02-14 09:37:03.834 E         - ........-> Table "TEST" Access By ID
2025-02-14 09:37:03.834 E         - ............-> Bitmap Or
2025-02-14 09:37:03.834 E         - ................-> Bitmap
2025-02-14 09:37:03.834 E           ....................-> Index "TEST_X_ASC" Range Scan (full match)
2025-02-14 09:37:03.835 E         - ................-> Bitmap
2025-02-14 09:37:03.835 E         - ....................-> Index "TEST_U_DEC" Range Scan (full match)
2025-02-14 09:37:03.835 E           select * from test where 5000 in (v, y)
2025-02-14 09:37:03.835 E           Select Expression
2025-02-14 09:37:03.835 E           ....-> Filter
2025-02-14 09:37:03.835 E           ........-> Table "TEST" Access By ID
2025-02-14 09:37:03.835 E           ............-> Bitmap Or
2025-02-14 09:37:03.835 E           ................-> Bitmap
2025-02-14 09:37:03.835 E         + ....................-> Index "TEST_Y_ASC" Range Scan (full match)
2025-02-14 09:37:03.835 E         + ................-> Bitmap
2025-02-14 09:37:03.835 E           ....................-> Index "TEST_V_DEC" Range Scan (full match)
2025-02-14 09:37:03.835 E         - ................-> Bitmap
2025-02-14 09:37:03.835 E         - ....................-> Index "TEST_Y_ASC" Range Scan (full match)
2025-02-14 09:37:03.835 E           select * from test where 5000 in (x+y, u-v)
2025-02-14 09:37:03.835 E           Select Expression
2025-02-14 09:37:03.835 E           ....-> Filter
2025-02-14 09:37:03.835 E         + ........-> Table "TEST" Full Scan
2025-02-14 09:37:03.835 E         - ........-> Table "TEST" Access By ID
2025-02-14 09:37:03.835 E         - ............-> Bitmap Or
2025-02-14 09:37:03.836 E         - ................-> Bitmap
2025-02-14 09:37:03.836 E         - ....................-> Index "TEST_C_ASC" Range Scan (full match)
2025-02-14 09:37:03.836 E         - ................-> Bitmap
2025-02-14 09:37:03.836 E         - ....................-> Index "TEST_C_DEC" Range Scan (full match)
2025-02-14 09:37:03.836 E           select * from test where 5000 in (p, q) and p < 5001 and q > 4999
2025-02-14 09:37:03.836 E           Select Expression
2025-02-14 09:37:03.836 E           ....-> Filter
2025-02-14 09:37:03.836 E           ........-> Table "TEST" Access By ID
2025-02-14 09:37:03.836 E           ............-> Bitmap Or
2025-02-14 09:37:03.836 E           ................-> Bitmap
2025-02-14 09:37:03.836 E         + ....................-> Index "TEST_Q_ASC" Range Scan (full match)
2025-02-14 09:37:03.836 E         + ................-> Bitmap
2025-02-14 09:37:03.836 E           ....................-> Index "TEST_P_ASC" Range Scan (full match)
2025-02-14 09:37:03.836 E         - ................-> Bitmap
2025-02-14 09:37:03.836 E         - ....................-> Index "TEST_Q_ASC" Range Scan (full match)
2025-02-14 09:37:03.836 E           select * from test where 5000 in (p, q) and p > 4999 and q < 5001
2025-02-14 09:37:03.836 E           Select Expression
2025-02-14 09:37:03.836 E           ....-> Filter
2025-02-14 09:37:03.836 E           ........-> Table "TEST" Access By ID
2025-02-14 09:37:03.837 E           ............-> Bitmap Or
2025-02-14 09:37:03.837 E           ................-> Bitmap
2025-02-14 09:37:03.837 E         + ....................-> Index "TEST_Q_DEC" Range Scan (full match)
2025-02-14 09:37:03.837 E         + ................-> Bitmap
2025-02-14 09:37:03.837 E           ....................-> Index "TEST_P_DEC" Range Scan (full match)
2025-02-14 09:37:03.837 E         - ................-> Bitmap
2025-02-14 09:37:03.837 E         - ....................-> Index "TEST_Q_DEC" Range Scan (full match)
2025-02-14 09:37:03.837
2025-02-14 09:37:03.837 tests\bugs\gh_8109_test.py:155: AssertionError
2025-02-14 09:37:03.837 ---------------------------- Captured stdout setup ----------------------------
2025-02-14 09:37:03.837 Creating db: localhost:H:\QA\temp\qa2024.tmp\fbqa\test_11668\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 1437 1088 2025.06.30 11:05:19.188 2025.06.30 11:05:20.625 2025.06.30 10:04:33.315 2025.06.30 10:04:34.403
2 5.0.3.1657 2025.06.26 dcb8a P P 1392 1079 2025.06.27 11:06:41.505 2025.06.27 11:06:42.897 2025.06.27 10:06:07.692 2025.06.27 10:06:08.771
3 5.0.3.1657 2025.06.20 8b4d2 P P 1376 1084 2025.06.26 11:21:09.705 2025.06.26 11:21:11.081 2025.06.26 10:20:25.157 2025.06.26 10:20:26.241
4 5.0.3.1657 2025.06.19 4bd4c P P 1420 1102 2025.06.20 05:25:19.989 2025.06.20 05:25:21.409 2025.06.20 04:24:43.617 2025.06.20 04:24:44.719
5 5.0.3.1657 2025.06.11 dae6f P P 1375 1094 2025.06.19 10:56:51.423 2025.06.19 10:56:52.798 2025.06.19 09:56:07.052 2025.06.19 09:56:08.146
6 5.0.3.1657 2025.06.10 dbc92 P P 1398 1077 2025.06.11 08:43:01.392 2025.06.11 08:43:02.790 2025.06.11 07:42:03.793 2025.06.11 07:42:04.870
7 5.0.3.1656 2025.06.05 00512 P P 1453 1113 2025.06.10 09:58:30.727 2025.06.10 09:58:32.180 2025.06.10 08:57:09.248 2025.06.10 08:57:10.361
8 5.0.3.1656 2025.05.20 c4b11 P P 1374 1083 2025.06.03 09:45:24.155 2025.06.03 09:45:25.529 2025.06.03 08:45:12.965 2025.06.03 08:45:14.048
9 5.0.3.1652 2025.05.13 f51c6 P P 1394 1093 2025.05.21 06:26:24.992 2025.05.21 06:26:26.386 2025.05.21 05:26:29.480 2025.05.21 05:26:30.573
10 5.0.3.1651 2025.05.08 ee9d2 P P 1366 1117 2025.05.13 06:39:02.339 2025.05.13 06:39:03.705 2025.05.13 05:20:35.511 2025.05.13 05:20:36.628
11 5.0.3.1651 2025.05.04 3d914 P P 1371 1118 2025.05.09 04:28:06.302 2025.05.09 04:28:07.673 2025.05.09 03:09:33.681 2025.05.09 03:09:34.799
12 5.0.3.1651 2025.04.30 141ef P P 1397 1088 2025.05.02 04:35:44.141 2025.05.02 04:35:45.538 2025.05.02 03:17:26.871 2025.05.02 03:17:27.959
13 5.0.3.1650 2025.04.30 6253f P P 1374 1112 2025.05.01 04:34:46.138 2025.05.01 04:34:47.512 2025.05.01 03:16:22.658 2025.05.01 03:16:23.770
14 5.0.3.1650 2025.04.28 4cbff P P 1361 1079 2025.04.30 04:33:47.762 2025.04.30 04:33:49.123 2025.04.30 03:15:37.422 2025.04.30 03:15:38.501
15 5.0.3.1649 2025.04.21 5b2d0 P P 1392 1102 2025.04.26 10:07:41.751 2025.04.26 10:07:43.143 2025.04.26 08:48:36.048 2025.04.26 08:48:37.150
16 5.0.3.1648 2025.04.18 2f4c5 P P 1376 1172 2025.04.20 04:18:56.536 2025.04.20 04:18:57.912 2025.04.20 03:17:59.182 2025.04.20 03:18:00.354
17 5.0.3.1635 2025.04.03 f6bd1 P P 1361 1066 2025.04.18 06:46:37.275 2025.04.18 06:46:38.636 2025.04.18 05:27:16.977 2025.04.18 05:27:18.043
18 5.0.3.1635 2025.03.31 22ec6 P P 1377 1101 2025.04.03 09:52:30.380 2025.04.03 09:52:31.757 2025.04.03 08:32:48.211 2025.04.03 08:32:49.312
19 5.0.3.1633 2025.03.28 3123a P P 1388 1133 2025.03.31 09:50:59.458 2025.03.31 09:51:00.846 2025.03.31 08:31:21.515 2025.03.31 08:31:22.648
20 5.0.3.1633 2025.03.27 e0fb8 P P 1429 1152 2025.03.28 10:22:31.521 2025.03.28 10:22:32.950 2025.03.28 08:59:05.619 2025.03.28 08:59:06.771
21 5.0.3.1631 2025.03.25 bda65 P P 1454 1154 2025.03.27 10:03:01.797 2025.03.27 10:03:03.251 2025.03.27 08:58:18.863 2025.03.27 08:58:20.017
22 5.0.3.1631 2025.03.21 1925b P P 1413 1126 2025.03.25 06:37:04.078 2025.03.25 06:37:05.491 2025.03.25 05:32:16.050 2025.03.25 05:32:17.176
23 5.0.3.1629 2025.03.18 506d7 P P 1441 1081 2025.03.20 09:37:26.097 2025.03.20 09:37:27.538 2025.03.20 08:32:25.683 2025.03.20 08:32:26.764
24 5.0.3.1628 2025.03.14 16d05 P P 1377 1078 2025.03.18 09:31:34.638 2025.03.18 09:31:36.015 2025.03.18 08:28:08.094 2025.03.18 08:28:09.172
25 5.0.3.1627 2025.02.26 4e218 P P 1418 1098 2025.03.13 09:50:48.367 2025.03.13 09:50:49.785 2025.03.13 08:45:38.480 2025.03.13 08:45:39.578
26 5.0.3.1624 2025.02.25 dc3b2 P P 1427 1130 2025.02.26 15:23:03.536 2025.02.26 15:23:04.963 2025.02.26 14:18:36.181 2025.02.26 14:18:37.311
27 5.0.2.1615 2025.02.20 4a726 P P 1378 1090 2025.02.25 08:37:42.926 2025.02.25 08:37:44.304 2025.02.25 07:16:22.244 2025.02.25 07:16:23.334
28 5.0.2.1615 2025.02.14 9cb76 P P 1375 1099 2025.02.15 04:05:21.294 2025.02.15 04:05:22.669 2025.02.15 03:02:38.014 2025.02.15 03:02:39.113
29 5.0.2.1577 2025.02.07 f50a2 F F 1390 1111 2025.02.14 06:18:01.589 2025.02.14 06:18:02.979 2025.02.14 05:16:29.331 2025.02.14 05:16:30.442
30 5.0.2.1577 2024.12.24 3c80e F F 1386 1120 2025.02.06 09:31:32.692 2025.02.06 09:31:34.078 2025.02.06 08:30:03.144 2025.02.06 08:30:04.264

Elapsed time, ms. Chart for last 30 runs:

Last commits information (all timestamps in UTC):