Show firebird.log [FOUND messages 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   
    1000
    select txt_short from test a01 order by id
    Must NOT use refetch because length of non-key column is less than threshold
    Select Expression
    ....-> Sort (record length: 1036, key length: 8)
  - ........-> Table "TEST" as "A01" Full Scan
  + ........-> Table "PUBLIC"."TEST" as "A01" Full Scan
    1010
    select txt_broad from test a02 order by id
    MUST use refetch because length of non-key column is greater than threshold
    Select Expression
    ....-> Refetch
    ........-> Sort (record length: 28, key length: 8)
  - ............-> Table "TEST" as "A02" Full Scan
  + ............-> Table "PUBLIC"."TEST" as "A02" Full Scan
    1020
    select txt_short from test a03 order by id rows 1
    MUST use refetch regardless on length of column because ROWS <N> presents
    Select Expression
    ....-> First N Records
    ........-> Refetch
    ............-> Sort (record length: 28, key length: 8)
  - ................-> Table "TEST" as "A03" Full Scan
  + ................-> Table "PUBLIC"."TEST" as "A03" Full Scan
    2000
    select id, computed_ts_dup from test order by id
    Must NOT use refetch because computed column is based on txt_short with length < threshold
    Select Expression
    ....-> Sort (record length: 1036, key length: 8)
  - ........-> Table "TEST" Full Scan
  + ........-> Table "PUBLIC"."TEST" Full Scan
    2010
    select id, computed_tb_dup from test order by id
    MUST use refetch because computed column is based on txt_broad which has length >= threshold
    Select Expression
    ....-> Refetch
    ........-> Sort (record length: 28, key length: 8)
  - ............-> Table "TEST" Full Scan
  + ............-> Table "PUBLIC"."TEST" Full Scan
    3000
    select id from test a04 where '' in (select txt_short from test x04 where txt_short = '' order by id)
    *** not [yet] commented ***
    Sub-query (invariant)
    ....-> Filter
    ........-> Sort (record length: 1036, key length: 8)
    ............-> Filter
  - ................-> Table "TEST" as "X04" Full Scan
  + ................-> Table "PUBLIC"."TEST" as "X04" Full Scan
    Select Expression
    ....-> Filter (preliminary)
  - ........-> Table "TEST" as "A04" Full Scan
  + ........-> Table "PUBLIC"."TEST" as "A04" Full Scan
    3010
    select id from test a05 where '' in (select txt_broad from test x05 where txt_broad = '' order by id)
    *** not [yet] commented ***
    Sub-query (invariant)
    ....-> Filter
    ........-> Refetch
    ............-> Sort (record length: 28, key length: 8)
    ................-> Filter
  - ....................-> Table "TEST" as "X05" Full Scan
  + ....................-> Table "PUBLIC"."TEST" as "X05" Full Scan
    Select Expression
    ....-> Filter (preliminary)
  - ........-> Table "TEST" as "A05" Full Scan
  + ........-> Table "PUBLIC"."TEST" as "A05" Full Scan
    3020
    select id from test a06 where '' not in (select txt_short from test x06 where txt_short>'' order by id)
    *** not [yet] commented ***
    Sub-query (invariant)
    ....-> Sort (record length: 1036, key length: 8)
    ........-> Filter
  - ............-> Table "TEST" as "X06" Full Scan
  + ............-> Table "PUBLIC"."TEST" as "X06" Full Scan
    Sub-query (invariant)
    ....-> Sort (record length: 1036, key length: 8)
    ........-> Filter
  - ............-> Table "TEST" as "X06" Full Scan
  + ............-> Table "PUBLIC"."TEST" as "X06" Full Scan
    Select Expression
    ....-> Filter (preliminary)
  - ........-> Table "TEST" as "A06" Full Scan
  + ........-> Table "PUBLIC"."TEST" as "A06" Full Scan
    3030
    select id from test a07 where '' not in (select txt_broad from test x07 where txt_broad>'' order by id)
    *** not [yet] commented ***
    Sub-query (invariant)
    ....-> Refetch
    ........-> Sort (record length: 28, key length: 8)
    ............-> Filter
  - ................-> Table "TEST" as "X07" Full Scan
  + ................-> Table "PUBLIC"."TEST" as "X07" Full Scan
    Sub-query (invariant)
    ....-> Refetch
    ........-> Sort (record length: 28, key length: 8)
    ............-> Filter
  - ................-> Table "TEST" as "X07" Full Scan
  + ................-> Table "PUBLIC"."TEST" as "X07" Full Scan
    Select Expression
    ....-> Filter (preliminary)
  - ........-> Table "TEST" as "A07" Full Scan
  + ........-> Table "PUBLIC"."TEST" as "A07" Full Scan
    3040
    select id from test a08 where '' > all (select id from test x08 where txt_short>'' order by id)
    *** not [yet] commented ***
    Sub-query (invariant)
    ....-> Filter
    ........-> Sort (record length: 1036, key length: 8)
    ............-> Filter
  - ................-> Table "TEST" as "X08" Full Scan
  + ................-> Table "PUBLIC"."TEST" as "X08" Full Scan
    Select Expression
    ....-> Filter (preliminary)
  - ........-> Table "TEST" as "A08" Full Scan
  + ........-> Table "PUBLIC"."TEST" as "A08" Full Scan
    3050
    select id from test a09 where '' > all (select id from test x09 where txt_broad>'' order by id)
    *** not [yet] commented ***
    Sub-query (invariant)
    ....-> Filter
    ........-> Refetch
    ............-> Sort (record length: 28, key length: 8)
    ................-> Filter
  - ....................-> Table "TEST" as "X09" Full Scan
  + ....................-> Table "PUBLIC"."TEST" as "X09" Full Scan
    Select Expression
    ....-> Filter (preliminary)
  - ........-> Table "TEST" as "A09" Full Scan
  + ........-> Table "PUBLIC"."TEST" as "A09" Full Scan
    3060
    select id from test a10 where '' <> any (select id from test x10 where txt_short>'' order by id)
    *** not [yet] commented ***
    Sub-query (invariant)
    ....-> Filter
    ........-> Sort (record length: 1036, key length: 8)
    ............-> Filter
  - ................-> Table "TEST" as "X10" Full Scan
  + ................-> Table "PUBLIC"."TEST" as "X10" Full Scan
    Select Expression
    ....-> Filter (preliminary)
  - ........-> Table "TEST" as "A10" Full Scan
  + ........-> Table "PUBLIC"."TEST" as "A10" Full Scan
    3070
    select id from test a11 where '' <> any (select id from test x11 where txt_broad>'' order by id)
    *** not [yet] commented ***
    Sub-query (invariant)
    ....-> Filter
    ........-> Refetch
    ............-> Sort (record length: 28, key length: 8)
    ................-> Filter
  - ....................-> Table "TEST" as "X11" Full Scan
  + ....................-> Table "PUBLIC"."TEST" as "X11" Full Scan
    Select Expression
    ....-> Filter (preliminary)
  - ........-> Table "TEST" as "A11" Full Scan
  + ........-> Table "PUBLIC"."TEST" as "A11" Full Scan
    4000
    select id,txt_short from test a12 where exists(select 1 from test x12 where txt_short>'' order by id)
    MUST use refetch: column x12.txt_short not present in order by
    Sub-query (invariant)
    ....-> Refetch
    ........-> Sort (record length: 28, key length: 8)
    ............-> Filter
  - ................-> Table "TEST" as "X12" Full Scan
  + ................-> Table "PUBLIC"."TEST" as "X12" Full Scan
    Select Expression
    ....-> Filter (preliminary)
  - ........-> Table "TEST" as "A12" Full Scan
  + ........-> Table "PUBLIC"."TEST" as "A12" Full Scan
    4010
    select id,txt_short from test a13 where exists(select 1 from test x13 where computed_id_dup > 0  order by id)
    Must NOT use refetch: ORDER BY list contains the single element: ID, and it is base for x13.computed_id_dup column
    Sub-query (invariant)
    ....-> Sort (record length: 28, key length: 8)
    ........-> Filter
  - ............-> Table "TEST" as "X13" Full Scan
  + ............-> Table "PUBLIC"."TEST" as "X13" Full Scan
    Select Expression
    ....-> Filter (preliminary)
  - ........-> Table "TEST" as "A13" Full Scan
  + ........-> Table "PUBLIC"."TEST" as "A13" Full Scan
    4020
    select id,txt_short from test a14 where exists(select 1 from test x14 where computed_id_dup > 0  order by computed_id_dup)
    MUST use refetch! See letter from dimitr 28.12.2020 14:49
    Sort procedure will get:
    a KEY = result of evaluating 'computed_id_dup';
    a VAL = value of the field 'ID' which is base for computing 'computed_id_dup'
    Thus sorter will have a field which not equals to a key, which leads to refetch.
    Sub-query (invariant)
    ....-> Refetch
    ........-> Sort (record length: 36, key length: 12)
    ............-> Filter
  - ................-> Table "TEST" as "X14" Full Scan
  + ................-> Table "PUBLIC"."TEST" as "X14" Full Scan
    Select Expression
    ....-> Filter (preliminary)
  - ........-> Table "TEST" as "A14" Full Scan
  + ........-> Table "PUBLIC"."TEST" as "A14" Full Scan
    4030
    select id,txt_short from test a15 where exists(select 1 from test x15 where f02>0 and f01>0 order by f01, f02)
    Must NOT use refetch: all persistent columns from WHERE expression (f01, f02) belong to ORDER BY list
    Sub-query (invariant)
    ....-> Sort (record length: 36, key length: 16)
    ........-> Filter
  - ............-> Table "TEST" as "X15" Full Scan
  + ............-> Table "PUBLIC"."TEST" as "X15" Full Scan
    Select Expression
    ....-> Filter (preliminary)
  - ........-> Table "TEST" as "A15" Full Scan
  + ........-> Table "PUBLIC"."TEST" as "A15" Full Scan
    4040
    select id,txt_short from test a16 where exists(select 1 from test x16 where id>0 and f01>0 order by f01, f02)
    Must use refetch: one of columns from WHERE expr (id) does not belong to ORDER BY list
    Sub-query (invariant)
    ....-> Refetch
    ........-> Sort (record length: 36, key length: 16)
    ............-> Filter
  - ................-> Table "TEST" as "X16" Full Scan
  + ................-> Table "PUBLIC"."TEST" as "X16" Full Scan
    Select Expression
    ....-> Filter (preliminary)
  - ........-> Table "TEST" as "A16" Full Scan
  + ........-> Table "PUBLIC"."TEST" as "A16" Full Scan
    4050
    select id,txt_short from test a17 where exists(select 1 from test x17 where computed_id_dup > 0 order by f01)
    Must use refetch: computed column in WHERE expr does not belong to ORDER BY list
    Sub-query (invariant)
    ....-> Refetch
    ........-> Sort (record length: 28, key length: 8)
    ............-> Filter
  - ................-> Table "TEST" as "X17" Full Scan
  + ................-> Table "PUBLIC"."TEST" as "X17" Full Scan
    Select Expression
    ....-> Filter (preliminary)
  - ........-> Table "TEST" as "A17" Full Scan
  + ........-> Table "PUBLIC"."TEST" as "A17" Full Scan
    4060
    select id,txt_short from test a18 where exists(select 1 from test x18 where computed_guid > '' order by f01)
    Must NOT use refetch: computed column x18.computed_guid does is evaluated via GUID and does not refer to any columns
    Sub-query (invariant)
    ....-> Sort (record length: 28, key length: 8)
    ........-> Filter
  - ............-> Table "TEST" as "X18" Full Scan
  + ............-> Table "PUBLIC"."TEST" as "X18" Full Scan
    Select Expression
    ....-> Filter (preliminary)
  - ........-> Table "TEST" as "A18" Full Scan
  + ........-> Table "PUBLIC"."TEST" as "A18" Full Scan
    4070
    with recursive
    r as (
    select a19.id, a19.txt_short
    from test a19
    where not exists(select * from test x where x.txt_short < a19.txt_short order by id)
    UNION ALL
    select i.id, i.txt_short
    from test i
    join r on i.id > r.id
    and not exists( select * from test x where x.txt_short between r.txt_short and i.txt_short order by id )
    )
    select * from r
    MUST use refetch both in anchor and recursive parts
    Sub-query
    ....-> Refetch
    ........-> Sort (record length: 28, key length: 8)
    ............-> Filter
  - ................-> Table "TEST" as "R X" Full Scan
  + ................-> Table "PUBLIC"."TEST" as "R" "X" Full Scan
    Sub-query
    ....-> Refetch
    ........-> Sort (record length: 28, key length: 8)
    ............-> Filter
  - ................-> Table "TEST" as "R X" Full Scan
  + ................-> Table "PUBLIC"."TEST" as "R" "X" Full Scan
    Select Expression
    ....-> Recursion
    ........-> Filter
  - ............-> Table "TEST" as "R A19" Full Scan
  + ............-> Table "PUBLIC"."TEST" as "R" "A19" Full Scan
    ........-> Filter
  - ............-> Table "TEST" as "R I" Full Scan
  + ............-> Table "PUBLIC"."TEST" as "R" "I" Full Scan
    5000
    select txt_broad from v_unioned v01 order by id
    Must NOT use refetch because view DDL includes UNION
    Select Expression
    ....-> Sort (record length: 4044, key length: 8)
    ........-> First N Records
    ............-> Union
  - ................-> Table "TEST" as "V01 TEST" Full Scan
  + ................-> Table "PUBLIC"."TEST" as "V01" "PUBLIC"."TEST" Full Scan
  - ................-> Table "RDB$DATABASE" as "V01 RDB$DATABASE" Full Scan
  + ................-> Table "SYSTEM"."RDB$DATABASE" as "V01" "SYSTEM"."RDB$DATABASE" Full Scan
    6000
    select left(txt_broad, 50) as txt from test a21 order by id
    MUST use refetch because expression is based on column which has length >= threshold
    (even if final length of expression result is much less than threshold)
    Select Expression
    ....-> Refetch
    ........-> Sort (record length: 28, key length: 8)
  - ............-> Table "TEST" as "A21" Full Scan
  + ............-> Table "PUBLIC"."TEST" as "A21" Full Scan
    6010
    select left( txt_short || txt_short, 2000) as txt from test a22 order by id
    Must NOT use refetch because expression is based on column which has length < threshold
    (even if final length of expression result is much bigger than threshold)
    Select Expression
    ....-> Sort (record length: 1036, key length: 8)
  - ........-> Table "TEST" as "A22" Full Scan
  + ........-> Table "PUBLIC"."TEST" as "A22" Full Scan
    7000
    select * from test_ns_01 a23 order by id
    MUST use refetch
    Select Expression
    ....-> Refetch
    ........-> Sort (record length: 44, key length: 24)
  - ............-> Table "TEST_NS_01" as "A23" Full Scan
  + ............-> Table "PUBLIC"."TEST_NS_01" as "A23" Full Scan
    7010
    select * from test_ns_02 a24 order by id
    Must NOT refetch
    Select Expression
    ....-> Sort (record length: 1052, key length: 24)
  - ........-> Table "TEST_NS_02" as "A24" Full Scan
  + ........-> Table "PUBLIC"."TEST_NS_02" as "A24" Full Scan
    7020
    select * from test_ns_03 order by id
    MUST use refetch
    Select Expression
    ....-> Refetch
    ........-> Sort (record length: 36, key length: 12)
  - ............-> Table "TEST_NS_03" Full Scan
  + ............-> Table "PUBLIC"."TEST_NS_03" Full Scan
    7030
    select * from test_ns_04 order by id
    Must NOT use refetch
    Select Expression
    ....-> Sort (record length: 1036, key length: 12)
  - ........-> Table "TEST_NS_04" Full Scan
  + ........-> Table "PUBLIC"."TEST_NS_04" Full Scan
    7040
    select * from test_ns_05 order by id
    MUST use refetch
    Select Expression
    ....-> Refetch
    ........-> Sort (record length: 36, key length: 12)
  - ............-> Table "TEST_NS_05" Full Scan
  + ............-> Table "PUBLIC"."TEST_NS_05" Full Scan
    7050
    select * from test_ns_06 order by id
    Must NOT use refetch
    Select Expression
    ....-> Sort (record length: 1036, key length: 12)
  - ........-> Table "TEST_NS_06" Full Scan
  + ........-> Table "PUBLIC"."TEST_NS_06" Full Scan

LOG DETAILS:

2025-06-26 06:42:27.506
2025-06-26 06:42:27.506 act = <firebird.qa.plugin.Action object at [hex]>
2025-06-26 06:42:27.506 capsys = <_pytest.capture.CaptureFixture object at [hex]>
2025-06-26 06:42:27.506
2025-06-26 06:42:27.506     @pytest.mark.version('>=4.0')
2025-06-26 06:42:27.506     def test_1(act: Action, capsys):
2025-06-26 06:42:27.506         with act.db.connect() as con:
2025-06-26 06:42:27.506
2025-06-26 06:42:27.506             # 13.01.2025: test will FAIL if config parameter OptimizeForFirstRows differs from default value (i.e. is set to true).
2025-06-26 06:42:27.506             # To prevent this, we have to explicitly change appropriate session-level value:
2025-06-26 06:42:27.506             if act.is_version('<5'):
2025-06-26 06:42:27.506                 pass
2025-06-26 06:42:27.507             else:
2025-06-26 06:42:27.507                 con.execute_immediate('set optimize for all rows')
2025-06-26 06:42:27.507
2025-06-26 06:42:27.507             cur = con.cursor()
2025-06-26 06:42:27.507             for q_idx, q_tuple in query_map.items():
2025-06-26 06:42:27.507                 test_sql, qry_comment = q_tuple[:2]
2025-06-26 06:42:27.507                 ps = cur.prepare(test_sql)
2025-06-26 06:42:27.507                 print(q_idx)
2025-06-26 06:42:27.507                 print(test_sql)
2025-06-26 06:42:27.507                 print(qry_comment)
2025-06-26 06:42:27.507                 print( '\n'.join([replace_leading(s) for s in ps.detailed_plan.split('\n')]) )
2025-06-26 06:42:27.507                 ps.free()
2025-06-26 06:42:27.507
2025-06-26 06:42:27.507         act.expected_stdout = fb4x_expected_out if act.is_version('<5') else fb5x_expected_out if act.is_version('<6') else fb6x_expected_out
2025-06-26 06:42:27.507         act.stdout = capsys.readouterr().out
2025-06-26 06:42:27.507 >       assert act.clean_stdout == act.clean_expected_stdout
2025-06-26 06:42:27.507 E       assert
2025-06-26 06:42:27.507 E           1000
2025-06-26 06:42:27.507 E           select txt_short from test a01 order by id
2025-06-26 06:42:27.508 E           Must NOT use refetch because length of non-key column is less than threshold
2025-06-26 06:42:27.508 E           Select Expression
2025-06-26 06:42:27.508 E           ....-> Sort (record length: 1036, key length: 8)
2025-06-26 06:42:27.508 E         - ........-> Table "TEST" as "A01" Full Scan
2025-06-26 06:42:27.508 E         + ........-> Table "PUBLIC"."TEST" as "A01" Full Scan
2025-06-26 06:42:27.508 E           1010
2025-06-26 06:42:27.508 E           select txt_broad from test a02 order by id
2025-06-26 06:42:27.508 E           MUST use refetch because length of non-key column is greater than threshold
2025-06-26 06:42:27.508 E           Select Expression
2025-06-26 06:42:27.508 E           ....-> Refetch
2025-06-26 06:42:27.508 E           ........-> Sort (record length: 28, key length: 8)
2025-06-26 06:42:27.508 E         - ............-> Table "TEST" as "A02" Full Scan
2025-06-26 06:42:27.508 E         + ............-> Table "PUBLIC"."TEST" as "A02" Full Scan
2025-06-26 06:42:27.508 E           1020
2025-06-26 06:42:27.508 E           select txt_short from test a03 order by id rows 1
2025-06-26 06:42:27.508 E           MUST use refetch regardless on length of column because ROWS <N> presents
2025-06-26 06:42:27.508 E           Select Expression
2025-06-26 06:42:27.509 E           ....-> First N Records
2025-06-26 06:42:27.509 E           ........-> Refetch
2025-06-26 06:42:27.509 E           ............-> Sort (record length: 28, key length: 8)
2025-06-26 06:42:27.509 E         - ................-> Table "TEST" as "A03" Full Scan
2025-06-26 06:42:27.509 E         + ................-> Table "PUBLIC"."TEST" as "A03" Full Scan
2025-06-26 06:42:27.509 E           2000
2025-06-26 06:42:27.509 E           select id, computed_ts_dup from test order by id
2025-06-26 06:42:27.509 E           Must NOT use refetch because computed column is based on txt_short with length < threshold
2025-06-26 06:42:27.509 E           Select Expression
2025-06-26 06:42:27.509 E           ....-> Sort (record length: 1036, key length: 8)
2025-06-26 06:42:27.509 E         - ........-> Table "TEST" Full Scan
2025-06-26 06:42:27.509 E         + ........-> Table "PUBLIC"."TEST" Full Scan
2025-06-26 06:42:27.509 E           2010
2025-06-26 06:42:27.509 E           select id, computed_tb_dup from test order by id
2025-06-26 06:42:27.509 E           MUST use refetch because computed column is based on txt_broad which has length >= threshold
2025-06-26 06:42:27.509 E           Select Expression
2025-06-26 06:42:27.509 E           ....-> Refetch
2025-06-26 06:42:27.510 E           ........-> Sort (record length: 28, key length: 8)
2025-06-26 06:42:27.510 E         - ............-> Table "TEST" Full Scan
2025-06-26 06:42:27.510 E         + ............-> Table "PUBLIC"."TEST" Full Scan
2025-06-26 06:42:27.510 E           3000
2025-06-26 06:42:27.510 E           select id from test a04 where '' in (select txt_short from test x04 where txt_short = '' order by id)
2025-06-26 06:42:27.510 E           *** not [yet] commented ***
2025-06-26 06:42:27.510 E           Sub-query (invariant)
2025-06-26 06:42:27.510 E           ....-> Filter
2025-06-26 06:42:27.510 E           ........-> Sort (record length: 1036, key length: 8)
2025-06-26 06:42:27.510 E           ............-> Filter
2025-06-26 06:42:27.510 E         - ................-> Table "TEST" as "X04" Full Scan
2025-06-26 06:42:27.510 E         + ................-> Table "PUBLIC"."TEST" as "X04" Full Scan
2025-06-26 06:42:27.510 E           Select Expression
2025-06-26 06:42:27.510 E           ....-> Filter (preliminary)
2025-06-26 06:42:27.510 E         - ........-> Table "TEST" as "A04" Full Scan
2025-06-26 06:42:27.510 E         + ........-> Table "PUBLIC"."TEST" as "A04" Full Scan
2025-06-26 06:42:27.511 E           3010
2025-06-26 06:42:27.511 E           select id from test a05 where '' in (select txt_broad from test x05 where txt_broad = '' order by id)
2025-06-26 06:42:27.511 E           *** not [yet] commented ***
2025-06-26 06:42:27.511 E           Sub-query (invariant)
2025-06-26 06:42:27.511 E           ....-> Filter
2025-06-26 06:42:27.511 E           ........-> Refetch
2025-06-26 06:42:27.511 E           ............-> Sort (record length: 28, key length: 8)
2025-06-26 06:42:27.511 E           ................-> Filter
2025-06-26 06:42:27.511 E         - ....................-> Table "TEST" as "X05" Full Scan
2025-06-26 06:42:27.511 E         + ....................-> Table "PUBLIC"."TEST" as "X05" Full Scan
2025-06-26 06:42:27.511 E           Select Expression
2025-06-26 06:42:27.511 E           ....-> Filter (preliminary)
2025-06-26 06:42:27.511 E         - ........-> Table "TEST" as "A05" Full Scan
2025-06-26 06:42:27.511 E         + ........-> Table "PUBLIC"."TEST" as "A05" Full Scan
2025-06-26 06:42:27.511 E           3020
2025-06-26 06:42:27.511 E           select id from test a06 where '' not in (select txt_short from test x06 where txt_short>'' order by id)
2025-06-26 06:42:27.512 E           *** not [yet] commented ***
2025-06-26 06:42:27.512 E           Sub-query (invariant)
2025-06-26 06:42:27.512 E           ....-> Sort (record length: 1036, key length: 8)
2025-06-26 06:42:27.512 E           ........-> Filter
2025-06-26 06:42:27.512 E         - ............-> Table "TEST" as "X06" Full Scan
2025-06-26 06:42:27.512 E         + ............-> Table "PUBLIC"."TEST" as "X06" Full Scan
2025-06-26 06:42:27.512 E           Sub-query (invariant)
2025-06-26 06:42:27.512 E           ....-> Sort (record length: 1036, key length: 8)
2025-06-26 06:42:27.512 E           ........-> Filter
2025-06-26 06:42:27.512 E         - ............-> Table "TEST" as "X06" Full Scan
2025-06-26 06:42:27.512 E         + ............-> Table "PUBLIC"."TEST" as "X06" Full Scan
2025-06-26 06:42:27.512 E           Select Expression
2025-06-26 06:42:27.512 E           ....-> Filter (preliminary)
2025-06-26 06:42:27.512 E         - ........-> Table "TEST" as "A06" Full Scan
2025-06-26 06:42:27.512 E         + ........-> Table "PUBLIC"."TEST" as "A06" Full Scan
2025-06-26 06:42:27.512 E           3030
2025-06-26 06:42:27.512 E           select id from test a07 where '' not in (select txt_broad from test x07 where txt_broad>'' order by id)
2025-06-26 06:42:27.513 E           *** not [yet] commented ***
2025-06-26 06:42:27.513 E           Sub-query (invariant)
2025-06-26 06:42:27.513 E           ....-> Refetch
2025-06-26 06:42:27.513 E           ........-> Sort (record length: 28, key length: 8)
2025-06-26 06:42:27.513 E           ............-> Filter
2025-06-26 06:42:27.513 E         - ................-> Table "TEST" as "X07" Full Scan
2025-06-26 06:42:27.513 E         + ................-> Table "PUBLIC"."TEST" as "X07" Full Scan
2025-06-26 06:42:27.513 E           Sub-query (invariant)
2025-06-26 06:42:27.513 E           ....-> Refetch
2025-06-26 06:42:27.513 E           ........-> Sort (record length: 28, key length: 8)
2025-06-26 06:42:27.513 E           ............-> Filter
2025-06-26 06:42:27.513 E         - ................-> Table "TEST" as "X07" Full Scan
2025-06-26 06:42:27.513 E         + ................-> Table "PUBLIC"."TEST" as "X07" Full Scan
2025-06-26 06:42:27.513 E           Select Expression
2025-06-26 06:42:27.513 E           ....-> Filter (preliminary)
2025-06-26 06:42:27.513 E         - ........-> Table "TEST" as "A07" Full Scan
2025-06-26 06:42:27.513 E         + ........-> Table "PUBLIC"."TEST" as "A07" Full Scan
2025-06-26 06:42:27.514 E           3040
2025-06-26 06:42:27.514 E           select id from test a08 where '' > all (select id from test x08 where txt_short>'' order by id)
2025-06-26 06:42:27.514 E           *** not [yet] commented ***
2025-06-26 06:42:27.514 E           Sub-query (invariant)
2025-06-26 06:42:27.514 E           ....-> Filter
2025-06-26 06:42:27.514 E           ........-> Sort (record length: 1036, key length: 8)
2025-06-26 06:42:27.514 E           ............-> Filter
2025-06-26 06:42:27.514 E         - ................-> Table "TEST" as "X08" Full Scan
2025-06-26 06:42:27.514 E         + ................-> Table "PUBLIC"."TEST" as "X08" Full Scan
2025-06-26 06:42:27.514 E           Select Expression
2025-06-26 06:42:27.514 E           ....-> Filter (preliminary)
2025-06-26 06:42:27.514 E         - ........-> Table "TEST" as "A08" Full Scan
2025-06-26 06:42:27.514 E         + ........-> Table "PUBLIC"."TEST" as "A08" Full Scan
2025-06-26 06:42:27.514 E           3050
2025-06-26 06:42:27.514 E           select id from test a09 where '' > all (select id from test x09 where txt_broad>'' order by id)
2025-06-26 06:42:27.514 E           *** not [yet] commented ***
2025-06-26 06:42:27.515 E           Sub-query (invariant)
2025-06-26 06:42:27.515 E           ....-> Filter
2025-06-26 06:42:27.515 E           ........-> Refetch
2025-06-26 06:42:27.515 E           ............-> Sort (record length: 28, key length: 8)
2025-06-26 06:42:27.515 E           ................-> Filter
2025-06-26 06:42:27.515 E         - ....................-> Table "TEST" as "X09" Full Scan
2025-06-26 06:42:27.515 E         + ....................-> Table "PUBLIC"."TEST" as "X09" Full Scan
2025-06-26 06:42:27.515 E           Select Expression
2025-06-26 06:42:27.515 E           ....-> Filter (preliminary)
2025-06-26 06:42:27.515 E         - ........-> Table "TEST" as "A09" Full Scan
2025-06-26 06:42:27.515 E         + ........-> Table "PUBLIC"."TEST" as "A09" Full Scan
2025-06-26 06:42:27.515 E           3060
2025-06-26 06:42:27.515 E           select id from test a10 where '' <> any (select id from test x10 where txt_short>'' order by id)
2025-06-26 06:42:27.515 E           *** not [yet] commented ***
2025-06-26 06:42:27.515 E           Sub-query (invariant)
2025-06-26 06:42:27.515 E           ....-> Filter
2025-06-26 06:42:27.515 E           ........-> Sort (record length: 1036, key length: 8)
2025-06-26 06:42:27.516 E           ............-> Filter
2025-06-26 06:42:27.516 E         - ................-> Table "TEST" as "X10" Full Scan
2025-06-26 06:42:27.516 E         + ................-> Table "PUBLIC"."TEST" as "X10" Full Scan
2025-06-26 06:42:27.516 E           Select Expression
2025-06-26 06:42:27.516 E           ....-> Filter (preliminary)
2025-06-26 06:42:27.516 E         - ........-> Table "TEST" as "A10" Full Scan
2025-06-26 06:42:27.516 E         + ........-> Table "PUBLIC"."TEST" as "A10" Full Scan
2025-06-26 06:42:27.516 E           3070
2025-06-26 06:42:27.516 E           select id from test a11 where '' <> any (select id from test x11 where txt_broad>'' order by id)
2025-06-26 06:42:27.516 E           *** not [yet] commented ***
2025-06-26 06:42:27.516 E           Sub-query (invariant)
2025-06-26 06:42:27.516 E           ....-> Filter
2025-06-26 06:42:27.516 E           ........-> Refetch
2025-06-26 06:42:27.516 E           ............-> Sort (record length: 28, key length: 8)
2025-06-26 06:42:27.516 E           ................-> Filter
2025-06-26 06:42:27.516 E         - ....................-> Table "TEST" as "X11" Full Scan
2025-06-26 06:42:27.516 E         + ....................-> Table "PUBLIC"."TEST" as "X11" Full Scan
2025-06-26 06:42:27.517 E           Select Expression
2025-06-26 06:42:27.517 E           ....-> Filter (preliminary)
2025-06-26 06:42:27.517 E         - ........-> Table "TEST" as "A11" Full Scan
2025-06-26 06:42:27.517 E         + ........-> Table "PUBLIC"."TEST" as "A11" Full Scan
2025-06-26 06:42:27.517 E           4000
2025-06-26 06:42:27.517 E           select id,txt_short from test a12 where exists(select 1 from test x12 where txt_short>'' order by id)
2025-06-26 06:42:27.517 E           MUST use refetch: column x12.txt_short not present in order by
2025-06-26 06:42:27.517 E           Sub-query (invariant)
2025-06-26 06:42:27.517 E           ....-> Refetch
2025-06-26 06:42:27.517 E           ........-> Sort (record length: 28, key length: 8)
2025-06-26 06:42:27.517 E           ............-> Filter
2025-06-26 06:42:27.517 E         - ................-> Table "TEST" as "X12" Full Scan
2025-06-26 06:42:27.517 E         + ................-> Table "PUBLIC"."TEST" as "X12" Full Scan
2025-06-26 06:42:27.517 E           Select Expression
2025-06-26 06:42:27.517 E           ....-> Filter (preliminary)
2025-06-26 06:42:27.517 E         - ........-> Table "TEST" as "A12" Full Scan
2025-06-26 06:42:27.517 E         + ........-> Table "PUBLIC"."TEST" as "A12" Full Scan
2025-06-26 06:42:27.518 E           4010
2025-06-26 06:42:27.518 E           select id,txt_short from test a13 where exists(select 1 from test x13 where computed_id_dup > 0  order by id)
2025-06-26 06:42:27.518 E           Must NOT use refetch: ORDER BY list contains the single element: ID, and it is base for x13.computed_id_dup column
2025-06-26 06:42:27.518 E           Sub-query (invariant)
2025-06-26 06:42:27.518 E           ....-> Sort (record length: 28, key length: 8)
2025-06-26 06:42:27.518 E           ........-> Filter
2025-06-26 06:42:27.518 E         - ............-> Table "TEST" as "X13" Full Scan
2025-06-26 06:42:27.518 E         + ............-> Table "PUBLIC"."TEST" as "X13" Full Scan
2025-06-26 06:42:27.518 E           Select Expression
2025-06-26 06:42:27.518 E           ....-> Filter (preliminary)
2025-06-26 06:42:27.518 E         - ........-> Table "TEST" as "A13" Full Scan
2025-06-26 06:42:27.518 E         + ........-> Table "PUBLIC"."TEST" as "A13" Full Scan
2025-06-26 06:42:27.518 E           4020
2025-06-26 06:42:27.518 E           select id,txt_short from test a14 where exists(select 1 from test x14 where computed_id_dup > 0  order by computed_id_dup)
2025-06-26 06:42:27.518 E           MUST use refetch! See letter from dimitr 28.12.2020 14:49
2025-06-26 06:42:27.518 E           Sort procedure will get:
2025-06-26 06:42:27.518 E           a KEY = result of evaluating 'computed_id_dup';
2025-06-26 06:42:27.519 E           a VAL = value of the field 'ID' which is base for computing 'computed_id_dup'
2025-06-26 06:42:27.519 E           Thus sorter will have a field which not equals to a key, which leads to refetch.
2025-06-26 06:42:27.519 E           Sub-query (invariant)
2025-06-26 06:42:27.519 E           ....-> Refetch
2025-06-26 06:42:27.519 E           ........-> Sort (record length: 36, key length: 12)
2025-06-26 06:42:27.519 E           ............-> Filter
2025-06-26 06:42:27.519 E         - ................-> Table "TEST" as "X14" Full Scan
2025-06-26 06:42:27.519 E         + ................-> Table "PUBLIC"."TEST" as "X14" Full Scan
2025-06-26 06:42:27.519 E           Select Expression
2025-06-26 06:42:27.519 E           ....-> Filter (preliminary)
2025-06-26 06:42:27.519 E         - ........-> Table "TEST" as "A14" Full Scan
2025-06-26 06:42:27.519 E         + ........-> Table "PUBLIC"."TEST" as "A14" Full Scan
2025-06-26 06:42:27.519 E           4030
2025-06-26 06:42:27.519 E           select id,txt_short from test a15 where exists(select 1 from test x15 where f02>0 and f01>0 order by f01, f02)
2025-06-26 06:42:27.519 E           Must NOT use refetch: all persistent columns from WHERE expression (f01, f02) belong to ORDER BY list
2025-06-26 06:42:27.519 E           Sub-query (invariant)
2025-06-26 06:42:27.520 E           ....-> Sort (record length: 36, key length: 16)
2025-06-26 06:42:27.520 E           ........-> Filter
2025-06-26 06:42:27.520 E         - ............-> Table "TEST" as "X15" Full Scan
2025-06-26 06:42:27.520 E         + ............-> Table "PUBLIC"."TEST" as "X15" Full Scan
2025-06-26 06:42:27.520 E           Select Expression
2025-06-26 06:42:27.520 E           ....-> Filter (preliminary)
2025-06-26 06:42:27.520 E         - ........-> Table "TEST" as "A15" Full Scan
2025-06-26 06:42:27.520 E         + ........-> Table "PUBLIC"."TEST" as "A15" Full Scan
2025-06-26 06:42:27.520 E           4040
2025-06-26 06:42:27.520 E           select id,txt_short from test a16 where exists(select 1 from test x16 where id>0 and f01>0 order by f01, f02)
2025-06-26 06:42:27.520 E           Must use refetch: one of columns from WHERE expr (id) does not belong to ORDER BY list
2025-06-26 06:42:27.520 E           Sub-query (invariant)
2025-06-26 06:42:27.520 E           ....-> Refetch
2025-06-26 06:42:27.520 E           ........-> Sort (record length: 36, key length: 16)
2025-06-26 06:42:27.520 E           ............-> Filter
2025-06-26 06:42:27.520 E         - ................-> Table "TEST" as "X16" Full Scan
2025-06-26 06:42:27.520 E         + ................-> Table "PUBLIC"."TEST" as "X16" Full Scan
2025-06-26 06:42:27.521 E           Select Expression
2025-06-26 06:42:27.521 E           ....-> Filter (preliminary)
2025-06-26 06:42:27.521 E         - ........-> Table "TEST" as "A16" Full Scan
2025-06-26 06:42:27.521 E         + ........-> Table "PUBLIC"."TEST" as "A16" Full Scan
2025-06-26 06:42:27.521 E           4050
2025-06-26 06:42:27.521 E           select id,txt_short from test a17 where exists(select 1 from test x17 where computed_id_dup > 0 order by f01)
2025-06-26 06:42:27.521 E           Must use refetch: computed column in WHERE expr does not belong to ORDER BY list
2025-06-26 06:42:27.521 E           Sub-query (invariant)
2025-06-26 06:42:27.521 E           ....-> Refetch
2025-06-26 06:42:27.521 E           ........-> Sort (record length: 28, key length: 8)
2025-06-26 06:42:27.521 E           ............-> Filter
2025-06-26 06:42:27.521 E         - ................-> Table "TEST" as "X17" Full Scan
2025-06-26 06:42:27.521 E         + ................-> Table "PUBLIC"."TEST" as "X17" Full Scan
2025-06-26 06:42:27.521 E           Select Expression
2025-06-26 06:42:27.521 E           ....-> Filter (preliminary)
2025-06-26 06:42:27.521 E         - ........-> Table "TEST" as "A17" Full Scan
2025-06-26 06:42:27.522 E         + ........-> Table "PUBLIC"."TEST" as "A17" Full Scan
2025-06-26 06:42:27.522 E           4060
2025-06-26 06:42:27.522 E           select id,txt_short from test a18 where exists(select 1 from test x18 where computed_guid > '' order by f01)
2025-06-26 06:42:27.522 E           Must NOT use refetch: computed column x18.computed_guid does is evaluated via GUID and does not refer to any columns
2025-06-26 06:42:27.522 E           Sub-query (invariant)
2025-06-26 06:42:27.522 E           ....-> Sort (record length: 28, key length: 8)
2025-06-26 06:42:27.522 E           ........-> Filter
2025-06-26 06:42:27.522 E         - ............-> Table "TEST" as "X18" Full Scan
2025-06-26 06:42:27.522 E         + ............-> Table "PUBLIC"."TEST" as "X18" Full Scan
2025-06-26 06:42:27.522 E           Select Expression
2025-06-26 06:42:27.522 E           ....-> Filter (preliminary)
2025-06-26 06:42:27.522 E         - ........-> Table "TEST" as "A18" Full Scan
2025-06-26 06:42:27.522 E         + ........-> Table "PUBLIC"."TEST" as "A18" Full Scan
2025-06-26 06:42:27.522 E           4070
2025-06-26 06:42:27.522 E           with recursive
2025-06-26 06:42:27.522 E           r as (
2025-06-26 06:42:27.523 E           select a19.id, a19.txt_short
2025-06-26 06:42:27.523 E           from test a19
2025-06-26 06:42:27.523 E           where not exists(select * from test x where x.txt_short < a19.txt_short order by id)
2025-06-26 06:42:27.523 E           UNION ALL
2025-06-26 06:42:27.523 E           select i.id, i.txt_short
2025-06-26 06:42:27.523 E           from test i
2025-06-26 06:42:27.523 E           join r on i.id > r.id
2025-06-26 06:42:27.523 E           and not exists( select * from test x where x.txt_short between r.txt_short and i.txt_short order by id )
2025-06-26 06:42:27.523 E           )
2025-06-26 06:42:27.523 E           select * from r
2025-06-26 06:42:27.523 E           MUST use refetch both in anchor and recursive parts
2025-06-26 06:42:27.523 E           Sub-query
2025-06-26 06:42:27.523 E           ....-> Refetch
2025-06-26 06:42:27.523 E           ........-> Sort (record length: 28, key length: 8)
2025-06-26 06:42:27.523 E           ............-> Filter
2025-06-26 06:42:27.523 E         - ................-> Table "TEST" as "R X" Full Scan
2025-06-26 06:42:27.523 E         + ................-> Table "PUBLIC"."TEST" as "R" "X" Full Scan
2025-06-26 06:42:27.524 E           Sub-query
2025-06-26 06:42:27.524 E           ....-> Refetch
2025-06-26 06:42:27.524 E           ........-> Sort (record length: 28, key length: 8)
2025-06-26 06:42:27.524 E           ............-> Filter
2025-06-26 06:42:27.524 E         - ................-> Table "TEST" as "R X" Full Scan
2025-06-26 06:42:27.524 E         + ................-> Table "PUBLIC"."TEST" as "R" "X" Full Scan
2025-06-26 06:42:27.524 E           Select Expression
2025-06-26 06:42:27.524 E           ....-> Recursion
2025-06-26 06:42:27.524 E           ........-> Filter
2025-06-26 06:42:27.524 E         - ............-> Table "TEST" as "R A19" Full Scan
2025-06-26 06:42:27.524 E         + ............-> Table "PUBLIC"."TEST" as "R" "A19" Full Scan
2025-06-26 06:42:27.524 E           ........-> Filter
2025-06-26 06:42:27.524 E         - ............-> Table "TEST" as "R I" Full Scan
2025-06-26 06:42:27.524 E         + ............-> Table "PUBLIC"."TEST" as "R" "I" Full Scan
2025-06-26 06:42:27.525 E           5000
2025-06-26 06:42:27.525 E           select txt_broad from v_unioned v01 order by id
2025-06-26 06:42:27.525 E           Must NOT use refetch because view DDL includes UNION
2025-06-26 06:42:27.525 E           Select Expression
2025-06-26 06:42:27.525 E           ....-> Sort (record length: 4044, key length: 8)
2025-06-26 06:42:27.525 E           ........-> First N Records
2025-06-26 06:42:27.525 E           ............-> Union
2025-06-26 06:42:27.525 E         - ................-> Table "TEST" as "V01 TEST" Full Scan
2025-06-26 06:42:27.525 E         + ................-> Table "PUBLIC"."TEST" as "V01" "PUBLIC"."TEST" Full Scan
2025-06-26 06:42:27.525 E         - ................-> Table "RDB$DATABASE" as "V01 RDB$DATABASE" Full Scan
2025-06-26 06:42:27.525 E         + ................-> Table "SYSTEM"."RDB$DATABASE" as "V01" "SYSTEM"."RDB$DATABASE" Full Scan
2025-06-26 06:42:27.525 E           6000
2025-06-26 06:42:27.525 E           select left(txt_broad, 50) as txt from test a21 order by id
2025-06-26 06:42:27.525 E           MUST use refetch because expression is based on column which has length >= threshold
2025-06-26 06:42:27.526 E           (even if final length of expression result is much less than threshold)
2025-06-26 06:42:27.526 E           Select Expression
2025-06-26 06:42:27.526 E           ....-> Refetch
2025-06-26 06:42:27.526 E           ........-> Sort (record length: 28, key length: 8)
2025-06-26 06:42:27.526 E         - ............-> Table "TEST" as "A21" Full Scan
2025-06-26 06:42:27.526 E         + ............-> Table "PUBLIC"."TEST" as "A21" Full Scan
2025-06-26 06:42:27.526 E           6010
2025-06-26 06:42:27.526 E           select left( txt_short || txt_short, 2000) as txt from test a22 order by id
2025-06-26 06:42:27.526 E           Must NOT use refetch because expression is based on column which has length < threshold
2025-06-26 06:42:27.526 E           (even if final length of expression result is much bigger than threshold)
2025-06-26 06:42:27.526 E           Select Expression
2025-06-26 06:42:27.526 E           ....-> Sort (record length: 1036, key length: 8)
2025-06-26 06:42:27.526 E         - ........-> Table "TEST" as "A22" Full Scan
2025-06-26 06:42:27.526 E         + ........-> Table "PUBLIC"."TEST" as "A22" Full Scan
2025-06-26 06:42:27.526 E           7000
2025-06-26 06:42:27.526 E           select * from test_ns_01 a23 order by id
2025-06-26 06:42:27.526 E           MUST use refetch
2025-06-26 06:42:27.527 E           Select Expression
2025-06-26 06:42:27.527 E           ....-> Refetch
2025-06-26 06:42:27.527 E           ........-> Sort (record length: 44, key length: 24)
2025-06-26 06:42:27.527 E         - ............-> Table "TEST_NS_01" as "A23" Full Scan
2025-06-26 06:42:27.527 E         + ............-> Table "PUBLIC"."TEST_NS_01" as "A23" Full Scan
2025-06-26 06:42:27.527 E           7010
2025-06-26 06:42:27.527 E           select * from test_ns_02 a24 order by id
2025-06-26 06:42:27.527 E           Must NOT refetch
2025-06-26 06:42:27.527 E           Select Expression
2025-06-26 06:42:27.527 E           ....-> Sort (record length: 1052, key length: 24)
2025-06-26 06:42:27.527 E         - ........-> Table "TEST_NS_02" as "A24" Full Scan
2025-06-26 06:42:27.527 E         + ........-> Table "PUBLIC"."TEST_NS_02" as "A24" Full Scan
2025-06-26 06:42:27.527 E           7020
2025-06-26 06:42:27.527 E           select * from test_ns_03 order by id
2025-06-26 06:42:27.527 E           MUST use refetch
2025-06-26 06:42:27.527 E           Select Expression
2025-06-26 06:42:27.527 E           ....-> Refetch
2025-06-26 06:42:27.528 E           ........-> Sort (record length: 36, key length: 12)
2025-06-26 06:42:27.528 E         - ............-> Table "TEST_NS_03" Full Scan
2025-06-26 06:42:27.528 E         + ............-> Table "PUBLIC"."TEST_NS_03" Full Scan
2025-06-26 06:42:27.528 E           7030
2025-06-26 06:42:27.528 E           select * from test_ns_04 order by id
2025-06-26 06:42:27.528 E           Must NOT use refetch
2025-06-26 06:42:27.528 E           Select Expression
2025-06-26 06:42:27.528 E           ....-> Sort (record length: 1036, key length: 12)
2025-06-26 06:42:27.528 E         - ........-> Table "TEST_NS_04" Full Scan
2025-06-26 06:42:27.528 E         + ........-> Table "PUBLIC"."TEST_NS_04" Full Scan
2025-06-26 06:42:27.528 E           7040
2025-06-26 06:42:27.528 E           select * from test_ns_05 order by id
2025-06-26 06:42:27.528 E           MUST use refetch
2025-06-26 06:42:27.528 E           Select Expression
2025-06-26 06:42:27.528 E           ....-> Refetch
2025-06-26 06:42:27.528 E           ........-> Sort (record length: 36, key length: 12)
2025-06-26 06:42:27.528 E         - ............-> Table "TEST_NS_05" Full Scan
2025-06-26 06:42:27.529 E         + ............-> Table "PUBLIC"."TEST_NS_05" Full Scan
2025-06-26 06:42:27.529 E           7050
2025-06-26 06:42:27.529 E           select * from test_ns_06 order by id
2025-06-26 06:42:27.529 E           Must NOT use refetch
2025-06-26 06:42:27.529 E           Select Expression
2025-06-26 06:42:27.529 E           ....-> Sort (record length: 1036, key length: 12)
2025-06-26 06:42:27.529 E         - ........-> Table "TEST_NS_06" Full Scan
2025-06-26 06:42:27.529 E         + ........-> Table "PUBLIC"."TEST_NS_06" Full Scan
2025-06-26 06:42:27.529
2025-06-26 06:42:27.529 tests\bugs\core_2650_test.py:1199: AssertionError
2025-06-26 06:42:27.529 ---------------------------- Captured stdout setup ----------------------------
2025-06-26 06:42:27.529 Creating db: localhost:H:\QA\temp\qa2024.tmp\fbqa\test_1442\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('>=4.0')
    def test_1(act: Action, capsys):
        with act.db.connect() as con:
    
            # 13.01.2025: test will FAIL if config parameter OptimizeForFirstRows differs from default value (i.e. is set to true).
            # To prevent this, we have to explicitly change appropriate session-level value:
            if act.is_version('<5'):
                pass
            else:
                con.execute_immediate('set optimize for all rows')
    
            cur = con.cursor()
            for q_idx, q_tuple in query_map.items():
                test_sql, qry_comment = q_tuple[:2]
                ps = cur.prepare(test_sql)
                print(q_idx)
                print(test_sql)
                print(qry_comment)
                print( '\n'.join([replace_leading(s) for s in ps.detailed_plan.split('\n')]) )
                ps.free()
    
        act.expected_stdout = fb4x_expected_out if act.is_version('<5') else fb5x_expected_out if act.is_version('<6') else fb6x_expected_out
        act.stdout = capsys.readouterr().out
>       assert act.clean_stdout == act.clean_expected_stdout
E       assert   
E           1000
E           select txt_short from test a01 order by id
E           Must NOT use refetch because length of non-key column is less than threshold
E           Select Expression
E           ....-> Sort (record length: 1036, key length: 8)
E         - ........-> Table "TEST" as "A01" Full Scan
E         + ........-> Table "PUBLIC"."TEST" as "A01" Full Scan
E           1010
E           select txt_broad from test a02 order by id
E           MUST use refetch because length of non-key column is greater than threshold
E           Select Expression
E           ....-> Refetch
E           ........-> Sort (record length: 28, key length: 8)
E         - ............-> Table "TEST" as "A02" Full Scan
E         + ............-> Table "PUBLIC"."TEST" as "A02" Full Scan
E           1020
E           select txt_short from test a03 order by id rows 1
E           MUST use refetch regardless on length of column because ROWS <N> presents
E           Select Expression
E           ....-> First N Records
E           ........-> Refetch
E           ............-> Sort (record length: 28, key length: 8)
E         - ................-> Table "TEST" as "A03" Full Scan
E         + ................-> Table "PUBLIC"."TEST" as "A03" Full Scan
E           2000
E           select id, computed_ts_dup from test order by id
E           Must NOT use refetch because computed column is based on txt_short with length < threshold
E           Select Expression
E           ....-> Sort (record length: 1036, key length: 8)
E         - ........-> Table "TEST" Full Scan
E         + ........-> Table "PUBLIC"."TEST" Full Scan
E           2010
E           select id, computed_tb_dup from test order by id
E           MUST use refetch because computed column is based on txt_broad which has length >= threshold
E           Select Expression
E           ....-> Refetch
E           ........-> Sort (record length: 28, key length: 8)
E         - ............-> Table "TEST" Full Scan
E         + ............-> Table "PUBLIC"."TEST" Full Scan
E           3000
E           select id from test a04 where '' in (select txt_short from test x04 where txt_short = '' order by id)
E           *** not [yet] commented ***
E           Sub-query (invariant)
E           ....-> Filter
E           ........-> Sort (record length: 1036, key length: 8)
E           ............-> Filter
E         - ................-> Table "TEST" as "X04" Full Scan
E         + ................-> Table "PUBLIC"."TEST" as "X04" Full Scan
E           Select Expression
E           ....-> Filter (preliminary)
E         - ........-> Table "TEST" as "A04" Full Scan
E         + ........-> Table "PUBLIC"."TEST" as "A04" Full Scan
E           3010
E           select id from test a05 where '' in (select txt_broad from test x05 where txt_broad = '' order by id)
E           *** not [yet] commented ***
E           Sub-query (invariant)
E           ....-> Filter
E           ........-> Refetch
E           ............-> Sort (record length: 28, key length: 8)
E           ................-> Filter
E         - ....................-> Table "TEST" as "X05" Full Scan
E         + ....................-> Table "PUBLIC"."TEST" as "X05" Full Scan
E           Select Expression
E           ....-> Filter (preliminary)
E         - ........-> Table "TEST" as "A05" Full Scan
E         + ........-> Table "PUBLIC"."TEST" as "A05" Full Scan
E           3020
E           select id from test a06 where '' not in (select txt_short from test x06 where txt_short>'' order by id)
E           *** not [yet] commented ***
E           Sub-query (invariant)
E           ....-> Sort (record length: 1036, key length: 8)
E           ........-> Filter
E         - ............-> Table "TEST" as "X06" Full Scan
E         + ............-> Table "PUBLIC"."TEST" as "X06" Full Scan
E           Sub-query (invariant)
E           ....-> Sort (record length: 1036, key length: 8)
E           ........-> Filter
E         - ............-> Table "TEST" as "X06" Full Scan
E         + ............-> Table "PUBLIC"."TEST" as "X06" Full Scan
E           Select Expression
E           ....-> Filter (preliminary)
E         - ........-> Table "TEST" as "A06" Full Scan
E         + ........-> Table "PUBLIC"."TEST" as "A06" Full Scan
E           3030
E           select id from test a07 where '' not in (select txt_broad from test x07 where txt_broad>'' order by id)
E           *** not [yet] commented ***
E           Sub-query (invariant)
E           ....-> Refetch
E           ........-> Sort (record length: 28, key length: 8)
E           ............-> Filter
E         - ................-> Table "TEST" as "X07" Full Scan
E         + ................-> Table "PUBLIC"."TEST" as "X07" Full Scan
E           Sub-query (invariant)
E           ....-> Refetch
E           ........-> Sort (record length: 28, key length: 8)
E           ............-> Filter
E         - ................-> Table "TEST" as "X07" Full Scan
E         + ................-> Table "PUBLIC"."TEST" as "X07" Full Scan
E           Select Expression
E           ....-> Filter (preliminary)
E         - ........-> Table "TEST" as "A07" Full Scan
E         + ........-> Table "PUBLIC"."TEST" as "A07" Full Scan
E           3040
E           select id from test a08 where '' > all (select id from test x08 where txt_short>'' order by id)
E           *** not [yet] commented ***
E           Sub-query (invariant)
E           ....-> Filter
E           ........-> Sort (record length: 1036, key length: 8)
E           ............-> Filter
E         - ................-> Table "TEST" as "X08" Full Scan
E         + ................-> Table "PUBLIC"."TEST" as "X08" Full Scan
E           Select Expression
E           ....-> Filter (preliminary)
E         - ........-> Table "TEST" as "A08" Full Scan
E         + ........-> Table "PUBLIC"."TEST" as "A08" Full Scan
E           3050
E           select id from test a09 where '' > all (select id from test x09 where txt_broad>'' order by id)
E           *** not [yet] commented ***
E           Sub-query (invariant)
E           ....-> Filter
E           ........-> Refetch
E           ............-> Sort (record length: 28, key length: 8)
E           ................-> Filter
E         - ....................-> Table "TEST" as "X09" Full Scan
E         + ....................-> Table "PUBLIC"."TEST" as "X09" Full Scan
E           Select Expression
E           ....-> Filter (preliminary)
E         - ........-> Table "TEST" as "A09" Full Scan
E         + ........-> Table "PUBLIC"."TEST" as "A09" Full Scan
E           3060
E           select id from test a10 where '' <> any (select id from test x10 where txt_short>'' order by id)
E           *** not [yet] commented ***
E           Sub-query (invariant)
E           ....-> Filter
E           ........-> Sort (record length: 1036, key length: 8)
E           ............-> Filter
E         - ................-> Table "TEST" as "X10" Full Scan
E         + ................-> Table "PUBLIC"."TEST" as "X10" Full Scan
E           Select Expression
E           ....-> Filter (preliminary)
E         - ........-> Table "TEST" as "A10" Full Scan
E         + ........-> Table "PUBLIC"."TEST" as "A10" Full Scan
E           3070
E           select id from test a11 where '' <> any (select id from test x11 where txt_broad>'' order by id)
E           *** not [yet] commented ***
E           Sub-query (invariant)
E           ....-> Filter
E           ........-> Refetch
E           ............-> Sort (record length: 28, key length: 8)
E           ................-> Filter
E         - ....................-> Table "TEST" as "X11" Full Scan
E         + ....................-> Table "PUBLIC"."TEST" as "X11" Full Scan
E           Select Expression
E           ....-> Filter (preliminary)
E         - ........-> Table "TEST" as "A11" Full Scan
E         + ........-> Table "PUBLIC"."TEST" as "A11" Full Scan
E           4000
E           select id,txt_short from test a12 where exists(select 1 from test x12 where txt_short>'' order by id)
E           MUST use refetch: column x12.txt_short not present in order by
E           Sub-query (invariant)
E           ....-> Refetch
E           ........-> Sort (record length: 28, key length: 8)
E           ............-> Filter
E         - ................-> Table "TEST" as "X12" Full Scan
E         + ................-> Table "PUBLIC"."TEST" as "X12" Full Scan
E           Select Expression
E           ....-> Filter (preliminary)
E         - ........-> Table "TEST" as "A12" Full Scan
E         + ........-> Table "PUBLIC"."TEST" as "A12" Full Scan
E           4010
E           select id,txt_short from test a13 where exists(select 1 from test x13 where computed_id_dup > 0  order by id)
E           Must NOT use refetch: ORDER BY list contains the single element: ID, and it is base for x13.computed_id_dup column
E           Sub-query (invariant)
E           ....-> Sort (record length: 28, key length: 8)
E           ........-> Filter
E         - ............-> Table "TEST" as "X13" Full Scan
E         + ............-> Table "PUBLIC"."TEST" as "X13" Full Scan
E           Select Expression
E           ....-> Filter (preliminary)
E         - ........-> Table "TEST" as "A13" Full Scan
E         + ........-> Table "PUBLIC"."TEST" as "A13" Full Scan
E           4020
E           select id,txt_short from test a14 where exists(select 1 from test x14 where computed_id_dup > 0  order by computed_id_dup)
E           MUST use refetch! See letter from dimitr 28.12.2020 14:49
E           Sort procedure will get:
E           a KEY = result of evaluating 'computed_id_dup';
E           a VAL = value of the field 'ID' which is base for computing 'computed_id_dup'
E           Thus sorter will have a field which not equals to a key, which leads to refetch.
E           Sub-query (invariant)
E           ....-> Refetch
E           ........-> Sort (record length: 36, key length: 12)
E           ............-> Filter
E         - ................-> Table "TEST" as "X14" Full Scan
E         + ................-> Table "PUBLIC"."TEST" as "X14" Full Scan
E           Select Expression
E           ....-> Filter (preliminary)
E         - ........-> Table "TEST" as "A14" Full Scan
E         + ........-> Table "PUBLIC"."TEST" as "A14" Full Scan
E           4030
E           select id,txt_short from test a15 where exists(select 1 from test x15 where f02>0 and f01>0 order by f01, f02)
E           Must NOT use refetch: all persistent columns from WHERE expression (f01, f02) belong to ORDER BY list
E           Sub-query (invariant)
E           ....-> Sort (record length: 36, key length: 16)
E           ........-> Filter
E         - ............-> Table "TEST" as "X15" Full Scan
E         + ............-> Table "PUBLIC"."TEST" as "X15" Full Scan
E           Select Expression
E           ....-> Filter (preliminary)
E         - ........-> Table "TEST" as "A15" Full Scan
E         + ........-> Table "PUBLIC"."TEST" as "A15" Full Scan
E           4040
E           select id,txt_short from test a16 where exists(select 1 from test x16 where id>0 and f01>0 order by f01, f02)
E           Must use refetch: one of columns from WHERE expr (id) does not belong to ORDER BY list
E           Sub-query (invariant)
E           ....-> Refetch
E           ........-> Sort (record length: 36, key length: 16)
E           ............-> Filter
E         - ................-> Table "TEST" as "X16" Full Scan
E         + ................-> Table "PUBLIC"."TEST" as "X16" Full Scan
E           Select Expression
E           ....-> Filter (preliminary)
E         - ........-> Table "TEST" as "A16" Full Scan
E         + ........-> Table "PUBLIC"."TEST" as "A16" Full Scan
E           4050
E           select id,txt_short from test a17 where exists(select 1 from test x17 where computed_id_dup > 0 order by f01)
E           Must use refetch: computed column in WHERE expr does not belong to ORDER BY list
E           Sub-query (invariant)
E           ....-> Refetch
E           ........-> Sort (record length: 28, key length: 8)
E           ............-> Filter
E         - ................-> Table "TEST" as "X17" Full Scan
E         + ................-> Table "PUBLIC"."TEST" as "X17" Full Scan
E           Select Expression
E           ....-> Filter (preliminary)
E         - ........-> Table "TEST" as "A17" Full Scan
E         + ........-> Table "PUBLIC"."TEST" as "A17" Full Scan
E           4060
E           select id,txt_short from test a18 where exists(select 1 from test x18 where computed_guid > '' order by f01)
E           Must NOT use refetch: computed column x18.computed_guid does is evaluated via GUID and does not refer to any columns
E           Sub-query (invariant)
E           ....-> Sort (record length: 28, key length: 8)
E           ........-> Filter
E         - ............-> Table "TEST" as "X18" Full Scan
E         + ............-> Table "PUBLIC"."TEST" as "X18" Full Scan
E           Select Expression
E           ....-> Filter (preliminary)
E         - ........-> Table "TEST" as "A18" Full Scan
E         + ........-> Table "PUBLIC"."TEST" as "A18" Full Scan
E           4070
E           with recursive
E           r as (
E           select a19.id, a19.txt_short
E           from test a19
E           where not exists(select * from test x where x.txt_short < a19.txt_short order by id)
E           UNION ALL
E           select i.id, i.txt_short
E           from test i
E           join r on i.id > r.id
E           and not exists( select * from test x where x.txt_short between r.txt_short and i.txt_short order by id )
E           )
E           select * from r
E           MUST use refetch both in anchor and recursive parts
E           Sub-query
E           ....-> Refetch
E           ........-> Sort (record length: 28, key length: 8)
E           ............-> Filter
E         - ................-> Table "TEST" as "R X" Full Scan
E         + ................-> Table "PUBLIC"."TEST" as "R" "X" Full Scan
E           Sub-query
E           ....-> Refetch
E           ........-> Sort (record length: 28, key length: 8)
E           ............-> Filter
E         - ................-> Table "TEST" as "R X" Full Scan
E         + ................-> Table "PUBLIC"."TEST" as "R" "X" Full Scan
E           Select Expression
E           ....-> Recursion
E           ........-> Filter
E         - ............-> Table "TEST" as "R A19" Full Scan
E         + ............-> Table "PUBLIC"."TEST" as "R" "A19" Full Scan
E           ........-> Filter
E         - ............-> Table "TEST" as "R I" Full Scan
E         + ............-> Table "PUBLIC"."TEST" as "R" "I" Full Scan
E           5000
E           select txt_broad from v_unioned v01 order by id
E           Must NOT use refetch because view DDL includes UNION
E           Select Expression
E           ....-> Sort (record length: 4044, key length: 8)
E           ........-> First N Records
E           ............-> Union
E         - ................-> Table "TEST" as "V01 TEST" Full Scan
E         + ................-> Table "PUBLIC"."TEST" as "V01" "PUBLIC"."TEST" Full Scan
E         - ................-> Table "RDB$DATABASE" as "V01 RDB$DATABASE" Full Scan
E         + ................-> Table "SYSTEM"."RDB$DATABASE" as "V01" "SYSTEM"."RDB$DATABASE" Full Scan
E           6000
E           select left(txt_broad, 50) as txt from test a21 order by id
E           MUST use refetch because expression is based on column which has length >= threshold
E           (even if final length of expression result is much less than threshold)
E           Select Expression
E           ....-> Refetch
E           ........-> Sort (record length: 28, key length: 8)
E         - ............-> Table "TEST" as "A21" Full Scan
E         + ............-> Table "PUBLIC"."TEST" as "A21" Full Scan
E           6010
E           select left( txt_short || txt_short, 2000) as txt from test a22 order by id
E           Must NOT use refetch because expression is based on column which has length < threshold
E           (even if final length of expression result is much bigger than threshold)
E           Select Expression
E           ....-> Sort (record length: 1036, key length: 8)
E         - ........-> Table "TEST" as "A22" Full Scan
E         + ........-> Table "PUBLIC"."TEST" as "A22" Full Scan
E           7000
E           select * from test_ns_01 a23 order by id
E           MUST use refetch
E           Select Expression
E           ....-> Refetch
E           ........-> Sort (record length: 44, key length: 24)
E         - ............-> Table "TEST_NS_01" as "A23" Full Scan
E         + ............-> Table "PUBLIC"."TEST_NS_01" as "A23" Full Scan
E           7010
E           select * from test_ns_02 a24 order by id
E           Must NOT refetch
E           Select Expression
E           ....-> Sort (record length: 1052, key length: 24)
E         - ........-> Table "TEST_NS_02" as "A24" Full Scan
E         + ........-> Table "PUBLIC"."TEST_NS_02" as "A24" Full Scan
E           7020
E           select * from test_ns_03 order by id
E           MUST use refetch
E           Select Expression
E           ....-> Refetch
E           ........-> Sort (record length: 36, key length: 12)
E         - ............-> Table "TEST_NS_03" Full Scan
E         + ............-> Table "PUBLIC"."TEST_NS_03" Full Scan
E           7030
E           select * from test_ns_04 order by id
E           Must NOT use refetch
E           Select Expression
E           ....-> Sort (record length: 1036, key length: 12)
E         - ........-> Table "TEST_NS_04" Full Scan
E         + ........-> Table "PUBLIC"."TEST_NS_04" Full Scan
E           7040
E           select * from test_ns_05 order by id
E           MUST use refetch
E           Select Expression
E           ....-> Refetch
E           ........-> Sort (record length: 36, key length: 12)
E         - ............-> Table "TEST_NS_05" Full Scan
E         + ............-> Table "PUBLIC"."TEST_NS_05" Full Scan
E           7050
E           select * from test_ns_06 order by id
E           Must NOT use refetch
E           Select Expression
E           ....-> Sort (record length: 1036, key length: 12)
E         - ........-> Table "TEST_NS_06" Full Scan
E         + ........-> Table "PUBLIC"."TEST_NS_06" Full Scan

tests\bugs\core_2650_test.py:1199: 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 P P 742 486 2025.06.28 02:02:21.588 2025.06.28 02:02:22.330 2025.06.28 00:24:31.523 2025.06.28 00:24:32.009
2 6.0.0.877 2025.06.26 8e38f P P 749 489 2025.06.27 02:01:13.562 2025.06.27 02:01:14.311 2025.06.27 00:24:17.566 2025.06.27 00:24:18.055
3 6.0.0.876 2025.06.25 b1bec F F 777 528 2025.06.26 02:06:32.758 2025.06.26 02:06:33.535 2025.06.26 00:28:20.056 2025.06.26 00:28:20.584
4 6.0.0.863 2025.06.24 c3c20 F F 792 526 2025.06.25 06:50:51.678 2025.06.25 06:50:52.470 2025.06.25 00:24:15.140 2025.06.25 00:24:15.666
5 6.0.0.858 2025.06.24 cbbbf F F 831 541 2025.06.24 16:32:53.510 2025.06.24 16:32:54.341 2025.06.24 14:56:13.409 2025.06.24 14:56:13.950
6 6.0.0.858 2025.06.23 d377c F F 772 537 2025.06.24 07:44:49.013 2025.06.24 07:44:49.785 2025.06.24 06:08:41.799 2025.06.24 06:08:42.336
7 6.0.0.854 2025.06.23 10b58 F F 773 549 2025.06.23 14:25:31.927 2025.06.23 14:25:32.700 2025.06.23 12:47:59.549 2025.06.23 12:48:00.098
8 6.0.0.849 2025.06.20 7b79c F F 794 537 2025.06.21 02:04:37.792 2025.06.21 02:04:38.586 2025.06.21 00:24:30.378 2025.06.21 00:24:30.915
9 6.0.0.848 2025.06.19 c483c F F 798 596 2025.06.20 02:04:07.065 2025.06.20 02:04:07.863 2025.06.20 00:24:19.670 2025.06.20 00:24:20.266
10 6.0.0.845 2025.06.18 20191 F F 764 541 2025.06.19 02:03:47.899 2025.06.19 02:03:48.663 2025.06.19 00:24:20.371 2025.06.19 00:24:20.912
11 6.0.0.843 2025.06.16 995f4 F F 770 553 2025.06.18 02:03:32.388 2025.06.18 02:03:33.158 2025.06.18 00:24:22.312 2025.06.18 00:24:22.865
12 6.0.0.840 2025.06.14 29bca F F 778 542 2025.06.15 02:10:08.770 2025.06.15 02:10:09.548 2025.06.15 00:25:02.389 2025.06.15 00:25:02.931
13 6.0.0.838 2025.06.13 0e28a F F 821 541 2025.06.14 02:08:39.579 2025.06.14 02:08:40.400 2025.06.14 00:24:26.868 2025.06.14 00:24:27.409
14 6.0.0.834 2025.06.11 e889f F F 796 555 2025.06.12 02:06:51.961 2025.06.12 02:06:52.757 2025.06.12 00:24:47.322 2025.06.12 00:24:47.877
15 6.0.0.800 2025.06.10 1f226 P P 700 448 2025.06.11 01:23:46.034 2025.06.11 01:23:46.734 2025.06.11 00:22:19.078 2025.06.11 00:22:19.526
16 6.0.0.799 2025.06.07 be644 P P 710 449 2025.06.10 01:23:19.999 2025.06.10 01:23:20.709 2025.06.10 00:22:15.130 2025.06.10 00:22:15.579
17 6.0.0.797 2025.06.06 303e8 P P 713 461 2025.06.07 01:22:35.441 2025.06.07 01:22:36.154 2025.06.07 00:22:14.693 2025.06.07 00:22:15.154
18 6.0.0.795 2025.05.29 7a71a P P 687 450 2025.06.06 01:22:30.609 2025.06.06 01:22:31.296 2025.06.06 00:22:14.352 2025.06.06 00:22:14.802
19 6.0.0.792 2025.05.28 ee5a8 P P 717 450 2025.05.29 01:21:39.449 2025.05.29 01:21:40.166 2025.05.29 00:22:08.960 2025.05.29 00:22:09.410
20 6.0.0.791 2025.05.27 02db8 P P 688 452 2025.05.28 01:21:39.915 2025.05.28 01:21:40.603 2025.05.28 00:22:07.850 2025.05.28 00:22:08.302
21 6.0.0.789 2025.05.21 64051 P P 687 458 2025.05.25 01:21:50.576 2025.05.25 01:21:51.263 2025.05.25 00:22:14.009 2025.05.25 00:22:14.467
22 6.0.0.787 2025.05.20 230ad P P 717 453 2025.05.21 01:20:42.762 2025.05.21 01:20:43.479 2025.05.21 00:22:05.651 2025.05.21 00:22:06.104
23 6.0.0.783 2025.05.12 37320 P P 678 446 2025.05.19 01:20:53.012 2025.05.19 01:20:53.690 2025.05.19 00:22:07.682 2025.05.19 00:22:08.128
24 6.0.0.779 2025.05.11 136fa P P 728 450 2025.05.12 01:22:18.913 2025.05.12 01:22:19.641 2025.05.12 00:22:16.819 2025.05.12 00:22:17.269
25 6.0.0.778 2025.05.07 d735e P P 725 441 2025.05.11 01:22:00.251 2025.05.11 01:22:00.976 2025.05.11 00:22:13.697 2025.05.11 00:22:14.138
26 6.0.0.776 2025.05.06 007cd P P 693 437 2025.05.07 01:21:13.982 2025.05.07 01:21:14.675 2025.05.07 00:22:11.305 2025.05.07 00:22:11.742
27 6.0.0.770 2025.05.05 82c4a P P 689 457 2025.05.06 01:21:51.387 2025.05.06 01:21:52.076 2025.05.06 00:22:15.780 2025.05.06 00:22:16.237
28 6.0.0.767 2025.05.01 cdd29 P P 688 462 2025.05.02 01:22:22.714 2025.05.02 01:22:23.402 2025.05.02 00:22:24.243 2025.05.02 00:22:24.705
29 6.0.0.762 2025.04.30 5cb15 P P 685 456 2025.05.01 01:21:14.827 2025.05.01 01:21:15.512 2025.05.01 00:22:25.643 2025.05.01 00:22:26.099
30 6.0.0.755 2025.04.29 739c6 P P 682 460 2025.04.30 01:21:10.048 2025.04.30 01:21:10.730 2025.04.30 00:22:14.922 2025.04.30 00:22:15.382
31 6.0.0.753 2025.04.27 29ab3 P P 717 459 2025.04.29 01:21:22.445 2025.04.29 01:21:23.162 2025.04.29 00:22:28.829 2025.04.29 00:22:29.288
32 6.0.0.745 2025.04.21 78ad8 P P 715 458 2025.04.26 01:22:07.413 2025.04.26 01:22:08.128 2025.04.26 00:22:10.101 2025.04.26 00:22:10.559
33 6.0.0.744 2025.04.19 e883a P P 716 479 2025.04.20 01:21:38.784 2025.04.20 01:21:39.500 2025.04.20 00:22:17.560 2025.04.20 00:22:18.039
34 6.0.0.742 2025.04.17 abc3b P P 725 451 2025.04.19 01:21:18.835 2025.04.19 01:21:19.560 2025.04.19 00:22:09.575 2025.04.19 00:22:10.026
35 6.0.0.737 2025.04.16 fe52b P P 722 460 2025.04.17 01:22:04.272 2025.04.17 01:22:04.994 2025.04.17 00:22:11.042 2025.04.17 00:22:11.502
36 6.0.0.736 2025.04.14 3e6be P P 725 441 2025.04.15 01:21:58.316 2025.04.15 01:21:59.041 2025.04.15 00:22:18.295 2025.04.15 00:22:18.736
37 6.0.0.735 2025.04.13 6635c P P 720 447 2025.04.14 01:22:01.133 2025.04.14 01:22:01.853 2025.04.14 00:22:07.738 2025.04.14 00:22:08.185
38 6.0.0.734 2025.04.12 e2fd1 P P 687 437 2025.04.13 01:20:20.754 2025.04.13 01:20:21.441 2025.04.13 00:22:24.345 2025.04.13 00:22:24.782
39 6.0.0.730 2025.04.11 240b8 P P 719 464 2025.04.12 01:25:20.789 2025.04.12 01:25:21.508 2025.04.12 00:22:17.019 2025.04.12 00:22:17.483
40 6.0.0.726 2025.04.10 d79c6 P P 735 485 2025.04.11 01:25:11.402 2025.04.11 01:25:12.137 2025.04.11 00:22:21.921 2025.04.11 00:22:22.406
41 6.0.0.725 2025.04.09 a2b05 P P 755 457 2025.04.10 01:25:07.884 2025.04.10 01:25:08.639 2025.04.10 00:22:09.803 2025.04.10 00:22:10.260
42 6.0.0.722 2025.04.08 a8b86 P P 721 468 2025.04.09 01:21:39.957 2025.04.09 01:21:40.678 2025.04.09 00:22:13.765 2025.04.09 00:22:14.233
43 6.0.0.719 2025.04.06 90fd9 P P 747 456 2025.04.08 01:22:05.810 2025.04.08 01:22:06.557 2025.04.08 00:22:11.155 2025.04.08 00:22:11.611
44 6.0.0.717 2025.04.04 53d70 P P 749 451 2025.04.05 01:21:58.294 2025.04.05 01:21:59.043 2025.04.05 00:22:14.370 2025.04.05 00:22:14.821
45 6.0.0.716 2025.04.03 fc636 P P 722 454 2025.04.04 01:22:06.320 2025.04.04 01:22:07.042 2025.04.04 00:22:15.960 2025.04.04 00:22:16.414
46 6.0.0.715 2025.04.02 907ed P P 756 443 2025.04.03 01:22:03.898 2025.04.03 01:22:04.654 2025.04.03 00:22:11.871 2025.04.03 00:22:12.314
47 6.0.0.710 2025.04.01 40651 P P 727 487 2025.04.02 01:22:21.937 2025.04.02 01:22:22.664 2025.04.02 00:22:20.587 2025.04.02 00:22:21.074
48 6.0.0.708 2025.03.31 cb069 P P 729 449 2025.04.01 01:21:34.677 2025.04.01 01:21:35.406 2025.04.01 00:22:10.794 2025.04.01 00:22:11.243
49 6.0.0.707 2025.03.28 4bd4f P P 751 454 2025.03.31 01:21:34.286 2025.03.31 01:21:35.037 2025.03.31 00:22:11.088 2025.03.31 00:22:11.542
50 6.0.0.702 2025.03.27 86f4d P P 754 470 2025.03.28 01:38:22.873 2025.03.28 01:38:23.627 2025.03.28 00:22:28.720 2025.03.28 00:22:29.190
51 6.0.0.698 2025.03.26 d72a7 P P 767 477 2025.03.27 15:03:48.503 2025.03.27 15:03:49.270 2025.03.27 14:02:04.269 2025.03.27 14:02:04.746
52 6.0.0.693 2025.03.25 8aac2 P P 779 483 2025.03.26 01:24:15.962 2025.03.26 01:24:16.741 2025.03.26 00:22:29.938 2025.03.26 00:22:30.421
53 6.0.0.693 2025.03.24 0b559 P P 772 495 2025.03.25 01:24:16.629 2025.03.25 01:24:17.401 2025.03.25 00:22:32.834 2025.03.25 00:22:33.329
54 6.0.0.687 2025.03.22 730aa P P 721 481 2025.03.24 01:24:47.719 2025.03.24 01:24:48.440 2025.03.24 00:22:35.289 2025.03.24 00:22:35.770
55 6.0.0.686 2025.03.20 71bf6 P P 727 470 2025.03.21 01:22:15.466 2025.03.21 01:22:16.193 2025.03.21 00:22:13.688 2025.03.21 00:22:14.158
56 6.0.0.685 2025.03.19 a8577 P P 717 489 2025.03.20 01:22:36.400 2025.03.20 01:22:37.117 2025.03.20 00:22:29.995 2025.03.20 00:22:30.484
57 6.0.0.680 2025.03.18 90d29 P P 755 451 2025.03.19 01:22:46.301 2025.03.19 01:22:47.056 2025.03.19 00:22:32.776 2025.03.19 00:22:33.227
58 6.0.0.677 2025.03.16 c0a60 P P 721 460 2025.03.18 01:21:04.450 2025.03.18 01:21:05.171 2025.03.18 00:22:15.700 2025.03.18 00:22:16.160
59 6.0.0.676 2025.03.15 11cfb P P 765 455 2025.03.16 01:20:03.927 2025.03.16 01:20:04.692 2025.03.16 00:22:08.430 2025.03.16 00:22:08.885
60 6.0.0.674 2025.03.14 7d82c P P 723 447 2025.03.15 01:19:08.597 2025.03.15 01:19:09.320 2025.03.15 00:22:07.644 2025.03.15 00:22:08.091
61 6.0.0.673 2025.03.13 40f5b P P 719 485 2025.03.14 13:50:29.531 2025.03.14 13:50:30.250 2025.03.14 12:52:14.919 2025.03.14 12:52:15.404
62 6.0.0.671 2025.03.12 a4fff P P 797 487 2025.03.13 01:23:02.337 2025.03.13 01:23:03.134 2025.03.13 00:22:27.959 2025.03.13 00:22:28.446
63 6.0.0.663 2025.03.11 65970 P P 731 458 2025.03.12 01:22:46.035 2025.03.12 01:22:46.766 2025.03.12 00:22:27.466 2025.03.12 00:22:27.924
64 6.0.0.661 2025.03.07 b9869 P P 781 497 2025.03.11 01:23:00.292 2025.03.11 01:23:01.073 2025.03.11 00:22:22.082 2025.03.11 00:22:22.579
65 6.0.0.660 2025.03.04 a6700 P P 743 490 2025.03.06 01:22:46.518 2025.03.06 01:22:47.261 2025.03.06 00:22:32.013 2025.03.06 00:22:32.503
66 6.0.0.658 2025.03.03 f15f8 P P 759 526 2025.03.04 01:21:13.662 2025.03.04 01:21:14.421 2025.03.04 00:22:22.950 2025.03.04 00:22:23.476
67 6.0.0.656 2025.02.27 25fb4 P P 722 466 2025.03.03 01:21:28.071 2025.03.03 01:21:28.793 2025.03.03 00:22:17.414 2025.03.03 00:22:17.880
68 6.0.0.655 2025.02.25 6e3e0 P P 811 479 2025.02.27 01:21:56.581 2025.02.27 01:21:57.392 2025.02.27 00:22:28.786 2025.02.27 00:22:29.265
69 6.0.0.654 2025.02.24 b7141 P P 714 469 2025.02.25 01:20:09.086 2025.02.25 01:20:09.800 2025.02.25 00:22:26.762 2025.02.25 00:22:27.231
70 6.0.0.652 2025.02.22 22662 P P 719 465 2025.02.24 01:19:14.478 2025.02.24 01:19:15.197 2025.02.24 00:22:07.213 2025.02.24 00:22:07.678
71 6.0.0.647 2025.02.21 9fccb P P 716 452 2025.02.22 01:18:44.242 2025.02.22 01:18:44.958 2025.02.22 00:21:59.980 2025.02.22 00:22:00.432
72 6.0.0.640 2025.02.19 9b8ac P P 717 459 2025.02.20 01:19:18.248 2025.02.20 01:19:18.965 2025.02.20 00:22:11.016 2025.02.20 00:22:11.475
73 6.0.0.639 2025.02.18 201a4 P P 777 458 2025.02.19 01:20:15.693 2025.02.19 01:20:16.470 2025.02.19 00:22:38.519 2025.02.19 00:22:38.977
74 6.0.0.637 2025.02.12 6d0f5 P P 749 474 2025.02.14 01:20:50.697 2025.02.14 01:20:51.446 2025.02.14 00:22:24.737 2025.02.14 00:22:25.211
75 6.0.0.636 2025.02.11 0424f P P 729 510 2025.02.12 01:20:25.939 2025.02.12 01:20:26.668 2025.02.12 00:22:17.091 2025.02.12 00:22:17.601
76 6.0.0.635 2025.02.10 f640f P P 779 464 2025.02.11 01:19:52.367 2025.02.11 01:19:53.146 2025.02.11 00:22:09.236 2025.02.11 00:22:09.700
77 6.0.0.629 2025.02.07 194f9 P P 722 465 2025.02.08 01:19:50.236 2025.02.08 01:19:50.958 2025.02.08 00:22:11.240 2025.02.08 00:22:11.705
78 6.0.0.628 2025.02.06 859d5 P P 727 456 2025.02.07 10:17:14.530 2025.02.07 10:17:15.257 2025.02.07 09:13:05.580 2025.02.07 09:13:06.036
79 6.0.0.621 2025.02.05 34fe7 P P 735 458 2025.02.07 01:27:11.149 2025.02.07 01:27:11.884 2025.02.07 00:22:15.146 2025.02.07 00:22:15.604
80 6.0.0.609 2025.02.04 76d57 P P 755 452 2025.02.05 01:26:57.372 2025.02.05 01:26:58.127 2025.02.05 00:22:29.559 2025.02.05 00:22:30.011
81 6.0.0.607 2025.02.03 1985b P P 726 458 2025.02.04 01:26:45.764 2025.02.04 01:26:46.490 2025.02.04 00:22:13.158 2025.02.04 00:22:13.616
82 6.0.0.601 2025.02.01 6af07 P P 726 462 2025.02.02 01:19:55.167 2025.02.02 01:19:55.893 2025.02.02 00:22:19.003 2025.02.02 00:22:19.465
83 6.0.0.600 2025.01.27 188de P P 724 451 2025.01.28 01:19:49.274 2025.01.28 01:19:49.998 2025.01.28 00:22:05.376 2025.01.28 00:22:05.827
84 6.0.0.599 2025.01.25 ba588 P P 743 465 2025.01.26 01:19:30.707 2025.01.26 01:19:31.450 2025.01.26 00:22:04.989 2025.01.26 00:22:05.454
85 6.0.0.598 2025.01.23 ddbc3 P P 727 476 2025.01.25 11:07:46.644 2025.01.25 11:07:47.371 2025.01.25 10:09:43.288 2025.01.25 10:09:43.764
86 6.0.0.595 2025.01.22 e62f3 P P 727 468 2025.01.23 01:19:37.763 2025.01.23 01:19:38.490 2025.01.23 00:22:05.103 2025.01.23 00:22:05.571
87 6.0.0.594 2025.01.21 47fb6 P P 712 459 2025.01.22 01:19:32.905 2025.01.22 01:19:33.617 2025.01.22 00:22:03.715 2025.01.22 00:22:04.174
88 6.0.0.590 2025.01.20 3d7c0 P P 721 458 2025.01.21 01:19:49.916 2025.01.21 01:19:50.637 2025.01.21 00:22:05.189 2025.01.21 00:22:05.647
89 6.0.0.588 2025.01.19 b1c4e P P 744 471 2025.01.20 01:19:15.066 2025.01.20 01:19:15.810 2025.01.20 00:22:12.594 2025.01.20 00:22:13.065
90 6.0.0.587 2025.01.18 63e6e P P 764 457 2025.01.19 01:19:01.141 2025.01.19 01:19:01.905 2025.01.19 00:21:59.311 2025.01.19 00:21:59.768
91 6.0.0.585 2025.01.16 2d6bb P P 703 469 2025.01.18 01:19:01.267 2025.01.18 01:19:01.970 2025.01.18 00:22:34.652 2025.01.18 00:22:35.121
92 6.0.0.584 2025.01.15 a0aa2 P P 757 493 2025.01.16 01:20:33.715 2025.01.16 01:20:34.472 2025.01.16 00:22:14.874 2025.01.16 00:22:15.367
93 6.0.0.581 2025.01.15 69690 P P 786 453 2025.01.15 17:29:58.804 2025.01.15 17:29:59.590 2025.01.15 16:31:47.443 2025.01.15 16:31:47.896
94 6.0.0.581 2025.01.14 21e9e P P 802 459 2025.01.15 01:20:25.193 2025.01.15 01:20:25.995 2025.01.15 00:21:57.866 2025.01.15 00:21:58.325
95 6.0.0.577 2025.01.14 91dce P P 737 453 2025.01.14 16:41:23.608 2025.01.14 16:41:24.345 2025.01.14 15:43:35.444 2025.01.14 15:43:35.897
96 6.0.0.577 2025.01.13 7e293 P P 731 468 2025.01.14 11:04:25.450 2025.01.14 11:04:26.181 2025.01.14 10:06:58.718 2025.01.14 10:06:59.186
97 6.0.0.576 2025.01.12 05898 F F 1131 851 2025.01.13 01:20:49.421 2025.01.13 01:20:50.552 2025.01.13 00:22:21.042 2025.01.13 00:22:21.893
98 6.0.0.573 2025.01.10 c20f3 F F 1097 851 2025.01.11 01:20:49.057 2025.01.11 01:20:50.154 2025.01.11 00:22:22.174 2025.01.11 00:22:23.025
99 6.0.0.571 2024.12.31 81bba P P 746 461 2025.01.01 01:20:08.139 2025.01.01 01:20:08.885 2025.01.01 00:22:15.392 2025.01.01 00:22:15.853
100 6.0.0.570 2024.12.30 c3c8d P P 733 475 2024.12.31 01:20:27.487 2024.12.31 01:20:28.220 2024.12.31 00:22:30.529 2024.12.31 00:22:31.004
101 6.0.0.565 2024.12.28 5fc59 P P 821 456 2024.12.29 17:15:40.680 2024.12.29 17:15:41.501 2024.12.29 16:17:56.170 2024.12.29 16:17:56.626
102 6.0.0.564 2024.12.26 12514 P P 729 458 2024.12.27 01:19:58.567 2024.12.27 01:19:59.296 2024.12.27 00:22:19.384 2024.12.27 00:22:19.842
103 6.0.0.560 2024.12.25 fa83e P P 783 466 2024.12.26 01:20:02.061 2024.12.26 01:20:02.844 2024.12.26 00:22:09.798 2024.12.26 00:22:10.264
104 6.0.0.559 2024.12.23 cc800 P P 769 457 2024.12.25 01:20:07.841 2024.12.25 01:20:08.610 2024.12.25 00:22:16.018 2024.12.25 00:22:16.475
105 6.0.0.556 2024.12.22 a0404 P P 732 472 2024.12.23 01:19:40.943 2024.12.23 01:19:41.675 2024.12.23 00:22:21.984 2024.12.23 00:22:22.456
106 6.0.0.555 2024.12.19 6990a P P 739 459 2024.12.21 12:14:35.945 2024.12.21 12:14:36.684 2024.12.21 11:16:37.698 2024.12.21 11:16:38.157
107 6.0.0.553 2024.12.17 d1f8a P P 726 451 2024.12.18 01:19:34.361 2024.12.18 01:19:35.087 2024.12.18 00:22:40.851 2024.12.18 00:22:41.302
108 6.0.0.552 2024.12.11 85e25 P P 727 455 2024.12.16 01:19:11.155 2024.12.16 01:19:11.882 2024.12.16 00:22:18.633 2024.12.16 00:22:19.088
109 6.0.0.550 2024.12.10 b37ac P P 736 458 2024.12.11 01:20:03.966 2024.12.11 01:20:04.702 2024.12.11 00:22:17.455 2024.12.11 00:22:17.913
110 6.0.0.548 2024.12.08 2cc77 P P 757 502 2024.12.09 01:21:59.416 2024.12.09 01:22:00.173 2024.12.09 00:23:42.775 2024.12.09 00:23:43.277
111 6.0.0.544 2024.12.05 96943 P P 841 474 2024.12.06 01:18:53.485 2024.12.06 01:18:54.326 2024.12.06 00:22:26.343 2024.12.06 00:22:26.817
112 6.0.0.543 2024.12.03 30b77 P P 728 474 2024.12.04 01:19:16.620 2024.12.04 01:19:17.348 2024.12.04 00:22:18.826 2024.12.04 00:22:19.300
113 6.0.0.540 2024.12.02 4a1f4 P P 726 484 2024.12.03 01:18:44.408 2024.12.03 01:18:45.134 2024.12.03 00:22:33.904 2024.12.03 00:22:34.388
114 6.0.0.539 2024.11.28 1f283 P P 738 454 2024.11.30 01:18:12.689 2024.11.30 01:18:13.427 2024.11.30 00:22:16.126 2024.11.30 00:22:16.580
115 6.0.0.535 2024.11.27 6551a P P 763 472 2024.11.28 01:17:13.544 2024.11.28 01:17:14.307 2024.11.28 00:22:04.328 2024.11.28 00:22:04.800
116 6.0.0.535 2024.11.26 77b95 P P 767 454 2024.11.27 01:17:32.686 2024.11.27 01:17:33.453 2024.11.27 00:21:55.414 2024.11.27 00:21:55.868
117 6.0.0.534 2024.11.25 e9584 P P 729 458 2024.11.26 01:17:38.225 2024.11.26 01:17:38.954 2024.11.26 00:22:05.466 2024.11.26 00:22:05.924
118 6.0.0.533 2024.11.17 933ac P P 760 474 2024.11.22 01:17:50.016 2024.11.22 01:17:50.776 2024.11.22 00:22:06.436 2024.11.22 00:22:06.910
119 6.0.0.532 2024.11.17 1a471 P P 725 472 2024.11.17 13:52:06.043 2024.11.17 13:52:06.768 2024.11.17 12:56:59.818 2024.11.17 12:57:00.290
120 6.0.0.532 2024.11.16 9e263 P P 728 474 2024.11.17 01:16:39.424 2024.11.17 01:16:40.152 2024.11.17 00:21:58.848 2024.11.17 00:21:59.322
121 6.0.0.530 2024.11.15 49804 P P 719 484 2024.11.16 01:16:16.387 2024.11.16 01:16:17.106 2024.11.16 00:22:20.035 2024.11.16 00:22:20.519
122 6.0.0.528 2024.11.14 9625b P P 747 472 2024.11.15 01:18:36.693 2024.11.15 01:18:37.440 2024.11.15 00:22:04.825 2024.11.15 00:22:05.297
123 6.0.0.526 2024.11.12 65b80 P P 735 545 2024.11.14 01:18:18.996 2024.11.14 01:18:19.731 2024.11.14 00:22:05.793 2024.11.14 00:22:06.338
124 6.0.0.523 2024.11.08 8ca23 P P 726 492 2024.11.11 01:17:09.777 2024.11.11 01:17:10.503 2024.11.11 00:22:09.047 2024.11.11 00:22:09.539
125 6.0.0.520 2024.11.08 52657 P P 719 469 2024.11.08 17:51:38.296 2024.11.08 17:51:39.015 2024.11.08 16:57:18.900 2024.11.08 16:57:19.369
126 6.0.0.520 2024.11.07 4eefa P P 738 520 2024.11.08 01:16:00.701 2024.11.08 01:16:01.439 2024.11.08 00:22:01.913 2024.11.08 00:22:02.433
127 6.0.0.516 2024.11.04 b0c36 P P 730 483 2024.11.05 01:17:11.604 2024.11.05 01:17:12.334 2024.11.05 00:21:54.842 2024.11.05 00:21:55.325
128 6.0.0.515 2024.10.30 d53f3 P P 750 485 2024.11.04 01:17:00.540 2024.11.04 01:17:01.290 2024.11.04 00:22:12.145 2024.11.04 00:22:12.630
129 6.0.0.512 2024.10.29 833ef P P 739 458 2024.10.30 01:18:30.963 2024.10.30 01:18:31.702 2024.10.30 00:22:11.556 2024.10.30 00:22:12.014
130 6.0.0.511 2024.10.26 c4bc9 P P 749 456 2024.10.29 01:18:01.197 2024.10.29 01:18:01.946 2024.10.29 00:21:53.686 2024.10.29 00:21:54.142
131 6.0.0.508 2024.10.24 a8f5b P P 767 467 2024.10.26 09:25:05.875 2024.10.26 09:25:06.642 2024.10.26 08:28:44.209 2024.10.26 08:28:44.676
132 6.0.0.502 2024.10.22 6bfd7 P P 765 473 2024.10.23 01:17:46.610 2024.10.23 01:17:47.375 2024.10.23 00:22:08.171 2024.10.23 00:22:08.644
133 6.0.0.500 2024.10.21 be565 P P 731 462 2024.10.22 01:18:07.424 2024.10.22 01:18:08.155 2024.10.22 00:22:07.445 2024.10.22 00:22:07.907
134 6.0.0.499 2024.10.19 6214b P P 780 472 2024.10.20 01:17:38.722 2024.10.20 01:17:39.502 2024.10.20 00:21:55.289 2024.10.20 00:21:55.761
135 6.0.0.498 2024.10.18 591a7 P P 741 458 2024.10.19 01:17:11.074 2024.10.19 01:17:11.815 2024.10.19 00:21:58.428 2024.10.19 00:21:58.886
136 6.0.0.494 2024.10.17 042ce P P 762 459 2024.10.18 01:17:41.414 2024.10.18 01:17:42.176 2024.10.18 00:22:02.822 2024.10.18 00:22:03.281
137 6.0.0.491 2024.10.14 dc5fb P P 741 465 2024.10.15 01:17:06.762 2024.10.15 01:17:07.503 2024.10.15 00:21:59.645 2024.10.15 00:22:00.110
138 6.0.0.489 2024.10.11 2ba59 P P 732 481 2024.10.12 01:16:44.251 2024.10.12 01:16:44.983 2024.10.12 00:21:56.242 2024.10.12 00:21:56.723
139 6.0.0.488 2024.10.09 1c93e P P 727 452 2024.10.10 01:17:05.516 2024.10.10 01:17:06.243 2024.10.10 00:22:04.772 2024.10.10 00:22:05.224
140 6.0.0.487 2024.10.06 065a3 P P 777 471 2024.10.07 01:17:58.823 2024.10.07 01:17:59.600 2024.10.07 00:22:00.399 2024.10.07 00:22:00.870
141 6.0.0.485 2024.10.05 9f5f7 P P 735 456 2024.10.06 01:17:51.057 2024.10.06 01:17:51.792 2024.10.06 00:22:10.867 2024.10.06 00:22:11.323
142 6.0.0.485 2024.10.04 e95c1 P P 755 474 2024.10.05 01:17:17.906 2024.10.05 01:17:18.661 2024.10.05 00:21:53.264 2024.10.05 00:21:53.738
143 6.0.0.483 2024.10.02 5e5ae P P 742 469 2024.10.03 01:18:17.756 2024.10.03 01:18:18.498 2024.10.03 00:22:16.205 2024.10.03 00:22:16.674
144 6.0.0.478 2024.09.30 b5010 P P 784 467 2024.10.01 01:17:29.752 2024.10.01 01:17:30.536 2024.10.01 00:21:56.349 2024.10.01 00:21:56.816
145 6.0.0.474 2024.09.26 e4efb P P 740 456 2024.09.30 01:17:23.387 2024.09.30 01:17:24.127 2024.09.30 00:22:07.984 2024.09.30 00:22:08.440
146 6.0.0.471 2024.09.25 dab71 P P 728 470 2024.09.26 01:17:36.287 2024.09.26 01:17:37.015 2024.09.26 00:21:59.437 2024.09.26 00:21:59.907
147 6.0.0.471 2024.09.24 01b51 P P 730 462 2024.09.25 01:17:53.429 2024.09.25 01:17:54.159 2024.09.25 00:22:04.759 2024.09.25 00:22:05.221
148 6.0.0.470 2024.09.23 77cc0 P P 742 465 2024.09.24 01:17:35.509 2024.09.24 01:17:36.251 2024.09.24 00:22:01.189 2024.09.24 00:22:01.654
149 6.0.0.467 2024.09.21 ea0b8 P P 734 495 2024.09.23 01:18:39.989 2024.09.23 01:18:40.723 2024.09.23 00:22:19.733 2024.09.23 00:22:20.228
150 6.0.0.466 2024.09.20 32dc6 P P 722 477 2024.09.21 01:17:10.939 2024.09.21 01:17:11.661 2024.09.21 00:21:57.953 2024.09.21 00:21:58.430
151 6.0.0.461 2024.09.17 2c895 P P 731 469 2024.09.18 01:16:29.556 2024.09.18 01:16:30.287 2024.09.18 00:21:55.517 2024.09.18 00:21:55.986
152 6.0.0.460 2024.09.11 3c253 P P 766 448 2024.09.17 01:16:46.376 2024.09.17 01:16:47.142 2024.09.17 00:21:55.086 2024.09.17 00:21:55.534
153 6.0.0.457 2024.09.09 fdc6f P P 776 463 2024.09.10 01:17:09.881 2024.09.10 01:17:10.657 2024.09.10 00:21:50.208 2024.09.10 00:21:50.671
154 6.0.0.455 2024.09.07 500d8 P P 731 488 2024.09.08 01:17:34.045 2024.09.08 01:17:34.776 2024.09.08 00:22:12.075 2024.09.08 00:22:12.563
155 6.0.0.454 2024.09.05 4d70f P P 767 449 2024.09.06 01:17:41.231 2024.09.06 01:17:41.998 2024.09.06 00:21:51.310 2024.09.06 00:21:51.759
156 6.0.0.452 2024.09.04 9ff9c P P 733 459 2024.09.05 01:17:10.647 2024.09.05 01:17:11.380 2024.09.05 00:21:53.046 2024.09.05 00:21:53.505
157 6.0.0.450 2024.09.02 27124 P P 732 470 2024.09.04 01:17:42.430 2024.09.04 01:17:43.162 2024.09.04 00:21:57.104 2024.09.04 00:21:57.574
158 6.0.0.447 2024.09.01 901b4 P P 622 396 2024.09.02 01:07:12.326 2024.09.02 01:07:12.948 2024.09.02 00:11:51.778 2024.09.02 00:11:52.174
159 6.0.0.446 2024.08.30 fe1b2 P P 625 401 2024.09.01 01:05:54.339 2024.09.01 01:05:54.964 2024.09.01 00:11:50.953 2024.09.01 00:11:51.354
160 6.0.0.444 2024.08.28 785d4 P P 616 426 2024.08.30 01:06:10.743 2024.08.30 01:06:11.359 2024.08.30 00:12:06.310 2024.08.30 00:12:06.736
161 6.0.0.442 2024.08.21 4a68f P P 608 402 2024.08.28 01:05:57.932 2024.08.28 01:05:58.540 2024.08.28 00:11:59.202 2024.08.28 00:11:59.604
162 6.0.0.441 2024.08.20 75042 P P 612 403 2024.08.21 01:05:06.704 2024.08.21 01:05:07.316 2024.08.21 00:12:07.432 2024.08.21 00:12:07.835
163 6.0.0.438 2024.08.16 088b5 P P 672 448 2024.08.19 01:06:55.584 2024.08.19 01:06:56.256 2024.08.19 00:12:06.728 2024.08.19 00:12:07.176
164 6.0.0.437 2024.08.14 3c88b P P 687 460 2024.08.16 01:08:27.696 2024.08.16 01:08:28.383 2024.08.16 00:12:09.828 2024.08.16 00:12:10.288
165 6.0.0.436 2024.08.13 b8e75 P P 692 448 2024.08.14 01:07:40.579 2024.08.14 01:07:41.271 2024.08.14 00:12:10.327 2024.08.14 00:12:10.775
166 6.0.0.432 2024.08.11 e82ac P P 681 440 2024.08.13 01:07:07.519 2024.08.13 01:07:08.200 2024.08.13 00:12:08.811 2024.08.13 00:12:09.251
167 6.0.0.431 2024.08.11 16bb1 P P 690 450 2024.08.11 17:12:16.055 2024.08.11 17:12:16.745 2024.08.11 16:17:13.954 2024.08.11 16:17:14.404
168 6.0.0.431 2024.08.09 de5a7 P P 684 446 2024.08.10 16:45:56.381 2024.08.10 16:45:57.065 2024.08.10 15:51:25.964 2024.08.10 15:51:26.410
169 6.0.0.428 2024.08.08 9191b P P 683 449 2024.08.10 01:06:30.620 2024.08.10 01:06:31.303 2024.08.10 00:12:03.432 2024.08.10 00:12:03.881
170 6.0.0.423 2024.08.07 33b41 P P 772 448 2024.08.08 08:05:48.403 2024.08.08 08:05:49.175 2024.08.08 07:11:28.180 2024.08.08 07:11:28.628
171 6.0.0.421 2024.08.06 ed60d P P 502 345 2024.08.07 01:03:59.174 2024.08.07 01:03:59.676 2024.08.07 00:11:23.231 2024.08.07 00:11:23.576
172 6.0.0.419 2024.08.05 3505a P P 510 337 2024.08.06 01:02:40.185 2024.08.06 01:02:40.695 2024.08.06 00:11:47.738 2024.08.06 00:11:48.075
173 6.0.0.409 2024.08.02 ec18f P P 519 338 2024.08.05 01:01:44.345 2024.08.05 01:01:44.864 2024.08.05 00:11:17.918 2024.08.05 00:11:18.256
174 6.0.0.406 2024.08.01 b20be P P 517 329 2024.08.02 01:01:01.232 2024.08.02 01:01:01.749 2024.08.02 00:11:16.707 2024.08.02 00:11:17.036
175 6.0.0.405 2024.07.31 a62ac P P 597 454 2024.08.01 01:07:50.673 2024.08.01 01:07:51.270 2024.08.01 00:12:27.723 2024.08.01 00:12:28.177
176 6.0.0.403 2024.07.29 30f03 P P 538 337 2024.07.30 01:02:59.883 2024.07.30 01:03:00.421 2024.07.30 00:11:17.882 2024.07.30 00:11:18.219
177 6.0.0.401 2024.07.26 24e41 P P 526 333 2024.07.27 01:02:26.219 2024.07.27 01:02:26.745 2024.07.27 00:11:12.014 2024.07.27 00:11:12.347
178 6.0.0.400 2024.07.24 5bb78 P P 514 340 2024.07.25 01:02:57.147 2024.07.25 01:02:57.661 2024.07.25 00:11:15.149 2024.07.25 00:11:15.489
179 6.0.0.398 2024.07.23 85b18 P P 524 340 2024.07.24 01:26:02.729 2024.07.24 01:26:03.253 2024.07.24 00:11:13.673 2024.07.24 00:11:14.013
180 6.0.0.397 2024.07.22 c734c P P 529 343 2024.07.23 01:02:54.707 2024.07.23 01:02:55.236 2024.07.23 00:11:20.269 2024.07.23 00:11:20.612
181 6.0.0.396 2024.07.13 cf952 P P 523 349 2024.07.22 01:02:52.568 2024.07.22 01:02:53.091 2024.07.22 00:11:22.914 2024.07.22 00:11:23.263
182 6.0.0.395 2024.07.10 845f4 P P 500 329 2024.07.13 01:02:55.863 2024.07.13 01:02:56.363 2024.07.13 00:11:29.434 2024.07.13 00:11:29.763
183 6.0.0.392 2024.07.09 ea301 P P 522 362 2024.07.10 01:04:41.185 2024.07.10 01:04:41.707 2024.07.10 00:11:36.973 2024.07.10 00:11:37.335
184 6.0.0.391 2024.07.08 7d50c P P 542 336 2024.07.09 01:05:00.579 2024.07.09 01:05:01.121 2024.07.09 00:11:29.468 2024.07.09 00:11:29.804
185 6.0.0.389 2024.07.05 cc71c P P 537 339 2024.07.06 01:05:24.025 2024.07.06 01:05:24.562 2024.07.06 00:11:37.474 2024.07.06 00:11:37.813
186 6.0.0.388 2024.06.30 e5700 P P 581 332 2024.07.01 01:05:30.537 2024.07.01 01:05:31.118 2024.07.01 00:11:34.776 2024.07.01 00:11:35.108
187 6.0.0.387 2024.06.27 7c28a P P 583 329 2024.06.28 01:05:35.136 2024.06.28 01:05:35.719 2024.06.28 00:11:30.077 2024.06.28 00:11:30.406
188 6.0.0.386 2024.06.23 7c57f P P 526 339 2024.06.24 01:02:36.481 2024.06.24 01:02:37.007 2024.06.24 00:11:12.836 2024.06.24 00:11:13.175
189 6.0.0.384 2024.06.21 24d99 P P 526 355 2024.06.22 01:01:07.006 2024.06.22 01:01:07.532 2024.06.22 00:11:09.970 2024.06.22 00:11:10.325
190 6.0.0.374 2024.06.13 0097d P P 519 337 2024.06.21 17:47:51.254 2024.06.21 17:47:51.773 2024.06.21 16:57:59.366 2024.06.21 16:57:59.703
191 6.0.0.373 2024.06.09 363f0 P P 484 266 2024.06.12 23:04:39.707 2024.06.12 23:04:40.191 2024.06.12 22:20:23.602 2024.06.12 22:20:23.868
192 6.0.0.372 2024.06.08 9e7f2 P P 454 265 2024.06.09 18:32:58.462 2024.06.09 18:32:58.916 2024.06.09 17:49:21.345 2024.06.09 17:49:21.610
193 6.0.0.368 2024.06.03 25f3e P P 532 312 2024.06.15 11:24:27.472 2024.06.15 11:24:28.004 2024.06.15 10:36:29.700 2024.06.15 10:36:30.012
194 6.0.0.366 2024.05.28 8e46f P P 453 266 2024.06.10 19:26:45.879 2024.06.10 19:26:46.332 2024.06.10 18:42:59.688 2024.06.10 18:42:59.954
195 6.0.0.363 2024.05.28 95442 P P 453 266 2024.06.10 15:46:56.453 2024.06.10 15:46:56.906 2024.06.10 15:03:10.197 2024.06.10 15:03:10.463
196 6.0.0.363 2024.05.28 40d0b P P 453 266 2024.06.10 17:40:18.429 2024.06.10 17:40:18.882 2024.06.10 16:56:35.090 2024.06.10 16:56:35.356
197 6.0.0.362 2024.05.24 ecc49 P P 485 265 2024.05.24 23:04:35.055 2024.05.24 23:04:35.540 2024.05.24 22:20:27.412 2024.05.24 22:20:27.677
198 6.0.0.359 2024.05.23 9cb11 P P 484 266 2024.05.23 23:04:59.023 2024.05.23 23:04:59.507 2024.05.23 22:20:49.571 2024.05.23 22:20:49.837
199 6.0.0.358 2024.05.21 995dd P P 500 266 2024.05.22 23:04:42.562 2024.05.22 23:04:43.062 2024.05.22 22:20:27.572 2024.05.22 22:20:27.838
200 6.0.0.357 2024.05.18 bf6c4 P P 485 265 2024.05.20 23:04:28.717 2024.05.20 23:04:29.202 2024.05.20 22:20:26.548 2024.05.20 22:20:26.813
201 6.0.0.356 2024.05.17 eab06 P P 500 266 2024.05.17 23:04:35.984 2024.05.17 23:04:36.484 2024.05.17 22:20:49.517 2024.05.17 22:20:49.783
202 6.0.0.355 2024.05.16 8dd6e P P 484 265 2024.05.16 23:04:27.475 2024.05.16 23:04:27.959 2024.05.16 22:20:29.383 2024.05.16 22:20:29.648
203 6.0.0.354 2024.05.15 d3adc P P 484 250 2024.05.15 23:04:47.174 2024.05.15 23:04:47.658 2024.05.15 22:20:48.646 2024.05.15 22:20:48.896
204 6.0.0.351 2024.05.14 2e3e0 P P 484 266 2024.05.14 23:04:17.340 2024.05.14 23:04:17.824 2024.05.14 22:20:26.596 2024.05.14 22:20:26.862
205 6.0.0.348 2024.05.08 e1ec4 P P 500 265 2024.05.13 23:04:38.144 2024.05.13 23:04:38.644 2024.05.13 22:20:44.737 2024.05.13 22:20:45.002
206 6.0.0.346 2024.05.07 9d7de P P 500 265 2024.05.07 23:04:47.927 2024.05.07 23:04:48.427 2024.05.07 22:20:44.154 2024.05.07 22:20:44.419
207 6.0.0.345 2024.05.06 154a0 P P 500 265 2024.05.06 23:04:21.868 2024.05.06 23:04:22.368 2024.05.06 22:20:24.698 2024.05.06 22:20:24.963
208 6.0.0.344 2024.05.02 b49d8 P P 485 265 2024.05.02 23:03:52.227 2024.05.02 23:03:52.712 2024.05.02 22:20:18.474 2024.05.02 22:20:18.739
209 6.0.0.342 2024.04.29 e6247 P P 484 266 2024.04.29 23:04:12.456 2024.04.29 23:04:12.940 2024.04.29 22:20:39.790 2024.04.29 22:20:40.056
210 6.0.0.339 2024.04.28 0bcba P P 500 266 2024.04.28 23:03:54.630 2024.04.28 23:03:55.130 2024.04.28 22:20:19.355 2024.04.28 22:20:19.621
211 6.0.0.336 2024.04.24 7d2ac P P 500 266 2024.04.26 23:03:56.885 2024.04.26 23:03:57.385 2024.04.26 22:20:21.990 2024.04.26 22:20:22.256
212 6.0.0.333 2024.04.23 85d98 P P 500 266 2024.04.23 23:04:23.505 2024.04.23 23:04:24.005 2024.04.23 22:20:40.160 2024.04.23 22:20:40.426
213 6.0.0.328 2024.04.22 485d0 P P 485 266 2024.04.22 23:04:00.631 2024.04.22 23:04:01.116 2024.04.22 22:20:22.739 2024.04.22 22:20:23.005
214 6.0.0.327 2024.04.19 eeed9 P P 484 265 2024.04.21 23:04:26.186 2024.04.21 23:04:26.670 2024.04.21 22:20:40.537 2024.04.21 22:20:40.802
215 6.0.0.325 2024.04.18 f5930 P P 485 266 2024.04.18 23:04:01.888 2024.04.18 23:04:02.373 2024.04.18 22:20:19.758 2024.04.18 22:20:20.024
216 6.0.0.324 2024.04.17 84ac9 P P 485 265 2024.04.17 23:04:13.463 2024.04.17 23:04:13.948 2024.04.17 22:20:42.317 2024.04.17 22:20:42.582
217 6.0.0.321 2024.04.16 eba22 P P 500 265 2024.04.16 23:03:41.939 2024.04.16 23:03:42.439 2024.04.16 22:20:22.041 2024.04.16 22:20:22.306
218 6.0.0.315 2024.04.15 4e80d P P 485 266 2024.04.15 23:04:00.419 2024.04.15 23:04:00.904 2024.04.15 22:20:37.994 2024.04.15 22:20:38.260
219 6.0.0.313 2024.04.14 b6eab P P 437 266 2024.04.14 23:03:19.205 2024.04.14 23:03:19.642 2024.04.14 22:20:39.876 2024.04.14 22:20:40.142
220 6.0.0.313 2024.04.12 aaf5f P P 438 266 2024.04.12 23:02:55.426 2024.04.12 23:02:55.864 2024.04.12 22:20:19.367 2024.04.12 22:20:19.633
221 6.0.0.312 2024.04.12 ff9f0 P P 437 265 2024.04.12 09:50:03.163 2024.04.12 09:50:03.600 2024.04.12 09:07:37.902 2024.04.12 09:07:38.167
222 6.0.0.312 2024.04.04 3496c P P 422 234 2024.04.09 23:03:39.932 2024.04.09 23:03:40.354 2024.04.09 22:20:43.330 2024.04.09 22:20:43.564
223 6.0.0.310 2024.04.03 e93f6 P P 437 250 2024.04.04 09:16:05.142 2024.04.04 09:16:05.579 2024.04.04 08:36:08.316 2024.04.04 08:36:08.566
224 6.0.0.308 2024.04.03 fa979 P P 422 219 2024.04.03 16:29:36.395 2024.04.03 16:29:36.817 2024.04.03 15:49:14.684 2024.04.03 15:49:14.903
225 6.0.0.308 2024.04.02 65562 P P 422 250 2024.04.03 00:10:21.331 2024.04.03 00:10:21.753 2024.04.02 23:30:49.135 2024.04.02 23:30:49.385
226 6.0.0.305 2024.04.01 8a4f6 P P 441 250 2024.04.02 08:22:44.500 2024.04.02 08:22:44.941 2024.04.02 07:43:11.115 2024.04.02 07:43:11.365
227 6.0.0.303 2024.03.31 ecb39 P P 421 233 2024.04.01 05:49:49.779 2024.04.01 05:49:50.200 2024.04.01 05:10:12.383 2024.04.01 05:10:12.616
228 6.0.0.301 2024.03.25 69d0a P P 421 233 2024.03.28 22:27:10.429 2024.03.28 22:27:10.850 2024.03.28 21:47:38.611 2024.03.28 21:47:38.844
229 6.0.0.299 2024.03.22 b1ba8 P P 421 218 2024.03.23 23:56:58.016 2024.03.23 23:56:58.437 2024.03.23 23:16:28.333 2024.03.23 23:16:28.551
230 6.0.0.295 2024.03.22 ef66a P P 421 218 2024.03.22 12:47:44.520 2024.03.22 12:47:44.941 2024.03.22 12:07:20.801 2024.03.22 12:07:21.019
231 6.0.0.295 2024.03.21 bf5ab P P 421 218 2024.03.21 22:07:47.689 2024.03.21 22:07:48.110 2024.03.21 21:27:14.770 2024.03.21 21:27:14.988
232 6.0.0.294 2024.03.20 bd00d P P 421 233 2024.03.21 01:10:40.306 2024.03.21 01:10:40.727 2024.03.21 00:30:18.564 2024.03.21 00:30:18.797
233 6.0.0.293 2024.03.20 fb994 P P 421 234 2024.03.20 17:43:08.188 2024.03.20 17:43:08.609 2024.03.20 17:01:55.300 2024.03.20 17:01:55.534

Elapsed time, ms. Chart for last 150 runs:

Last commits information (all timestamps in UTC):