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

Annotation type Annotation details
2 @message
assert   
    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 05:18:40.010
2025-06-26 05:18:40.018 act = <firebird.qa.plugin.Action object at [hex]>
2025-06-26 05:18:40.025 capsys = <_pytest.capture.CaptureFixture object at [hex]>
2025-06-26 05:18:40.030
2025-06-26 05:18:40.037 @pytest.mark.version('>=4.0')
2025-06-26 05:18:40.043 def test_1(act: Action, capsys):
2025-06-26 05:18:40.048 with act.db.connect() as con:
2025-06-26 05:18:40.054
2025-06-26 05:18:40.062 # 13.01.2025: test will FAIL if config parameter OptimizeForFirstRows differs from default value (i.e. is set to true).
2025-06-26 05:18:40.070 # To prevent this, we have to explicitly change appropriate session-level value:
2025-06-26 05:18:40.076 if act.is_version('<5'):
2025-06-26 05:18:40.081 pass
2025-06-26 05:18:40.086 else:
2025-06-26 05:18:40.092 con.execute_immediate('set optimize for all rows')
2025-06-26 05:18:40.097
2025-06-26 05:18:40.103 cur = con.cursor()
2025-06-26 05:18:40.111 for q_idx, q_tuple in query_map.items():
2025-06-26 05:18:40.118 test_sql, qry_comment = q_tuple[:2]
2025-06-26 05:18:40.127 ps = cur.prepare(test_sql)
2025-06-26 05:18:40.137 print(q_idx)
2025-06-26 05:18:40.144 print(test_sql)
2025-06-26 05:18:40.150 print(qry_comment)
2025-06-26 05:18:40.155 print( '\n'.join([replace_leading(s) for s in ps.detailed_plan.split('\n')]) )
2025-06-26 05:18:40.160 ps.free()
2025-06-26 05:18:40.165
2025-06-26 05:18:40.171 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 05:18:40.179 act.stdout = capsys.readouterr().out
2025-06-26 05:18:40.186 >       assert act.clean_stdout == act.clean_expected_stdout
2025-06-26 05:18:40.192 E       assert
2025-06-26 05:18:40.199 E           1000
2025-06-26 05:18:40.205 E           select txt_short from test a01 order by id
2025-06-26 05:18:40.216 E           Must NOT use refetch because length of non-key column is less than threshold
2025-06-26 05:18:40.225 E           Select Expression
2025-06-26 05:18:40.232 E           ....-> Sort (record length: 1036, key length: 8)
2025-06-26 05:18:40.238 E         - ........-> Table "TEST" as "A01" Full Scan
2025-06-26 05:18:40.243 E         + ........-> Table "PUBLIC"."TEST" as "A01" Full Scan
2025-06-26 05:18:40.252 E           1010
2025-06-26 05:18:40.257 E           select txt_broad from test a02 order by id
2025-06-26 05:18:40.263 E           MUST use refetch because length of non-key column is greater than threshold
2025-06-26 05:18:40.268 E           Select Expression
2025-06-26 05:18:40.274 E           ....-> Refetch
2025-06-26 05:18:40.280 E           ........-> Sort (record length: 28, key length: 8)
2025-06-26 05:18:40.286 E         - ............-> Table "TEST" as "A02" Full Scan
2025-06-26 05:18:40.296 E         + ............-> Table "PUBLIC"."TEST" as "A02" Full Scan
2025-06-26 05:18:40.312 E           1020
2025-06-26 05:18:40.318 E           select txt_short from test a03 order by id rows 1
2025-06-26 05:18:40.324 E           MUST use refetch regardless on length of column because ROWS <N> presents
2025-06-26 05:18:40.331 E           Select Expression
2025-06-26 05:18:40.341 E           ....-> First N Records
2025-06-26 05:18:40.350 E           ........-> Refetch
2025-06-26 05:18:40.359 E           ............-> Sort (record length: 28, key length: 8)
2025-06-26 05:18:40.371 E         - ................-> Table "TEST" as "A03" Full Scan
2025-06-26 05:18:40.385 E         + ................-> Table "PUBLIC"."TEST" as "A03" Full Scan
2025-06-26 05:18:40.405 E           2000
2025-06-26 05:18:40.418 E           select id, computed_ts_dup from test order by id
2025-06-26 05:18:40.427 E           Must NOT use refetch because computed column is based on txt_short with length < threshold
2025-06-26 05:18:40.436 E           Select Expression
2025-06-26 05:18:40.447 E           ....-> Sort (record length: 1036, key length: 8)
2025-06-26 05:18:40.456 E         - ........-> Table "TEST" Full Scan
2025-06-26 05:18:40.463 E         + ........-> Table "PUBLIC"."TEST" Full Scan
2025-06-26 05:18:40.482 E           2010
2025-06-26 05:18:40.492 E           select id, computed_tb_dup from test order by id
2025-06-26 05:18:40.500 E           MUST use refetch because computed column is based on txt_broad which has length >= threshold
2025-06-26 05:18:40.506 E           Select Expression
2025-06-26 05:18:40.516 E           ....-> Refetch
2025-06-26 05:18:40.525 E           ........-> Sort (record length: 28, key length: 8)
2025-06-26 05:18:40.532 E         - ............-> Table "TEST" Full Scan
2025-06-26 05:18:40.539 E         + ............-> Table "PUBLIC"."TEST" Full Scan
2025-06-26 05:18:40.553 E           3000
2025-06-26 05:18:40.559 E           select id from test a04 where '' in (select txt_short from test x04 where txt_short = '' order by id)
2025-06-26 05:18:40.564 E           *** not [yet] commented ***
2025-06-26 05:18:40.568 E           Sub-query (invariant)
2025-06-26 05:18:40.572 E           ....-> Filter
2025-06-26 05:18:40.577 E           ........-> Sort (record length: 1036, key length: 8)
2025-06-26 05:18:40.581 E           ............-> Filter
2025-06-26 05:18:40.585 E         - ................-> Table "TEST" as "X04" Full Scan
2025-06-26 05:18:40.590 E         + ................-> Table "PUBLIC"."TEST" as "X04" Full Scan
2025-06-26 05:18:40.598 E           Select Expression
2025-06-26 05:18:40.603 E           ....-> Filter (preliminary)
2025-06-26 05:18:40.607 E         - ........-> Table "TEST" as "A04" Full Scan
2025-06-26 05:18:40.612 E         + ........-> Table "PUBLIC"."TEST" as "A04" Full Scan
2025-06-26 05:18:40.620 E           3010
2025-06-26 05:18:40.625 E           select id from test a05 where '' in (select txt_broad from test x05 where txt_broad = '' order by id)
2025-06-26 05:18:40.629 E           *** not [yet] commented ***
2025-06-26 05:18:40.635 E           Sub-query (invariant)
2025-06-26 05:18:40.641 E           ....-> Filter
2025-06-26 05:18:40.647 E           ........-> Refetch
2025-06-26 05:18:40.653 E           ............-> Sort (record length: 28, key length: 8)
2025-06-26 05:18:40.658 E           ................-> Filter
2025-06-26 05:18:40.670 E         - ....................-> Table "TEST" as "X05" Full Scan
2025-06-26 05:18:40.682 E         + ....................-> Table "PUBLIC"."TEST" as "X05" Full Scan
2025-06-26 05:18:40.697 E           Select Expression
2025-06-26 05:18:40.704 E           ....-> Filter (preliminary)
2025-06-26 05:18:40.711 E         - ........-> Table "TEST" as "A05" Full Scan
2025-06-26 05:18:40.717 E         + ........-> Table "PUBLIC"."TEST" as "A05" Full Scan
2025-06-26 05:18:40.734 E           3020
2025-06-26 05:18:40.744 E           select id from test a06 where '' not in (select txt_short from test x06 where txt_short>'' order by id)
2025-06-26 05:18:40.751 E           *** not [yet] commented ***
2025-06-26 05:18:40.756 E           Sub-query (invariant)
2025-06-26 05:18:40.762 E           ....-> Sort (record length: 1036, key length: 8)
2025-06-26 05:18:40.768 E           ........-> Filter
2025-06-26 05:18:40.773 E         - ............-> Table "TEST" as "X06" Full Scan
2025-06-26 05:18:40.778 E         + ............-> Table "PUBLIC"."TEST" as "X06" Full Scan
2025-06-26 05:18:40.789 E           Sub-query (invariant)
2025-06-26 05:18:40.796 E           ....-> Sort (record length: 1036, key length: 8)
2025-06-26 05:18:40.802 E           ........-> Filter
2025-06-26 05:18:40.809 E         - ............-> Table "TEST" as "X06" Full Scan
2025-06-26 05:18:40.816 E         + ............-> Table "PUBLIC"."TEST" as "X06" Full Scan
2025-06-26 05:18:40.831 E           Select Expression
2025-06-26 05:18:40.838 E           ....-> Filter (preliminary)
2025-06-26 05:18:40.851 E         - ........-> Table "TEST" as "A06" Full Scan
2025-06-26 05:18:40.859 E         + ........-> Table "PUBLIC"."TEST" as "A06" Full Scan
2025-06-26 05:18:40.881 E           3030
2025-06-26 05:18:40.893 E           select id from test a07 where '' not in (select txt_broad from test x07 where txt_broad>'' order by id)
2025-06-26 05:18:40.905 E           *** not [yet] commented ***
2025-06-26 05:18:40.916 E           Sub-query (invariant)
2025-06-26 05:18:40.926 E           ....-> Refetch
2025-06-26 05:18:40.932 E           ........-> Sort (record length: 28, key length: 8)
2025-06-26 05:18:40.938 E           ............-> Filter
2025-06-26 05:18:40.947 E         - ................-> Table "TEST" as "X07" Full Scan
2025-06-26 05:18:40.956 E         + ................-> Table "PUBLIC"."TEST" as "X07" Full Scan
2025-06-26 05:18:40.968 E           Sub-query (invariant)
2025-06-26 05:18:40.972 E           ....-> Refetch
2025-06-26 05:18:40.976 E           ........-> Sort (record length: 28, key length: 8)
2025-06-26 05:18:40.981 E           ............-> Filter
2025-06-26 05:18:40.985 E         - ................-> Table "TEST" as "X07" Full Scan
2025-06-26 05:18:40.990 E         + ................-> Table "PUBLIC"."TEST" as "X07" Full Scan
2025-06-26 05:18:40.998 E           Select Expression
2025-06-26 05:18:41.003 E           ....-> Filter (preliminary)
2025-06-26 05:18:41.008 E         - ........-> Table "TEST" as "A07" Full Scan
2025-06-26 05:18:41.013 E         + ........-> Table "PUBLIC"."TEST" as "A07" Full Scan
2025-06-26 05:18:41.022 E           3040
2025-06-26 05:18:41.026 E           select id from test a08 where '' > all (select id from test x08 where txt_short>'' order by id)
2025-06-26 05:18:41.031 E           *** not [yet] commented ***
2025-06-26 05:18:41.036 E           Sub-query (invariant)
2025-06-26 05:18:41.040 E           ....-> Filter
2025-06-26 05:18:41.045 E           ........-> Sort (record length: 1036, key length: 8)
2025-06-26 05:18:41.049 E           ............-> Filter
2025-06-26 05:18:41.054 E         - ................-> Table "TEST" as "X08" Full Scan
2025-06-26 05:18:41.059 E         + ................-> Table "PUBLIC"."TEST" as "X08" Full Scan
2025-06-26 05:18:41.070 E           Select Expression
2025-06-26 05:18:41.075 E           ....-> Filter (preliminary)
2025-06-26 05:18:41.081 E         - ........-> Table "TEST" as "A08" Full Scan
2025-06-26 05:18:41.087 E         + ........-> Table "PUBLIC"."TEST" as "A08" Full Scan
2025-06-26 05:18:41.098 E           3050
2025-06-26 05:18:41.108 E           select id from test a09 where '' > all (select id from test x09 where txt_broad>'' order by id)
2025-06-26 05:18:41.119 E           *** not [yet] commented ***
2025-06-26 05:18:41.126 E           Sub-query (invariant)
2025-06-26 05:18:41.132 E           ....-> Filter
2025-06-26 05:18:41.137 E           ........-> Refetch
2025-06-26 05:18:41.143 E           ............-> Sort (record length: 28, key length: 8)
2025-06-26 05:18:41.149 E           ................-> Filter
2025-06-26 05:18:41.154 E         - ....................-> Table "TEST" as "X09" Full Scan
2025-06-26 05:18:41.162 E         + ....................-> Table "PUBLIC"."TEST" as "X09" Full Scan
2025-06-26 05:18:41.181 E           Select Expression
2025-06-26 05:18:41.187 E           ....-> Filter (preliminary)
2025-06-26 05:18:41.193 E         - ........-> Table "TEST" as "A09" Full Scan
2025-06-26 05:18:41.199 E         + ........-> Table "PUBLIC"."TEST" as "A09" Full Scan
2025-06-26 05:18:41.213 E           3060
2025-06-26 05:18:41.219 E           select id from test a10 where '' <> any (select id from test x10 where txt_short>'' order by id)
2025-06-26 05:18:41.224 E           *** not [yet] commented ***
2025-06-26 05:18:41.230 E           Sub-query (invariant)
2025-06-26 05:18:41.234 E           ....-> Filter
2025-06-26 05:18:41.239 E           ........-> Sort (record length: 1036, key length: 8)
2025-06-26 05:18:41.243 E           ............-> Filter
2025-06-26 05:18:41.247 E         - ................-> Table "TEST" as "X10" Full Scan
2025-06-26 05:18:41.252 E         + ................-> Table "PUBLIC"."TEST" as "X10" Full Scan
2025-06-26 05:18:41.261 E           Select Expression
2025-06-26 05:18:41.266 E           ....-> Filter (preliminary)
2025-06-26 05:18:41.270 E         - ........-> Table "TEST" as "A10" Full Scan
2025-06-26 05:18:41.277 E         + ........-> Table "PUBLIC"."TEST" as "A10" Full Scan
2025-06-26 05:18:41.288 E           3070
2025-06-26 05:18:41.293 E           select id from test a11 where '' <> any (select id from test x11 where txt_broad>'' order by id)
2025-06-26 05:18:41.297 E           *** not [yet] commented ***
2025-06-26 05:18:41.301 E           Sub-query (invariant)
2025-06-26 05:18:41.306 E           ....-> Filter
2025-06-26 05:18:41.310 E           ........-> Refetch
2025-06-26 05:18:41.315 E           ............-> Sort (record length: 28, key length: 8)
2025-06-26 05:18:41.319 E           ................-> Filter
2025-06-26 05:18:41.323 E         - ....................-> Table "TEST" as "X11" Full Scan
2025-06-26 05:18:41.328 E         + ....................-> Table "PUBLIC"."TEST" as "X11" Full Scan
2025-06-26 05:18:41.337 E           Select Expression
2025-06-26 05:18:41.342 E           ....-> Filter (preliminary)
2025-06-26 05:18:41.346 E         - ........-> Table "TEST" as "A11" Full Scan
2025-06-26 05:18:41.351 E         + ........-> Table "PUBLIC"."TEST" as "A11" Full Scan
2025-06-26 05:18:41.359 E           4000
2025-06-26 05:18:41.364 E           select id,txt_short from test a12 where exists(select 1 from test x12 where txt_short>'' order by id)
2025-06-26 05:18:41.368 E           MUST use refetch: column x12.txt_short not present in order by
2025-06-26 05:18:41.373 E           Sub-query (invariant)
2025-06-26 05:18:41.377 E           ....-> Refetch
2025-06-26 05:18:41.381 E           ........-> Sort (record length: 28, key length: 8)
2025-06-26 05:18:41.386 E           ............-> Filter
2025-06-26 05:18:41.390 E         - ................-> Table "TEST" as "X12" Full Scan
2025-06-26 05:18:41.395 E         + ................-> Table "PUBLIC"."TEST" as "X12" Full Scan
2025-06-26 05:18:41.403 E           Select Expression
2025-06-26 05:18:41.408 E           ....-> Filter (preliminary)
2025-06-26 05:18:41.412 E         - ........-> Table "TEST" as "A12" Full Scan
2025-06-26 05:18:41.416 E         + ........-> Table "PUBLIC"."TEST" as "A12" Full Scan
2025-06-26 05:18:41.425 E           4010
2025-06-26 05:18:41.430 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 05:18:41.434 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 05:18:41.439 E           Sub-query (invariant)
2025-06-26 05:18:41.443 E           ....-> Sort (record length: 28, key length: 8)
2025-06-26 05:18:41.448 E           ........-> Filter
2025-06-26 05:18:41.452 E         - ............-> Table "TEST" as "X13" Full Scan
2025-06-26 05:18:41.457 E         + ............-> Table "PUBLIC"."TEST" as "X13" Full Scan
2025-06-26 05:18:41.465 E           Select Expression
2025-06-26 05:18:41.470 E           ....-> Filter (preliminary)
2025-06-26 05:18:41.474 E         - ........-> Table "TEST" as "A13" Full Scan
2025-06-26 05:18:41.478 E         + ........-> Table "PUBLIC"."TEST" as "A13" Full Scan
2025-06-26 05:18:41.488 E           4020
2025-06-26 05:18:41.494 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 05:18:41.500 E           MUST use refetch! See letter from dimitr 28.12.2020 14:49
2025-06-26 05:18:41.506 E           Sort procedure will get:
2025-06-26 05:18:41.511 E           a KEY = result of evaluating 'computed_id_dup';
2025-06-26 05:18:41.517 E           a VAL = value of the field 'ID' which is base for computing 'computed_id_dup'
2025-06-26 05:18:41.522 E           Thus sorter will have a field which not equals to a key, which leads to refetch.
2025-06-26 05:18:41.527 E           Sub-query (invariant)
2025-06-26 05:18:41.532 E           ....-> Refetch
2025-06-26 05:18:41.537 E           ........-> Sort (record length: 36, key length: 12)
2025-06-26 05:18:41.541 E           ............-> Filter
2025-06-26 05:18:41.545 E         - ................-> Table "TEST" as "X14" Full Scan
2025-06-26 05:18:41.550 E         + ................-> Table "PUBLIC"."TEST" as "X14" Full Scan
2025-06-26 05:18:41.562 E           Select Expression
2025-06-26 05:18:41.568 E           ....-> Filter (preliminary)
2025-06-26 05:18:41.573 E         - ........-> Table "TEST" as "A14" Full Scan
2025-06-26 05:18:41.578 E         + ........-> Table "PUBLIC"."TEST" as "A14" Full Scan
2025-06-26 05:18:41.593 E           4030
2025-06-26 05:18:41.599 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 05:18:41.607 E           Must NOT use refetch: all persistent columns from WHERE expression (f01, f02) belong to ORDER BY list
2025-06-26 05:18:41.617 E           Sub-query (invariant)
2025-06-26 05:18:41.625 E           ....-> Sort (record length: 36, key length: 16)
2025-06-26 05:18:41.631 E           ........-> Filter
2025-06-26 05:18:41.637 E         - ............-> Table "TEST" as "X15" Full Scan
2025-06-26 05:18:41.643 E         + ............-> Table "PUBLIC"."TEST" as "X15" Full Scan
2025-06-26 05:18:41.655 E           Select Expression
2025-06-26 05:18:41.660 E           ....-> Filter (preliminary)
2025-06-26 05:18:41.666 E         - ........-> Table "TEST" as "A15" Full Scan
2025-06-26 05:18:41.676 E         + ........-> Table "PUBLIC"."TEST" as "A15" Full Scan
2025-06-26 05:18:41.698 E           4040
2025-06-26 05:18:41.709 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 05:18:41.721 E           Must use refetch: one of columns from WHERE expr (id) does not belong to ORDER BY list
2025-06-26 05:18:41.732 E           Sub-query (invariant)
2025-06-26 05:18:41.743 E           ....-> Refetch
2025-06-26 05:18:41.755 E           ........-> Sort (record length: 36, key length: 16)
2025-06-26 05:18:41.764 E           ............-> Filter
2025-06-26 05:18:41.772 E         - ................-> Table "TEST" as "X16" Full Scan
2025-06-26 05:18:41.778 E         + ................-> Table "PUBLIC"."TEST" as "X16" Full Scan
2025-06-26 05:18:41.790 E           Select Expression
2025-06-26 05:18:41.796 E           ....-> Filter (preliminary)
2025-06-26 05:18:41.802 E         - ........-> Table "TEST" as "A16" Full Scan
2025-06-26 05:18:41.812 E         + ........-> Table "PUBLIC"."TEST" as "A16" Full Scan
2025-06-26 05:18:41.828 E           4050
2025-06-26 05:18:41.836 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 05:18:41.841 E           Must use refetch: computed column in WHERE expr does not belong to ORDER BY list
2025-06-26 05:18:41.847 E           Sub-query (invariant)
2025-06-26 05:18:41.853 E           ....-> Refetch
2025-06-26 05:18:41.858 E           ........-> Sort (record length: 28, key length: 8)
2025-06-26 05:18:41.864 E           ............-> Filter
2025-06-26 05:18:41.874 E         - ................-> Table "TEST" as "X17" Full Scan
2025-06-26 05:18:41.878 E         + ................-> Table "PUBLIC"."TEST" as "X17" Full Scan
2025-06-26 05:18:41.891 E           Select Expression
2025-06-26 05:18:41.897 E           ....-> Filter (preliminary)
2025-06-26 05:18:41.903 E         - ........-> Table "TEST" as "A17" Full Scan
2025-06-26 05:18:41.912 E         + ........-> Table "PUBLIC"."TEST" as "A17" Full Scan
2025-06-26 05:18:41.932 E           4060
2025-06-26 05:18:41.940 E           select id,txt_short from test a18 where exists(select 1 from test x18 where computed_guid > '' order by f01)
2025-06-26 05:18:41.948 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 05:18:41.955 E           Sub-query (invariant)
2025-06-26 05:18:41.963 E           ....-> Sort (record length: 28, key length: 8)
2025-06-26 05:18:41.973 E           ........-> Filter
2025-06-26 05:18:41.981 E         - ............-> Table "TEST" as "X18" Full Scan
2025-06-26 05:18:41.989 E         + ............-> Table "PUBLIC"."TEST" as "X18" Full Scan
2025-06-26 05:18:42.000 E           Select Expression
2025-06-26 05:18:42.005 E           ....-> Filter (preliminary)
2025-06-26 05:18:42.011 E         - ........-> Table "TEST" as "A18" Full Scan
2025-06-26 05:18:42.017 E         + ........-> Table "PUBLIC"."TEST" as "A18" Full Scan
2025-06-26 05:18:42.028 E           4070
2025-06-26 05:18:42.034 E           with recursive
2025-06-26 05:18:42.039 E           r as (
2025-06-26 05:18:42.045 E           select a19.id, a19.txt_short
2025-06-26 05:18:42.057 E           from test a19
2025-06-26 05:18:42.067 E           where not exists(select * from test x where x.txt_short < a19.txt_short order by id)
2025-06-26 05:18:42.080 E           UNION ALL
2025-06-26 05:18:42.090 E           select i.id, i.txt_short
2025-06-26 05:18:42.101 E           from test i
2025-06-26 05:18:42.112 E           join r on i.id > r.id
2025-06-26 05:18:42.123 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 05:18:42.130 E           )
2025-06-26 05:18:42.137 E           select * from r
2025-06-26 05:18:42.143 E           MUST use refetch both in anchor and recursive parts
2025-06-26 05:18:42.149 E           Sub-query
2025-06-26 05:18:42.156 E           ....-> Refetch
2025-06-26 05:18:42.163 E           ........-> Sort (record length: 28, key length: 8)
2025-06-26 05:18:42.171 E           ............-> Filter
2025-06-26 05:18:42.183 E         - ................-> Table "TEST" as "R X" Full Scan
2025-06-26 05:18:42.195 E         + ................-> Table "PUBLIC"."TEST" as "R" "X" Full Scan
2025-06-26 05:18:42.206 E           Sub-query
2025-06-26 05:18:42.212 E           ....-> Refetch
2025-06-26 05:18:42.217 E           ........-> Sort (record length: 28, key length: 8)
2025-06-26 05:18:42.223 E           ............-> Filter
2025-06-26 05:18:42.229 E         - ................-> Table "TEST" as "R X" Full Scan
2025-06-26 05:18:42.239 E         + ................-> Table "PUBLIC"."TEST" as "R" "X" Full Scan
2025-06-26 05:18:42.255 E           Select Expression
2025-06-26 05:18:42.264 E           ....-> Recursion
2025-06-26 05:18:42.271 E           ........-> Filter
2025-06-26 05:18:42.277 E         - ............-> Table "TEST" as "R A19" Full Scan
2025-06-26 05:18:42.287 E         + ............-> Table "PUBLIC"."TEST" as "R" "A19" Full Scan
2025-06-26 05:18:42.296 E           ........-> Filter
2025-06-26 05:18:42.301 E         - ............-> Table "TEST" as "R I" Full Scan
2025-06-26 05:18:42.311 E         + ............-> Table "PUBLIC"."TEST" as "R" "I" Full Scan
2025-06-26 05:18:42.322 E           5000
2025-06-26 05:18:42.328 E           select txt_broad from v_unioned v01 order by id
2025-06-26 05:18:42.335 E           Must NOT use refetch because view DDL includes UNION
2025-06-26 05:18:42.341 E           Select Expression
2025-06-26 05:18:42.348 E           ....-> Sort (record length: 4044, key length: 8)
2025-06-26 05:18:42.355 E           ........-> First N Records
2025-06-26 05:18:42.365 E           ............-> Union
2025-06-26 05:18:42.377 E         - ................-> Table "TEST" as "V01 TEST" Full Scan
2025-06-26 05:18:42.392 E         + ................-> Table "PUBLIC"."TEST" as "V01" "PUBLIC"."TEST" Full Scan
2025-06-26 05:18:42.407 E         - ................-> Table "RDB$DATABASE" as "V01 RDB$DATABASE" Full Scan
2025-06-26 05:18:42.425 E         + ................-> Table "SYSTEM"."RDB$DATABASE" as "V01" "SYSTEM"."RDB$DATABASE" Full Scan
2025-06-26 05:18:42.437 E           6000
2025-06-26 05:18:42.443 E           select left(txt_broad, 50) as txt from test a21 order by id
2025-06-26 05:18:42.449 E           MUST use refetch because expression is based on column which has length >= threshold
2025-06-26 05:18:42.454 E           (even if final length of expression result is much less than threshold)
2025-06-26 05:18:42.465 E           Select Expression
2025-06-26 05:18:42.475 E           ....-> Refetch
2025-06-26 05:18:42.482 E           ........-> Sort (record length: 28, key length: 8)
2025-06-26 05:18:42.488 E         - ............-> Table "TEST" as "A21" Full Scan
2025-06-26 05:18:42.494 E         + ............-> Table "PUBLIC"."TEST" as "A21" Full Scan
2025-06-26 05:18:42.503 E           6010
2025-06-26 05:18:42.509 E           select left( txt_short || txt_short, 2000) as txt from test a22 order by id
2025-06-26 05:18:42.515 E           Must NOT use refetch because expression is based on column which has length < threshold
2025-06-26 05:18:42.521 E           (even if final length of expression result is much bigger than threshold)
2025-06-26 05:18:42.527 E           Select Expression
2025-06-26 05:18:42.534 E           ....-> Sort (record length: 1036, key length: 8)
2025-06-26 05:18:42.541 E         - ........-> Table "TEST" as "A22" Full Scan
2025-06-26 05:18:42.548 E         + ........-> Table "PUBLIC"."TEST" as "A22" Full Scan
2025-06-26 05:18:42.563 E           7000
2025-06-26 05:18:42.574 E           select * from test_ns_01 a23 order by id
2025-06-26 05:18:42.583 E           MUST use refetch
2025-06-26 05:18:42.589 E           Select Expression
2025-06-26 05:18:42.597 E           ....-> Refetch
2025-06-26 05:18:42.603 E           ........-> Sort (record length: 44, key length: 24)
2025-06-26 05:18:42.617 E         - ............-> Table "TEST_NS_01" as "A23" Full Scan
2025-06-26 05:18:42.630 E         + ............-> Table "PUBLIC"."TEST_NS_01" as "A23" Full Scan
2025-06-26 05:18:42.648 E           7010
2025-06-26 05:18:42.654 E           select * from test_ns_02 a24 order by id
2025-06-26 05:18:42.662 E           Must NOT refetch
2025-06-26 05:18:42.669 E           Select Expression
2025-06-26 05:18:42.676 E           ....-> Sort (record length: 1052, key length: 24)
2025-06-26 05:18:42.684 E         - ........-> Table "TEST_NS_02" as "A24" Full Scan
2025-06-26 05:18:42.693 E         + ........-> Table "PUBLIC"."TEST_NS_02" as "A24" Full Scan
2025-06-26 05:18:42.711 E           7020
2025-06-26 05:18:42.722 E           select * from test_ns_03 order by id
2025-06-26 05:18:42.731 E           MUST use refetch
2025-06-26 05:18:42.739 E           Select Expression
2025-06-26 05:18:42.745 E           ....-> Refetch
2025-06-26 05:18:42.752 E           ........-> Sort (record length: 36, key length: 12)
2025-06-26 05:18:42.758 E         - ............-> Table "TEST_NS_03" Full Scan
2025-06-26 05:18:42.774 E         + ............-> Table "PUBLIC"."TEST_NS_03" Full Scan
2025-06-26 05:18:42.794 E           7030
2025-06-26 05:18:42.800 E           select * from test_ns_04 order by id
2025-06-26 05:18:42.808 E           Must NOT use refetch
2025-06-26 05:18:42.814 E           Select Expression
2025-06-26 05:18:42.819 E           ....-> Sort (record length: 1036, key length: 12)
2025-06-26 05:18:42.824 E         - ........-> Table "TEST_NS_04" Full Scan
2025-06-26 05:18:42.828 E         + ........-> Table "PUBLIC"."TEST_NS_04" Full Scan
2025-06-26 05:18:42.838 E           7040
2025-06-26 05:18:42.846 E           select * from test_ns_05 order by id
2025-06-26 05:18:42.853 E           MUST use refetch
2025-06-26 05:18:42.860 E           Select Expression
2025-06-26 05:18:42.865 E           ....-> Refetch
2025-06-26 05:18:42.871 E           ........-> Sort (record length: 36, key length: 12)
2025-06-26 05:18:42.876 E         - ............-> Table "TEST_NS_05" Full Scan
2025-06-26 05:18:42.882 E         + ............-> Table "PUBLIC"."TEST_NS_05" Full Scan
2025-06-26 05:18:42.893 E           7050
2025-06-26 05:18:42.901 E           select * from test_ns_06 order by id
2025-06-26 05:18:42.910 E           Must NOT use refetch
2025-06-26 05:18:42.918 E           Select Expression
2025-06-26 05:18:42.925 E           ....-> Sort (record length: 1036, key length: 12)
2025-06-26 05:18:42.931 E         - ........-> Table "TEST_NS_06" Full Scan
2025-06-26 05:18:42.937 E         + ........-> Table "PUBLIC"."TEST_NS_06" Full Scan
2025-06-26 05:18:42.948
2025-06-26 05:18:42.954 tests/bugs/core_2650_test.py:1199: AssertionError
2025-06-26 05:18:42.965 ---------------------------- Captured stdout setup -----------------------------
2025-06-26 05:18:42.976 Creating db: localhost:/var/tmp/qa_2024/test_1441/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 1763 649 2025.06.30 00:19:30.354 2025.06.30 00:19:32.117 2025.06.29 21:27:17.323 2025.06.29 21:27:17.972
2 6.0.0.877 2025.06.26 8e38f P P 1324 546 2025.06.27 00:04:23.413 2025.06.27 00:04:24.737 2025.06.26 21:26:16.309 2025.06.26 21:26:16.855
3 6.0.0.876 2025.06.25 b1bec F F 1433 635 2025.06.26 00:08:06.197 2025.06.26 00:08:07.630 2025.06.25 21:26:55.966 2025.06.25 21:26:56.601
4 6.0.0.863 2025.06.24 c3c20 F F 821 614 2025.06.25 00:08:39.458 2025.06.25 00:08:40.279 2025.06.24 21:26:20.166 2025.06.24 21:26:20.780
5 6.0.0.858 2025.06.23 8d6f7 F F 1048 617 2025.06.24 00:07:57.751 2025.06.24 00:07:58.799 2025.06.23 21:26:46.526 2025.06.23 21:26:47.143
6 6.0.0.849 2025.06.20 7b79c F F 929 707 2025.06.21 00:18:13.638 2025.06.21 00:18:14.567 2025.06.20 21:29:14.217 2025.06.20 21:29:14.924
7 6.0.0.848 2025.06.19 c483c F F 1572 617 2025.06.20 00:13:57.821 2025.06.20 00:13:59.393 2025.06.19 21:28:21.544 2025.06.19 21:28:22.161
8 6.0.0.845 2025.06.18 22b12 F F 861 734 2025.06.19 00:20:18.646 2025.06.19 00:20:19.507 2025.06.18 21:27:29.061 2025.06.18 21:27:29.795
9 6.0.0.843 2025.06.16 995f4 F F 1804 643 2025.06.18 00:22:40.299 2025.06.18 00:22:42.103 2025.06.17 21:29:38.838 2025.06.17 21:29:39.481
10 6.0.0.840 2025.06.14 29bca F F 1294 618 2025.06.16 00:13:11.821 2025.06.16 00:13:13.115 2025.06.15 21:26:28.620 2025.06.15 21:26:29.238
11 6.0.0.838 2025.06.13 0e28a F F 872 659 2025.06.14 00:23:04.325 2025.06.14 00:23:05.197 2025.06.13 21:27:36.286 2025.06.13 21:27:36.945
12 6.0.0.835 2025.06.12 2cf29 F F 845 642 2025.06.13 00:25:17.953 2025.06.13 00:25:18.798 2025.06.12 21:33:18.115 2025.06.12 21:33:18.757
13 6.0.0.834 2025.06.11 e889f F F 1585 628 2025.06.12 00:21:40.725 2025.06.12 00:21:42.310 2025.06.11 21:29:12.206 2025.06.11 21:29:12.834
14 6.0.0.800 2025.06.10 1f226 P P 1630 601 2025.06.10 23:19:00.931 2025.06.10 23:19:02.561 2025.06.10 21:28:13.080 2025.06.10 21:28:13.681
15 6.0.0.799 2025.06.07 be644 P P 1277 616 2025.06.09 23:18:39.573 2025.06.09 23:18:40.850 2025.06.09 21:28:10.290 2025.06.09 21:28:10.906
16 6.0.0.797 2025.06.06 303e8 P P 1647 707 2025.06.06 23:19:28.237 2025.06.06 23:19:29.884 2025.06.06 21:25:00.958 2025.06.06 21:25:01.665
17 6.0.0.795 2025.05.29 7a71a P P 838 664 2025.06.05 23:16:37.133 2025.06.05 23:16:37.971 2025.06.05 21:24:46.577 2025.06.05 21:24:47.241
18 6.0.0.792 2025.05.28 b4327 P P 1497 605 2025.05.28 23:23:55.831 2025.05.28 23:23:57.328 2025.05.28 21:25:27.192 2025.05.28 21:25:27.797
19 6.0.0.791 2025.05.27 02db8 P P 917 632 2025.05.27 23:22:30.438 2025.05.27 23:22:31.355 2025.05.27 21:25:11.367 2025.05.27 21:25:11.999
20 6.0.0.789 2025.05.21 64051 P P 1519 626 2025.05.24 23:19:50.663 2025.05.24 23:19:52.182 2025.05.24 21:25:00.254 2025.05.24 21:25:00.880
21 6.0.0.787 2025.05.20 230ad P P 858 605 2025.05.20 23:17:31.922 2025.05.20 23:17:32.780 2025.05.20 21:24:51.492 2025.05.20 21:24:52.097
22 6.0.0.783 2025.05.12 37320 P P 1080 656 2025.05.19 11:01:09.077 2025.05.19 11:01:10.157 2025.05.19 09:16:38.571 2025.05.19 09:16:39.227
23 6.0.0.779 2025.05.11 136fa P P 894 609 2025.05.11 23:15:00.717 2025.05.11 23:15:01.611 2025.05.11 21:24:30.634 2025.05.11 21:24:31.243
24 6.0.0.778 2025.05.07 d735e P P 876 611 2025.05.07 23:14:24.659 2025.05.07 23:14:25.535 2025.05.07 21:24:39.386 2025.05.07 21:24:39.997
25 6.0.0.776 2025.05.06 007cd P P 1399 534 2025.05.06 23:07:05.303 2025.05.06 23:07:06.702 2025.05.06 21:24:36.416 2025.05.06 21:24:36.950
26 6.0.0.770 2025.05.05 82c4a P P 1492 535 2025.05.05 23:06:18.698 2025.05.05 23:06:20.190 2025.05.05 21:24:33.388 2025.05.05 21:24:33.923
27 6.0.0.767 2025.05.01 cdd29 P P 1575 577 2025.05.01 23:04:49.311 2025.05.01 23:04:50.886 2025.05.01 21:24:27.967 2025.05.01 21:24:28.544
28 6.0.0.762 2025.04.30 5cb15 P P 1539 613 2025.04.30 23:02:34.170 2025.04.30 23:02:35.709 2025.04.30 21:24:24.572 2025.04.30 21:24:25.185
29 6.0.0.755 2025.04.29 739c6 P P 1667 595 2025.04.29 23:04:36.411 2025.04.29 23:04:38.078 2025.04.29 21:24:33.338 2025.04.29 21:24:33.933
30 6.0.0.753 2025.04.27 29ab3 P P 1533 660 2025.04.27 23:04:03.553 2025.04.27 23:04:05.086 2025.04.27 21:24:28.661 2025.04.27 21:24:29.321
31 6.0.0.745 2025.04.21 78ad8 P P 1518 632 2025.04.25 23:04:34.814 2025.04.25 23:04:36.332 2025.04.25 21:25:40.604 2025.04.25 21:25:41.236
32 6.0.0.744 2025.04.19 e883a P P 1571 679 2025.04.19 23:05:52.323 2025.04.19 23:05:53.894 2025.04.19 21:24:40.745 2025.04.19 21:24:41.424
33 6.0.0.742 2025.04.17 abc3b P P 1580 582 2025.04.18 23:05:58.170 2025.04.18 23:05:59.750 2025.04.18 21:24:30.440 2025.04.18 21:24:31.022
34 6.0.0.737 2025.04.16 fe52b P P 1408 553 2025.04.16 23:05:45.513 2025.04.16 23:05:46.921 2025.04.16 21:24:26.431 2025.04.16 21:24:26.984
35 6.0.0.736 2025.04.14 3e6be P P 1377 612 2025.04.14 22:52:46.678 2025.04.14 22:52:48.055 2025.04.14 21:23:29.520 2025.04.14 21:23:30.132
36 6.0.0.735 2025.04.13 6635c P P 1384 530 2025.04.13 22:54:11.549 2025.04.13 22:54:12.933 2025.04.13 21:23:56.484 2025.04.13 21:23:57.014
37 6.0.0.734 2025.04.12 12f3f P P 1321 614 2025.04.12 22:52:59.933 2025.04.12 22:53:01.254 2025.04.12 21:23:37.344 2025.04.12 21:23:37.958
38 6.0.0.730 2025.04.11 240b8 P P 1343 455 2025.04.11 22:53:56.004 2025.04.11 22:53:57.347 2025.04.11 21:23:33.148 2025.04.11 21:23:33.603
39 6.0.0.726 2025.04.10 d79c6 P P 1480 560 2025.04.10 22:53:39.826 2025.04.10 22:53:41.306 2025.04.10 21:23:40.523 2025.04.10 21:23:41.083
40 6.0.0.725 2025.04.09 a2b05 P P 1319 599 2025.04.09 22:53:46.537 2025.04.09 22:53:47.856 2025.04.09 21:23:51.499 2025.04.09 21:23:52.098
41 6.0.0.722 2025.04.08 a8b86 P P 1466 611 2025.04.08 23:03:30.093 2025.04.08 23:03:31.559 2025.04.08 21:24:32.954 2025.04.08 21:24:33.565
42 6.0.0.719 2025.04.06 90fd9 P P 1537 579 2025.04.06 23:01:21.897 2025.04.06 23:01:23.434 2025.04.06 21:24:34.161 2025.04.06 21:24:34.740
43 6.0.0.717 2025.04.04 53d70 P P 1428 492 2025.04.04 22:59:30.745 2025.04.04 22:59:32.173 2025.04.04 21:24:20.016 2025.04.04 21:24:20.508
44 6.0.0.716 2025.04.03 fc636 P P 1453 634 2025.04.03 23:02:32.418 2025.04.03 23:02:33.871 2025.04.03 21:24:30.293 2025.04.03 21:24:30.927
45 6.0.0.715 2025.04.02 907ed P P 1565 617 2025.04.02 23:02:16.381 2025.04.02 23:02:17.946 2025.04.02 21:24:43.030 2025.04.02 21:24:43.647
46 6.0.0.710 2025.04.01 40651 P P 1472 559 2025.04.01 23:01:12.198 2025.04.01 23:01:13.670 2025.04.01 21:24:27.048 2025.04.01 21:24:27.607
47 6.0.0.708 2025.03.31 cb069 P P 1472 545 2025.03.31 22:54:46.010 2025.03.31 22:54:47.482 2025.03.31 21:24:00.716 2025.03.31 21:24:01.261
48 6.0.0.707 2025.03.28 4bd4f P P 1325 610 2025.03.30 22:54:49.531 2025.03.30 22:54:50.856 2025.03.30 21:23:56.926 2025.03.30 21:23:57.536
49 6.0.0.698 2025.03.26 d72a7 P P 1509 557 2025.03.27 23:05:23.126 2025.03.27 23:05:24.635 2025.03.27 21:24:57.115 2025.03.27 21:24:57.672
50 6.0.0.693 2025.03.24 0b559 P P 1429 460 2025.03.24 22:58:59.810 2025.03.24 22:59:01.239 2025.03.24 21:24:57.395 2025.03.24 21:24:57.855
51 6.0.0.687 2025.03.22 730aa P P 1769 560 2025.03.23 23:08:18.809 2025.03.23 23:08:20.578 2025.03.23 21:24:42.273 2025.03.23 21:24:42.833
52 6.0.0.686 2025.03.20 71bf6 P P 1795 590 2025.03.20 23:11:46.655 2025.03.20 23:11:48.450 2025.03.20 21:25:01.383 2025.03.20 21:25:01.973
53 6.0.0.685 2025.03.19 a8577 P P 1571 608 2025.03.19 23:09:36.139 2025.03.19 23:09:37.710 2025.03.19 21:24:49.094 2025.03.19 21:24:49.702
54 6.0.0.680 2025.03.18 90d29 P P 806 474 2025.03.19 09:48:08.366 2025.03.19 09:48:09.172 2025.03.19 08:14:28.049 2025.03.19 08:14:28.523
55 6.0.0.677 2025.03.16 c0a60 P P 1263 472 2025.03.16 23:03:03.796 2025.03.16 23:03:05.059 2025.03.16 21:24:47.701 2025.03.16 21:24:48.173
56 6.0.0.676 2025.03.15 3034f P P 852 446 2025.03.16 14:49:56.675 2025.03.16 14:49:57.527 2025.03.16 13:20:13.472 2025.03.16 13:20:13.918
57 6.0.0.673 2025.03.13 40f5b P P 1296 487 2025.03.13 23:02:21.069 2025.03.13 23:02:22.365 2025.03.13 21:24:36.284 2025.03.13 21:24:36.771
58 6.0.0.671 2025.03.12 a4fff P P 1342 431 2025.03.12 23:06:06.708 2025.03.12 23:06:08.050 2025.03.12 21:25:11.665 2025.03.12 21:25:12.096
59 6.0.0.663 2025.03.11 daad2 P P 1264 470 2025.03.11 23:04:22.197 2025.03.11 23:04:23.461 2025.03.11 21:25:25.239 2025.03.11 21:25:25.709
60 6.0.0.661 2025.03.07 b9869 P P 1231 419 2025.03.10 22:52:03.892 2025.03.10 22:52:05.123 2025.03.10 21:23:49.384 2025.03.10 21:23:49.803
61 6.0.0.660 2025.03.04 a6700 P P 1400 449 2025.03.06 22:57:46.923 2025.03.06 22:57:48.323 2025.03.06 21:24:17.787 2025.03.06 21:24:18.236
62 6.0.0.658 2025.03.03 f15f8 P P 1218 429 2025.03.03 22:53:39.588 2025.03.03 22:53:40.806 2025.03.03 21:24:15.718 2025.03.03 21:24:16.147
63 6.0.0.656 2025.02.27 25fb4 P P 1519 479 2025.03.02 23:08:27.166 2025.03.02 23:08:28.685 2025.03.02 21:25:21.534 2025.03.02 21:25:22.013
64 6.0.0.655 2025.02.25 6e3e0 P P 652 465 2025.02.26 22:55:19.191 2025.02.26 22:55:19.843 2025.02.26 21:24:14.697 2025.02.26 21:24:15.162
65 6.0.0.654 2025.02.24 b7141 P P 725 455 2025.02.24 22:57:16.936 2025.02.24 22:57:17.661 2025.02.24 21:24:28.939 2025.02.24 21:24:29.394
66 6.0.0.652 2025.02.22 22662 P P 882 372 2025.02.24 01:06:11.854 2025.02.24 01:06:12.736 2025.02.23 23:40:59.549 2025.02.23 23:40:59.921
67 6.0.0.647 2025.02.21 9fccb P P 1309 464 2025.02.21 22:59:56.502 2025.02.21 22:59:57.811 2025.02.21 21:27:45.842 2025.02.21 21:27:46.306
68 6.0.0.640 2025.02.19 9b8ac P P 738 448 2025.02.19 22:55:44.941 2025.02.19 22:55:45.679 2025.02.19 21:24:36.951 2025.02.19 21:24:37.399
69 6.0.0.639 2025.02.18 201a4 P P 999 494 2025.02.18 22:52:41.327 2025.02.18 22:52:42.326 2025.02.18 21:24:15.091 2025.02.18 21:24:15.585
70 6.0.0.637 2025.02.12 6d0f5 P P 1239 459 2025.02.13 23:02:40.719 2025.02.13 23:02:41.958 2025.02.13 21:24:49.216 2025.02.13 21:24:49.675
71 6.0.0.636 2025.02.11 0424f P P 1245 516 2025.02.11 23:01:25.777 2025.02.11 23:01:27.022 2025.02.11 21:24:18.309 2025.02.11 21:24:18.825
72 6.0.0.635 2025.02.10 f640f P P 783 461 2025.02.10 23:01:00.662 2025.02.10 23:01:01.445 2025.02.10 21:24:48.732 2025.02.10 21:24:49.193
73 6.0.0.629 2025.02.07 194f9 P P 1291 482 2025.02.07 22:59:52.785 2025.02.07 22:59:54.076 2025.02.07 21:24:36.865 2025.02.07 21:24:37.347
74 6.0.0.628 2025.02.06 859d5 P P 1141 460 2025.02.06 23:06:46.845 2025.02.06 23:06:47.986 2025.02.06 21:24:25.033 2025.02.06 21:24:25.493
75 6.0.0.621 2025.02.05 34fe7 P P 1155 434 2025.02.05 23:07:18.054 2025.02.05 23:07:19.209 2025.02.05 21:24:23.358 2025.02.05 21:24:23.792
76 6.0.0.609 2025.02.04 76d57 P P 1341 395 2025.02.04 23:02:24.106 2025.02.04 23:02:25.447 2025.02.04 21:24:19.732 2025.02.04 21:24:20.127
77 6.0.0.607 2025.02.03 1985b P P 1181 514 2025.02.03 23:03:08.425 2025.02.03 23:03:09.606 2025.02.03 21:24:42.164 2025.02.03 21:24:42.678
78 6.0.0.601 2025.02.01 6af07 P P 1297 421 2025.02.01 22:58:54.781 2025.02.01 22:58:56.078 2025.02.01 21:24:14.801 2025.02.01 21:24:15.222
79 6.0.0.600 2025.01.27 188de P P 1213 484 2025.01.27 23:02:21.840 2025.01.27 23:02:23.053 2025.01.27 21:24:30.764 2025.01.27 21:24:31.248
80 6.0.0.599 2025.01.25 ba588 P P 1282 457 2025.01.25 23:03:02.469 2025.01.25 23:03:03.751 2025.01.25 21:24:46.806 2025.01.25 21:24:47.263
81 6.0.0.598 2025.01.23 ddbc3 P P 1443 441 2025.01.24 23:02:12.134 2025.01.24 23:02:13.577 2025.01.24 21:24:26.514 2025.01.24 21:24:26.955
82 6.0.0.595 2025.01.22 e62f3 P P 1039 405 2025.01.22 22:56:23.295 2025.01.22 22:56:24.334 2025.01.22 21:24:19.925 2025.01.22 21:24:20.330
83 6.0.0.594 2025.01.21 47fb6 P P 1281 456 2025.01.21 22:55:51.518 2025.01.21 22:55:52.799 2025.01.21 21:24:05.650 2025.01.21 21:24:06.106
84 6.0.0.590 2025.01.20 9dc1e P P 690 428 2025.01.20 23:01:23.033 2025.01.20 23:01:23.723 2025.01.20 21:24:15.394 2025.01.20 21:24:15.822
85 6.0.0.588 2025.01.19 b1c4e P P 1242 504 2025.01.19 22:58:09.416 2025.01.19 22:58:10.658 2025.01.19 21:24:19.990 2025.01.19 21:24:20.494
86 6.0.0.587 2025.01.18 63e6e P P 1356 443 2025.01.18 23:00:41.279 2025.01.18 23:00:42.635 2025.01.18 21:24:47.747 2025.01.18 21:24:48.190
87 6.0.0.585 2025.01.16 2d6bb P P 1110 432 2025.01.17 22:56:02.386 2025.01.17 22:56:03.496 2025.01.17 21:24:10.666 2025.01.17 21:24:11.098
88 6.0.0.584 2025.01.15 a0aa2 P P 1333 461 2025.01.15 22:59:40.730 2025.01.15 22:59:42.063 2025.01.15 21:24:19.919 2025.01.15 21:24:20.380
89 6.0.0.581 2025.01.14 21e9e P P 1355 474 2025.01.14 23:00:31.571 2025.01.14 23:00:32.926 2025.01.14 21:24:28.589 2025.01.14 21:24:29.063
90 6.0.0.577 2025.01.13 7e293 P P 1305 401 2025.01.13 23:01:16.885 2025.01.13 23:01:18.190 2025.01.13 21:24:25.441 2025.01.13 21:24:25.842
91 6.0.0.576 2025.01.12 05898 F F 1289 451 2025.01.12 22:58:36.390 2025.01.12 22:58:37.679 2025.01.12 21:24:09.656 2025.01.12 21:24:10.107
92 6.0.0.573 2025.01.10 c20f3 F F 1292 442 2025.01.10 22:59:22.134 2025.01.10 22:59:23.426 2025.01.10 21:24:21.981 2025.01.10 21:24:22.423
93 6.0.0.571 2024.12.31 81bba P P 1144 328 2024.12.31 22:36:29.471 2024.12.31 22:36:30.615 2024.12.31 21:22:23.997 2024.12.31 21:22:24.325
94 6.0.0.570 2024.12.30 c3c8d P P 1133 309 2024.12.30 22:35:43.315 2024.12.30 22:35:44.448 2024.12.30 21:22:28.670 2024.12.30 21:22:28.979
95 6.0.0.565 2024.12.28 5fc59 P P 653 321 2024.12.30 11:37:51.934 2024.12.30 11:37:52.587 2024.12.30 10:30:52.449 2024.12.30 10:30:52.770
96 6.0.0.564 2024.12.26 12514 P P 1104 331 2024.12.26 22:37:20.355 2024.12.26 22:37:21.459 2024.12.26 21:22:25.039 2024.12.26 21:22:25.370
97 6.0.0.560 2024.12.25 fa83e P P 1183 346 2024.12.25 22:36:45.667 2024.12.25 22:36:46.850 2024.12.25 21:22:23.305 2024.12.25 21:22:23.651
98 6.0.0.559 2024.12.23 cc800 P P 1086 331 2024.12.24 22:39:17.530 2024.12.24 22:39:18.616 2024.12.24 21:22:21.243 2024.12.24 21:22:21.574
99 6.0.0.556 2024.12.22 a0404 P P 1149 314 2024.12.22 22:37:02.755 2024.12.22 22:37:03.904 2024.12.22 21:22:19.346 2024.12.22 21:22:19.660
100 6.0.0.555 2024.12.19 6990a P P 620 310 2024.12.21 12:14:21.289 2024.12.21 12:14:21.909 2024.12.21 10:57:48.955 2024.12.21 10:57:49.265
101 6.0.0.553 2024.12.17 d1f8a P P 1134 322 2024.12.17 22:38:22.917 2024.12.17 22:38:24.051 2024.12.17 21:22:41.018 2024.12.17 21:22:41.340
102 6.0.0.552 2024.12.11 85e25 P P 1109 362 2024.12.15 22:37:37.509 2024.12.15 22:37:38.618 2024.12.15 21:22:19.196 2024.12.15 21:22:19.558
103 6.0.0.550 2024.12.10 b37ac P P 1081 331 2024.12.10 22:40:35.926 2024.12.10 22:40:37.007 2024.12.10 21:22:31.402 2024.12.10 21:22:31.733
104 6.0.0.548 2024.12.08 2cc77 P P 581 366 2024.12.08 22:35:02.629 2024.12.08 22:35:03.210 2024.12.08 21:22:18.735 2024.12.08 21:22:19.101
105 6.0.0.544 2024.12.05 96943 P P 1086 363 2024.12.05 22:39:30.108 2024.12.05 22:39:31.194 2024.12.05 21:22:48.844 2024.12.05 21:22:49.207
106 6.0.0.543 2024.12.03 30b77 P P 1108 328 2024.12.03 22:39:09.014 2024.12.03 22:39:10.122 2024.12.03 21:22:38.531 2024.12.03 21:22:38.859
107 6.0.0.540 2024.12.02 4a1f4 P P 1165 344 2024.12.02 22:33:55.214 2024.12.02 22:33:56.379 2024.12.02 21:22:26.587 2024.12.02 21:22:26.931
108 6.0.0.539 2024.11.28 1f283 P P 1135 338 2024.11.29 22:38:09.682 2024.11.29 22:38:10.817 2024.11.29 21:22:34.530 2024.11.29 21:22:34.868
109 6.0.0.535 2024.11.26 77b95 P P 1173 318 2024.11.26 22:30:56.595 2024.11.26 22:30:57.768 2024.11.26 21:21:47.577 2024.11.26 21:21:47.895
110 6.0.0.534 2024.11.25 e9584 P P 1123 317 2024.11.25 22:31:59.691 2024.11.25 22:32:00.814 2024.11.25 21:21:51.081 2024.11.25 21:21:51.398
111 6.0.0.533 2024.11.17 933ac P P 637 320 2024.11.22 08:54:44.800 2024.11.22 08:54:45.437 2024.11.22 07:51:06.697 2024.11.22 07:51:07.017
112 6.0.0.532 2024.11.16 9e263 P P 1129 319 2024.11.16 22:28:19.947 2024.11.16 22:28:21.076 2024.11.16 21:21:58.939 2024.11.16 21:21:59.258
113 6.0.0.530 2024.11.15 49804 P P 1150 347 2024.11.16 00:31:43.791 2024.11.16 00:31:44.941 2024.11.15 23:21:46.564 2024.11.15 23:21:46.911
114 6.0.0.528 2024.11.14 9625b P P 876 341 2024.11.15 00:33:03.048 2024.11.15 00:33:03.924 2024.11.14 23:21:59.021 2024.11.14 23:21:59.362
115 6.0.0.526 2024.11.12 65b80 P P 688 363 2024.11.14 00:32:36.047 2024.11.14 00:32:36.735 2024.11.13 23:21:51.384 2024.11.13 23:21:51.747
116 6.0.0.523 2024.11.08 8ca23 P P 1109 345 2024.11.11 00:30:52.530 2024.11.11 00:30:53.639 2024.11.10 23:21:36.735 2024.11.10 23:21:37.080
117 6.0.0.520 2024.11.07 4eefa P P 1222 365 2024.11.08 00:29:26.240 2024.11.08 00:29:27.462 2024.11.07 23:21:42.633 2024.11.07 23:21:42.998
118 6.0.0.516 2024.11.04 b0c36 P P 1010 341 2024.11.05 00:29:12.217 2024.11.05 00:29:13.227 2024.11.04 23:21:40.182 2024.11.04 23:21:40.523
119 6.0.0.515 2024.10.30 d53f3 P P 1078 314 2024.11.04 00:30:10.223 2024.11.04 00:30:11.301 2024.11.03 23:21:33.996 2024.11.03 23:21:34.310
120 6.0.0.512 2024.10.29 833ef P P 1010 355 2024.10.30 00:31:59.898 2024.10.30 00:32:00.908 2024.10.29 23:22:02.754 2024.10.29 23:22:03.109
121 6.0.0.511 2024.10.26 c4bc9 P P 1141 348 2024.10.29 00:31:59.329 2024.10.29 00:32:00.470 2024.10.28 23:21:38.740 2024.10.28 23:21:39.088
122 6.0.0.509 2024.10.25 3aedb P P 595 360 2024.10.26 00:36:52.470 2024.10.26 00:36:53.065 2024.10.25 23:22:24.509 2024.10.25 23:22:24.869
123 6.0.0.508 2024.10.24 a8f5b P P 649 343 2024.10.25 00:33:46.864 2024.10.25 00:33:47.513 2024.10.24 23:22:19.638 2024.10.24 23:22:19.981
124 6.0.0.502 2024.10.22 6bfd7 P P 1027 370 2024.10.23 00:33:15.455 2024.10.23 00:33:16.482 2024.10.22 23:22:02.743 2024.10.22 23:22:03.113
125 6.0.0.500 2024.10.21 be565 P P 678 328 2024.10.22 16:56:53.526 2024.10.22 16:56:54.204 2024.10.22 15:51:14.176 2024.10.22 15:51:14.504
126 6.0.0.499 2024.10.19 6214b P P 616 335 2024.10.20 00:34:11.552 2024.10.20 00:34:12.168 2024.10.19 23:22:29.410 2024.10.19 23:22:29.745
127 6.0.0.498 2024.10.18 591a7 P P 1078 381 2024.10.19 00:32:35.517 2024.10.19 00:32:36.595 2024.10.18 23:21:56.668 2024.10.18 23:21:57.049
128 6.0.0.494 2024.10.17 cf5a4 P P 582 327 2024.10.18 00:33:33.607 2024.10.18 00:33:34.189 2024.10.17 23:22:27.045 2024.10.17 23:22:27.372
129 6.0.0.491 2024.10.14 dc5fb P P 1057 327 2024.10.15 00:30:53.509 2024.10.15 00:30:54.566 2024.10.14 23:21:42.785 2024.10.14 23:21:43.112
130 6.0.0.489 2024.10.11 2ba59 P P 1042 327 2024.10.12 00:34:32.798 2024.10.12 00:34:33.840 2024.10.11 23:22:02.372 2024.10.11 23:22:02.699
131 6.0.0.488 2024.10.09 1c93e P P 1085 393 2024.10.10 00:39:42.440 2024.10.10 00:39:43.525 2024.10.09 23:22:40.969 2024.10.09 23:22:41.362
132 6.0.0.487 2024.10.06 065a3 P P 899 368 2024.10.07 00:38:50.990 2024.10.07 00:38:51.889 2024.10.06 23:22:40.770 2024.10.06 23:22:41.138
133 6.0.0.485 2024.10.04 e95c1 P P 709 360 2024.10.05 00:40:33.180 2024.10.05 00:40:33.889 2024.10.04 23:22:34.206 2024.10.04 23:22:34.566
134 6.0.0.483 2024.10.02 5e5ae P P 698 322 2024.10.03 00:38:11.871 2024.10.03 00:38:12.569 2024.10.02 23:22:27.168 2024.10.02 23:22:27.490
135 6.0.0.478 2024.09.30 b5010 P P 599 350 2024.10.01 00:36:16.562 2024.10.01 00:36:17.161 2024.09.30 23:22:22.357 2024.09.30 23:22:22.707
136 6.0.0.474 2024.09.26 e4efb P P 1121 365 2024.09.30 00:34:29.541 2024.09.30 00:34:30.662 2024.09.29 23:22:10.015 2024.09.29 23:22:10.380
137 6.0.0.471 2024.09.24 01b51 P P 608 337 2024.09.25 22:36:28.242 2024.09.25 22:36:28.850 2024.09.25 21:22:10.392 2024.09.25 21:22:10.729
138 6.0.0.470 2024.09.23 77cc0 P P 644 338 2024.09.23 22:36:03.573 2024.09.23 22:36:04.217 2024.09.23 21:22:26.038 2024.09.23 21:22:26.376
139 6.0.0.467 2024.09.21 ea0b8 P P 1165 358 2024.09.22 22:35:07.436 2024.09.22 22:35:08.601 2024.09.22 21:22:01.550 2024.09.22 21:22:01.908
140 6.0.0.466 2024.09.20 32dc6 P P 772 327 2024.09.20 22:34:16.651 2024.09.20 22:34:17.423 2024.09.20 21:22:01.711 2024.09.20 21:22:02.038
141 6.0.0.461 2024.09.17 2c895 P P 1308 586 2024.09.17 22:59:33.413 2024.09.17 22:59:34.721 2024.09.17 21:25:23.136 2024.09.17 21:25:23.722
142 6.0.0.460 2024.09.11 3c253 P P 1257 576 2024.09.16 23:01:05.329 2024.09.16 23:01:06.586 2024.09.16 21:25:18.903 2024.09.16 21:25:19.479
143 6.0.0.457 2024.09.09 fdc6f P P 1308 551 2024.09.09 23:14:46.184 2024.09.09 23:14:47.492 2024.09.09 21:26:17.813 2024.09.09 21:26:18.364
144 6.0.0.455 2024.09.07 500d8 P P 1615 589 2024.09.07 23:12:30.728 2024.09.07 23:12:32.343 2024.09.07 21:26:30.350 2024.09.07 21:26:30.939
145 6.0.0.454 2024.09.05 4d70f P P 1426 572 2024.09.05 23:01:19.689 2024.09.05 23:01:21.115 2024.09.05 21:25:55.258 2024.09.05 21:25:55.830
146 6.0.0.452 2024.09.04 9ff9c P P 1356 583 2024.09.04 23:00:19.837 2024.09.04 23:00:21.193 2024.09.04 21:25:30.754 2024.09.04 21:25:31.337
147 6.0.0.450 2024.09.02 27124 P P 861 591 2024.09.03 23:39:14.068 2024.09.03 23:39:14.929 2024.09.03 21:34:42.630 2024.09.03 21:34:43.221
148 6.0.0.447 2024.09.01 056ec P P 1267 519 2024.09.01 23:11:46.022 2024.09.01 23:11:47.289 2024.09.01 21:25:22.632 2024.09.01 21:25:23.151
149 6.0.0.446 2024.08.30 fe1b2 P P 876 555 2024.08.31 23:17:20.249 2024.08.31 23:17:21.125 2024.08.31 21:33:28.373 2024.08.31 21:33:28.928
150 6.0.0.444 2024.08.28 785d4 P P 1274 572 2024.08.29 23:31:44.483 2024.08.29 23:31:45.757 2024.08.29 21:33:09.250 2024.08.29 21:33:09.822
151 6.0.0.442 2024.08.21 4a68f P P 1492 650 2024.08.28 00:29:45.165 2024.08.28 00:29:46.657 2024.08.27 21:39:29.720 2024.08.27 21:39:30.370
152 6.0.0.441 2024.08.20 75042 P P 965 582 2024.08.20 23:05:47.361 2024.08.20 23:05:48.326 2024.08.20 21:26:17.072 2024.08.20 21:26:17.654
153 6.0.0.438 2024.08.16 088b5 P P 1255 489 2024.08.18 22:39:19.650 2024.08.18 22:39:20.905 2024.08.18 21:23:18.409 2024.08.18 21:23:18.898
154 6.0.0.437 2024.08.14 3c88b P P 1190 491 2024.08.15 22:37:55.468 2024.08.15 22:37:56.658 2024.08.15 21:23:22.147 2024.08.15 21:23:22.638
155 6.0.0.432 2024.08.11 e82ac P P 1338 484 2024.08.12 22:36:22.971 2024.08.12 22:36:24.309 2024.08.12 21:23:03.494 2024.08.12 21:23:03.978
156 6.0.0.431 2024.08.09 de5a7 P P 1188 529 2024.08.09 22:37:05.053 2024.08.09 22:37:06.241 2024.08.09 21:23:26.669 2024.08.09 21:23:27.198
157 6.0.0.428 2024.08.08 9191b P P 1264 521 2024.08.08 22:36:21.997 2024.08.08 22:36:23.261 2024.08.08 21:23:22.929 2024.08.08 21:23:23.450
158 6.0.0.423 2024.08.07 33b41 P P 816 533 2024.08.08 08:39:07.837 2024.08.08 08:39:08.653 2024.08.08 07:30:52.900 2024.08.08 07:30:53.433
159 6.0.0.421 2024.08.06 ed60d P P 900 303 2024.08.06 22:26:59.357 2024.08.06 22:27:00.257 2024.08.06 21:22:06.678 2024.08.06 21:22:06.981
160 6.0.0.419 2024.08.05 3505a P P 908 319 2024.08.05 22:29:07.229 2024.08.05 22:29:08.137 2024.08.05 21:22:15.630 2024.08.05 21:22:15.949
161 6.0.0.409 2024.08.02 ec18f P P 956 267 2024.08.04 22:31:02.273 2024.08.04 22:31:03.229 2024.08.04 21:22:24.263 2024.08.04 21:22:24.530
162 6.0.0.406 2024.08.01 b20be P P 956 344 2024.08.01 22:30:05.833 2024.08.01 22:30:06.789 2024.08.01 21:22:13.142 2024.08.01 21:22:13.486
163 6.0.0.405 2024.07.31 a62ac P P 918 356 2024.07.31 22:29:42.809 2024.07.31 22:29:43.727 2024.07.31 21:22:16.938 2024.07.31 21:22:17.294
164 6.0.0.403 2024.07.29 30f03 P P 924 311 2024.07.29 22:29:24.488 2024.07.29 22:29:25.412 2024.07.29 21:22:02.873 2024.07.29 21:22:03.184
165 6.0.0.401 2024.07.26 24e41 P P 901 357 2024.07.26 22:26:36.839 2024.07.26 22:26:37.740 2024.07.26 21:22:02.259 2024.07.26 21:22:02.616
166 6.0.0.400 2024.07.24 5bb78 P P 908 320 2024.07.24 22:26:42.185 2024.07.24 22:26:43.093 2024.07.24 21:22:03.992 2024.07.24 21:22:04.312
167 6.0.0.398 2024.07.23 85b18 P P 479 373 2024.07.23 22:32:21.513 2024.07.23 22:32:21.992 2024.07.23 21:22:03.114 2024.07.23 21:22:03.487
168 6.0.0.397 2024.07.22 c734c P P 1010 288 2024.07.22 22:26:31.977 2024.07.22 22:26:32.987 2024.07.22 21:22:01.763 2024.07.22 21:22:02.051
169 6.0.0.396 2024.07.13 cf952 P P 927 346 2024.07.21 22:26:28.638 2024.07.21 22:26:29.565 2024.07.21 21:21:54.532 2024.07.21 21:21:54.878
170 6.0.0.395 2024.07.10 845f4 P P 534 298 2024.07.12 22:25:49.982 2024.07.12 22:25:50.516 2024.07.12 21:21:49.963 2024.07.12 21:21:50.261
171 6.0.0.392 2024.07.09 ea301 P P 796 341 2024.07.09 22:24:15.345 2024.07.09 22:24:16.141 2024.07.09 21:21:49.532 2024.07.09 21:21:49.873
172 6.0.0.391 2024.07.08 7d50c P P 854 337 2024.07.08 22:25:26.123 2024.07.08 22:25:26.977 2024.07.08 21:22:01.122 2024.07.08 21:22:01.459
173 6.0.0.389 2024.07.05 cc71c P P 587 338 2024.07.05 22:25:43.413 2024.07.05 22:25:44.000 2024.07.05 21:21:58.721 2024.07.05 21:21:59.059
174 6.0.0.388 2024.06.30 e5700 P P 844 337 2024.06.30 22:25:24.673 2024.06.30 22:25:25.517 2024.06.30 21:21:59.139 2024.06.30 21:21:59.476
175 6.0.0.387 2024.06.27 7c28a P P 496 312 2024.06.27 22:25:13.441 2024.06.27 22:25:13.937 2024.06.27 21:21:57.078 2024.06.27 21:21:57.390
176 6.0.0.386 2024.06.23 7c57f P P 960 328 2024.06.23 22:23:27.652 2024.06.23 22:23:28.612 2024.06.23 21:21:43.875 2024.06.23 21:21:44.203
177 6.0.0.384 2024.06.21 24d99 P P 1052 288 2024.06.21 22:25:32.209 2024.06.21 22:25:33.261 2024.06.21 21:21:44.709 2024.06.21 21:21:44.997
178 6.0.0.374 2024.06.13 0097d P P 844 297 2024.06.20 22:25:25.033 2024.06.20 22:25:25.877 2024.06.20 21:21:41.049 2024.06.20 21:21:41.346
179 6.0.0.373 2024.06.09 363f0 P P 607 366 2024.06.13 12:45:22.050 2024.06.13 12:45:22.657 2024.06.13 11:44:53.426 2024.06.13 11:44:53.792
180 6.0.0.371 2024.06.08 f7130 P P 523 315 2024.06.11 21:37:41.094 2024.06.11 21:37:41.617 2024.06.11 20:43:26.705 2024.06.11 20:43:27.020
181 6.0.0.366 2024.05.30 ab2c9 P P 1056 271 2024.06.12 08:19:43.877 2024.06.12 08:19:44.933 2024.06.12 07:15:14.202 2024.06.12 07:15:14.473
182 6.0.0.363 2024.05.27 06703 P P 576 244 2024.06.12 13:43:04.269 2024.06.12 13:43:04.845 2024.06.12 12:46:57.908 2024.06.12 12:46:58.152
183 6.0.0.359 2024.05.23 9cb11 P P 559 274 2024.06.12 11:35:29.797 2024.06.12 11:35:30.356 2024.06.12 10:39:01.427 2024.06.12 10:39:01.701
184 6.0.0.358 2024.05.21 995dd P P 533 255 2024.06.12 16:19:45.785 2024.06.12 16:19:46.318 2024.06.12 15:24:06.266 2024.06.12 15:24:06.521
185 6.0.0.357 2024.05.18 bf6c4 P P 627 270 2024.06.12 20:55:49.916 2024.06.12 20:55:50.543 2024.06.12 20:00:39.407 2024.06.12 20:00:39.677
186 6.0.0.356 2024.05.17 eab06 P P 626 230 2024.06.13 05:02:28.034 2024.06.13 05:02:28.660 2024.06.13 04:06:42.407 2024.06.13 04:06:42.637
187 6.0.0.355 2024.05.16 8dd6e P P 520 225 2024.06.13 07:09:38.904 2024.06.13 07:09:39.424 2024.06.13 06:14:09.029 2024.06.13 06:14:09.254
188 6.0.0.354 2024.05.15 d3adc P P 585 333 2024.06.13 10:11:11.382 2024.06.13 10:11:11.967 2024.06.13 09:10:08.691 2024.06.13 09:10:09.024
189 6.0.0.351 2024.05.14 2e3e0 P P 547 308 2024.06.13 15:24:31.338 2024.06.13 15:24:31.885 2024.06.13 14:22:52.037 2024.06.13 14:22:52.345

Elapsed time, ms. Chart for last 150 runs:

Last commits information (all timestamps in UTC):