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   
    Initial state:
    Query: select * from v1_chk_nr
    Select Expression
    ....-> Sort (record length: NN, key length: MM)
    ........-> Filter
  - ............-> Table "TEST1" as "V1_CHK_NR TEST1" Full Scan
  + ............-> Table "PUBLIC"."TEST1" as "PUBLIC"."V1_CHK_NR" "PUBLIC"."TEST1" Full Scan
    3 lowered "D" normal
    Query: select * from v1_chk_ir_asc
    Select Expression
    ....-> Filter
  - ........-> Table "TEST1" as "V1_CHK_IR_ASC TEST1" Access By ID
  + ........-> Table "PUBLIC"."TEST1" as "PUBLIC"."V1_CHK_IR_ASC" "PUBLIC"."TEST1" Access By ID
  - ............-> Index "TEST1_ASC" Range Scan (full match)
  + ............-> Index "PUBLIC"."TEST1_ASC" Range Scan (full match)
    3 lowered "D" normal
    Query: select * from v1_chk_ir_dec
    Select Expression
    ....-> Filter
  - ........-> Table "TEST1" as "V1_CHK_IR_DEC TEST1" Access By ID
  + ........-> Table "PUBLIC"."TEST1" as "PUBLIC"."V1_CHK_IR_DEC" "PUBLIC"."TEST1" Access By ID
  - ............-> Index "TEST1_DEC" Range Scan (full match)
  + ............-> Index "PUBLIC"."TEST1_DEC" Range Scan (full match)
    3 lowered "D" normal
    Query: select * from v2_chk_nr
    Select Expression
    ....-> Sort (record length: NN, key length: MM)
    ........-> Filter
  - ............-> Table "TEST2" as "V2_CHK_NR TEST2" Full Scan
  + ............-> Table "PUBLIC"."TEST2" as "PUBLIC"."V2_CHK_NR" "PUBLIC"."TEST2" Full Scan
    3 lowered "L" normal
    Query: select * from v2_chk_ir_asc
    Select Expression
    ....-> Filter
  - ........-> Table "TEST2" as "V2_CHK_IR_ASC TEST2" Access By ID
  + ........-> Table "PUBLIC"."TEST2" as "PUBLIC"."V2_CHK_IR_ASC" "PUBLIC"."TEST2" Access By ID
  - ............-> Index "TEST2_PARTIAL_ASC" Full Scan
  + ............-> Index "PUBLIC"."TEST2_PARTIAL_ASC" Full Scan
    3 lowered "L" normal
    Query: select * from v2_chk_ir_dec
    Select Expression
    ....-> Sort (record length: NN, key length: MM)
    ........-> Filter
  - ............-> Table "TEST2" as "V2_CHK_IR_DEC TEST2" Access By ID
  + ............-> Table "PUBLIC"."TEST2" as "PUBLIC"."V2_CHK_IR_DEC" "PUBLIC"."TEST2" Access By ID
    ................-> Bitmap
  - ....................-> Index "TEST2_PARTIAL_ASC" Full Scan
  + ....................-> Index "PUBLIC"."TEST2_PARTIAL_ASC" Full Scan
    3 lowered "L" normal
    After alter domain dm_utf8 type varchar(1) character set utf8 collate unicode_ci:
    Query: select * from v1_chk_nr
    Select Expression
    ....-> Sort (record length: NN, key length: MM)
    ........-> Filter
  - ............-> Table "TEST1" as "V1_CHK_NR TEST1" Full Scan
  + ............-> Table "PUBLIC"."TEST1" as "PUBLIC"."V1_CHK_NR" "PUBLIC"."TEST1" Full Scan
    3 lowered "D" normal
    4 UPPERED "D" normal
    Query: select * from v1_chk_ir_asc
    Select Expression
    ....-> Filter
  - ........-> Table "TEST1" as "V1_CHK_IR_ASC TEST1" Access By ID
  + ........-> Table "PUBLIC"."TEST1" as "PUBLIC"."V1_CHK_IR_ASC" "PUBLIC"."TEST1" Access By ID
  - ............-> Index "TEST1_ASC" Range Scan (full match)
  + ............-> Index "PUBLIC"."TEST1_ASC" Range Scan (full match)
    3 lowered "D" normal
    4 UPPERED "D" normal
    Query: select * from v1_chk_ir_dec
    Select Expression
    ....-> Filter
  - ........-> Table "TEST1" as "V1_CHK_IR_DEC TEST1" Access By ID
  + ........-> Table "PUBLIC"."TEST1" as "PUBLIC"."V1_CHK_IR_DEC" "PUBLIC"."TEST1" Access By ID
  - ............-> Index "TEST1_DEC" Range Scan (full match)
  + ............-> Index "PUBLIC"."TEST1_DEC" Range Scan (full match)
    4 UPPERED "D" normal
    3 lowered "D" normal
    Query: select * from v2_chk_nr
    Select Expression
    ....-> Sort (record length: NN, key length: MM)
    ........-> Filter
  - ............-> Table "TEST2" as "V2_CHK_NR TEST2" Full Scan
  + ............-> Table "PUBLIC"."TEST2" as "PUBLIC"."V2_CHK_NR" "PUBLIC"."TEST2" Full Scan
    3 lowered "L" normal
    4 UPPERED "L" normal
    Query: select * from v2_chk_ir_asc
    Select Expression
    ....-> Filter
  - ........-> Table "TEST2" as "V2_CHK_IR_ASC TEST2" Access By ID
  + ........-> Table "PUBLIC"."TEST2" as "PUBLIC"."V2_CHK_IR_ASC" "PUBLIC"."TEST2" Access By ID
  - ............-> Index "TEST2_PARTIAL_ASC" Full Scan
  + ............-> Index "PUBLIC"."TEST2_PARTIAL_ASC" Full Scan
    3 lowered "L" normal
    4 UPPERED "L" normal
    Query: select * from v2_chk_ir_dec
    Select Expression
    ....-> Sort (record length: NN, key length: MM)
    ........-> Filter
  - ............-> Table "TEST2" as "V2_CHK_IR_DEC TEST2" Access By ID
  + ............-> Table "PUBLIC"."TEST2" as "PUBLIC"."V2_CHK_IR_DEC" "PUBLIC"."TEST2" Access By ID
    ................-> Bitmap
  - ....................-> Index "TEST2_PARTIAL_ASC" Full Scan
  + ....................-> Index "PUBLIC"."TEST2_PARTIAL_ASC" Full Scan
    4 UPPERED "L" normal
    3 lowered "L" normal
    After alter domain dm_utf8 type varchar(1) character set utf8 collate unicode_ci_ai:
    Query: select * from v1_chk_nr
    Select Expression
    ....-> Sort (record length: NN, key length: MM)
    ........-> Filter
  - ............-> Table "TEST1" as "V1_CHK_NR TEST1" Full Scan
  + ............-> Table "PUBLIC"."TEST1" as "PUBLIC"."V1_CHK_NR" "PUBLIC"."TEST1" Full Scan
    1 lowered "D" w/accent
    2 UPPERED "D" w/accent
    3 lowered "D" normal
    4 UPPERED "D" normal
    Query: select * from v1_chk_ir_asc
    Select Expression
    ....-> Filter
  - ........-> Table "TEST1" as "V1_CHK_IR_ASC TEST1" Access By ID
  + ........-> Table "PUBLIC"."TEST1" as "PUBLIC"."V1_CHK_IR_ASC" "PUBLIC"."TEST1" Access By ID
  - ............-> Index "TEST1_ASC" Range Scan (full match)
  + ............-> Index "PUBLIC"."TEST1_ASC" Range Scan (full match)
    3 lowered "D" normal
    4 UPPERED "D" normal
    1 lowered "D" w/accent
    2 UPPERED "D" w/accent
    Query: select * from v1_chk_ir_dec
    Select Expression
    ....-> Filter
  - ........-> Table "TEST1" as "V1_CHK_IR_DEC TEST1" Access By ID
  + ........-> Table "PUBLIC"."TEST1" as "PUBLIC"."V1_CHK_IR_DEC" "PUBLIC"."TEST1" Access By ID
  - ............-> Index "TEST1_DEC" Range Scan (full match)
  + ............-> Index "PUBLIC"."TEST1_DEC" Range Scan (full match)
    2 UPPERED "D" w/accent
    1 lowered "D" w/accent
    4 UPPERED "D" normal
    3 lowered "D" normal
    Query: select * from v2_chk_nr
    Select Expression
    ....-> Sort (record length: NN, key length: MM)
    ........-> Filter
  - ............-> Table "TEST2" as "V2_CHK_NR TEST2" Full Scan
  + ............-> Table "PUBLIC"."TEST2" as "PUBLIC"."V2_CHK_NR" "PUBLIC"."TEST2" Full Scan
    1 lowered "L" w/accent
    2 UPPERED "L" w/accent
    3 lowered "L" normal
    4 UPPERED "L" normal
    Query: select * from v2_chk_ir_asc
    Select Expression
    ....-> Filter
  - ........-> Table "TEST2" as "V2_CHK_IR_ASC TEST2" Access By ID
  + ........-> Table "PUBLIC"."TEST2" as "PUBLIC"."V2_CHK_IR_ASC" "PUBLIC"."TEST2" Access By ID
  - ............-> Index "TEST2_PARTIAL_ASC" Full Scan
  + ............-> Index "PUBLIC"."TEST2_PARTIAL_ASC" Full Scan
    3 lowered "L" normal
    4 UPPERED "L" normal
    1 lowered "L" w/accent
    2 UPPERED "L" w/accent
    Query: select * from v2_chk_ir_dec
    Select Expression
    ....-> Sort (record length: NN, key length: MM)
    ........-> Filter
  - ............-> Table "TEST2" as "V2_CHK_IR_DEC TEST2" Access By ID
  + ............-> Table "PUBLIC"."TEST2" as "PUBLIC"."V2_CHK_IR_DEC" "PUBLIC"."TEST2" Access By ID
    ................-> Bitmap
  - ....................-> Index "TEST2_PARTIAL_ASC" Full Scan
  + ....................-> Index "PUBLIC"."TEST2_PARTIAL_ASC" Full Scan
    2 UPPERED "L" w/accent
    1 lowered "L" w/accent
    4 UPPERED "L" normal
    3 lowered "L" normal
    After alter domain dm_utf8 type varchar(1) character set utf8:
    Query: select * from v1_chk_nr
    Select Expression
    ....-> Sort (record length: NN, key length: MM)
    ........-> Filter
  - ............-> Table "TEST1" as "V1_CHK_NR TEST1" Full Scan
  + ............-> Table "PUBLIC"."TEST1" as "PUBLIC"."V1_CHK_NR" "PUBLIC"."TEST1" Full Scan
    3 lowered "D" normal
    Query: select * from v1_chk_ir_asc
    Select Expression
    ....-> Filter
  - ........-> Table "TEST1" as "V1_CHK_IR_ASC TEST1" Access By ID
  + ........-> Table "PUBLIC"."TEST1" as "PUBLIC"."V1_CHK_IR_ASC" "PUBLIC"."TEST1" Access By ID
  - ............-> Index "TEST1_ASC" Range Scan (full match)
  + ............-> Index "PUBLIC"."TEST1_ASC" Range Scan (full match)
    3 lowered "D" normal
    Query: select * from v1_chk_ir_dec
    Select Expression
    ....-> Filter
  - ........-> Table "TEST1" as "V1_CHK_IR_DEC TEST1" Access By ID
  + ........-> Table "PUBLIC"."TEST1" as "PUBLIC"."V1_CHK_IR_DEC" "PUBLIC"."TEST1" Access By ID
  - ............-> Index "TEST1_DEC" Range Scan (full match)
  + ............-> Index "PUBLIC"."TEST1_DEC" Range Scan (full match)
    3 lowered "D" normal
    Query: select * from v2_chk_nr
    Select Expression
    ....-> Sort (record length: NN, key length: MM)
    ........-> Filter
  - ............-> Table "TEST2" as "V2_CHK_NR TEST2" Full Scan
  + ............-> Table "PUBLIC"."TEST2" as "PUBLIC"."V2_CHK_NR" "PUBLIC"."TEST2" Full Scan
    3 lowered "L" normal
    Query: select * from v2_chk_ir_asc
    Select Expression
    ....-> Filter
  - ........-> Table "TEST2" as "V2_CHK_IR_ASC TEST2" Access By ID
  + ........-> Table "PUBLIC"."TEST2" as "PUBLIC"."V2_CHK_IR_ASC" "PUBLIC"."TEST2" Access By ID
  - ............-> Index "TEST2_PARTIAL_ASC" Full Scan
  + ............-> Index "PUBLIC"."TEST2_PARTIAL_ASC" Full Scan
    3 lowered "L" normal
    Query: select * from v2_chk_ir_dec
    Select Expression
    ....-> Sort (record length: NN, key length: MM)
    ........-> Filter
  - ............-> Table "TEST2" as "V2_CHK_IR_DEC TEST2" Access By ID
  + ............-> Table "PUBLIC"."TEST2" as "PUBLIC"."V2_CHK_IR_DEC" "PUBLIC"."TEST2" Access By ID
    ................-> Bitmap
  - ....................-> Index "TEST2_PARTIAL_ASC" Full Scan
  + ....................-> Index "PUBLIC"."TEST2_PARTIAL_ASC" Full Scan
    3 lowered "L" normal

LOG DETAILS:

2025-07-03 05:19:34.754
2025-07-03 05:19:34.760 act = <firebird.qa.plugin.Action object at [hex]>
2025-07-03 05:19:34.767 capsys = <_pytest.capture.CaptureFixture object at [hex]>
2025-07-03 05:19:34.774
2025-07-03 05:19:34.782 @pytest.mark.version('>=6')
2025-07-03 05:19:34.793 def test_1(act: Action, capsys):
2025-07-03 05:19:34.802 qry_map = {
2025-07-03 05:19:34.808 1 : 'select * from v1_chk_nr'
2025-07-03 05:19:34.814 ,2 : 'select * from v1_chk_ir_asc'
2025-07-03 05:19:34.821 ,3 : 'select * from v1_chk_ir_dec'
2025-07-03 05:19:34.828 ,4 : 'select * from v2_chk_nr'
2025-07-03 05:19:34.835 ,5 : 'select * from v2_chk_ir_asc'
2025-07-03 05:19:34.842 ,6 : 'select * from v2_chk_ir_dec'
2025-07-03 05:19:34.853 }
2025-07-03 05:19:34.862
2025-07-03 05:19:34.870 alter_lst = (
2025-07-03 05:19:34.877 ''
2025-07-03 05:19:34.883 ,'alter domain dm_utf8 type varchar(1) character set utf8 collate unicode_ci'
2025-07-03 05:19:34.890 ,'alter domain dm_utf8 type varchar(1) character set utf8 collate unicode_ci_ai'
2025-07-03 05:19:34.896 ,'alter domain dm_utf8 type varchar(1) character set utf8'
2025-07-03 05:19:34.902 )
2025-07-03 05:19:34.910
2025-07-03 05:19:34.918 with act.db.connect(charset = 'utf8') as con:
2025-07-03 05:19:34.924 cur = con.cursor()
2025-07-03 05:19:34.930 for alter_i in alter_lst:
2025-07-03 05:19:34.934 if alter_i.strip():
2025-07-03 05:19:34.940 con.execute_immediate(alter_i)
2025-07-03 05:19:34.946 con.commit()
2025-07-03 05:19:34.952 print(f'\nAfter {alter_i}:')
2025-07-03 05:19:34.958 else:
2025-07-03 05:19:34.966 print('Initial state:')
2025-07-03 05:19:34.973
2025-07-03 05:19:34.979 for k, v in qry_map.items():
2025-07-03 05:19:34.986 ps, rs = None, None
2025-07-03 05:19:34.993 try:
2025-07-03 05:19:34.999 ps = cur.prepare(v)
2025-07-03 05:19:35.011
2025-07-03 05:19:35.018 print('Query:', v)
2025-07-03 05:19:35.025 # Print explained plan with padding eash line by dots in order to see indentations:
2025-07-03 05:19:35.031 print( '\n'.join([replace_leading(s) for s in ps.detailed_plan.split('\n')]) )
2025-07-03 05:19:35.036 print('')
2025-07-03 05:19:35.040
2025-07-03 05:19:35.044 # ::: NB ::: 'ps' returns data, i.e. this is SELECTABLE expression.
2025-07-03 05:19:35.049 # We have to store result of cur.execute(<psInstance>) in order to
2025-07-03 05:19:35.053 # close it explicitly.
2025-07-03 05:19:35.058 # Otherwise AV can occur during Python garbage collection and this
2025-07-03 05:19:35.062 # causes pytest to hang on its final point.
2025-07-03 05:19:35.067 # Explained by hvlad, email 26.10.24 17:42
2025-07-03 05:19:35.071 rs = cur.execute(ps)
2025-07-03 05:19:35.075 for r in rs:
2025-07-03 05:19:35.080 print(r[0], r[1])
2025-07-03 05:19:35.084 except DatabaseError as e:
2025-07-03 05:19:35.089 print(e.__str__())
2025-07-03 05:19:35.093 print(e.gds_codes)
2025-07-03 05:19:35.097 finally:
2025-07-03 05:19:35.102 if rs:
2025-07-03 05:19:35.109 rs.close() # <<< EXPLICITLY CLOSING CURSOR RESULTS
2025-07-03 05:19:35.115 if ps:
2025-07-03 05:19:35.127 ps.free()
2025-07-03 05:19:35.135
2025-07-03 05:19:35.141
2025-07-03 05:19:35.145 expected_stdout = """
2025-07-03 05:19:35.150 Initial state:
2025-07-03 05:19:35.154
2025-07-03 05:19:35.160 Query: select * from v1_chk_nr
2025-07-03 05:19:35.167 Select Expression
2025-07-03 05:19:35.173 ....-> Sort (record length: NN, key length: MM)
2025-07-03 05:19:35.179 ........-> Filter
2025-07-03 05:19:35.186 ............-> Table "TEST1" as "V1_CHK_NR TEST1" Full Scan
2025-07-03 05:19:35.192 3 lowered "D" normal
2025-07-03 05:19:35.199 Query: select * from v1_chk_ir_asc
2025-07-03 05:19:35.211 Select Expression
2025-07-03 05:19:35.219 ....-> Filter
2025-07-03 05:19:35.226 ........-> Table "TEST1" as "V1_CHK_IR_ASC TEST1" Access By ID
2025-07-03 05:19:35.232 ............-> Index "TEST1_ASC" Range Scan (full match)
2025-07-03 05:19:35.238 3 lowered "D" normal
2025-07-03 05:19:35.244 Query: select * from v1_chk_ir_dec
2025-07-03 05:19:35.250 Select Expression
2025-07-03 05:19:35.263 ....-> Filter
2025-07-03 05:19:35.273 ........-> Table "TEST1" as "V1_CHK_IR_DEC TEST1" Access By ID
2025-07-03 05:19:35.281 ............-> Index "TEST1_DEC" Range Scan (full match)
2025-07-03 05:19:35.287 3 lowered "D" normal
2025-07-03 05:19:35.293 Query: select * from v2_chk_nr
2025-07-03 05:19:35.297 Select Expression
2025-07-03 05:19:35.302 ....-> Sort (record length: NN, key length: MM)
2025-07-03 05:19:35.306 ........-> Filter
2025-07-03 05:19:35.312 ............-> Table "TEST2" as "V2_CHK_NR TEST2" Full Scan
2025-07-03 05:19:35.318 3 lowered "L" normal
2025-07-03 05:19:35.323 Query: select * from v2_chk_ir_asc
2025-07-03 05:19:35.330 Select Expression
2025-07-03 05:19:35.336 ....-> Filter
2025-07-03 05:19:35.343 ........-> Table "TEST2" as "V2_CHK_IR_ASC TEST2" Access By ID
2025-07-03 05:19:35.349 ............-> Index "TEST2_PARTIAL_ASC" Full Scan
2025-07-03 05:19:35.356 3 lowered "L" normal
2025-07-03 05:19:35.364 Query: select * from v2_chk_ir_dec
2025-07-03 05:19:35.370 Select Expression
2025-07-03 05:19:35.377 ....-> Sort (record length: NN, key length: MM)
2025-07-03 05:19:35.384 ........-> Filter
2025-07-03 05:19:35.391 ............-> Table "TEST2" as "V2_CHK_IR_DEC TEST2" Access By ID
2025-07-03 05:19:35.398 ................-> Bitmap
2025-07-03 05:19:35.405 ....................-> Index "TEST2_PARTIAL_ASC" Full Scan
2025-07-03 05:19:35.411 3 lowered "L" normal
2025-07-03 05:19:35.418
2025-07-03 05:19:35.424
2025-07-03 05:19:35.431 After alter domain dm_utf8 type varchar(1) character set utf8 collate unicode_ci:
2025-07-03 05:19:35.438
2025-07-03 05:19:35.445 Query: select * from v1_chk_nr
2025-07-03 05:19:35.451 Select Expression
2025-07-03 05:19:35.458 ....-> Sort (record length: NN, key length: MM)
2025-07-03 05:19:35.463 ........-> Filter
2025-07-03 05:19:35.469 ............-> Table "TEST1" as "V1_CHK_NR TEST1" Full Scan
2025-07-03 05:19:35.474 3 lowered "D" normal
2025-07-03 05:19:35.479 4 UPPERED "D" normal
2025-07-03 05:19:35.485 Query: select * from v1_chk_ir_asc
2025-07-03 05:19:35.491 Select Expression
2025-07-03 05:19:35.497 ....-> Filter
2025-07-03 05:19:35.503 ........-> Table "TEST1" as "V1_CHK_IR_ASC TEST1" Access By ID
2025-07-03 05:19:35.509 ............-> Index "TEST1_ASC" Range Scan (full match)
2025-07-03 05:19:35.515 3 lowered "D" normal
2025-07-03 05:19:35.521 4 UPPERED "D" normal
2025-07-03 05:19:35.528 Query: select * from v1_chk_ir_dec
2025-07-03 05:19:35.533 Select Expression
2025-07-03 05:19:35.539 ....-> Filter
2025-07-03 05:19:35.545 ........-> Table "TEST1" as "V1_CHK_IR_DEC TEST1" Access By ID
2025-07-03 05:19:35.550 ............-> Index "TEST1_DEC" Range Scan (full match)
2025-07-03 05:19:35.555 4 UPPERED "D" normal
2025-07-03 05:19:35.559 3 lowered "D" normal
2025-07-03 05:19:35.564 Query: select * from v2_chk_nr
2025-07-03 05:19:35.569 Select Expression
2025-07-03 05:19:35.573 ....-> Sort (record length: NN, key length: MM)
2025-07-03 05:19:35.578 ........-> Filter
2025-07-03 05:19:35.583 ............-> Table "TEST2" as "V2_CHK_NR TEST2" Full Scan
2025-07-03 05:19:35.587 3 lowered "L" normal
2025-07-03 05:19:35.592 4 UPPERED "L" normal
2025-07-03 05:19:35.597 Query: select * from v2_chk_ir_asc
2025-07-03 05:19:35.601 Select Expression
2025-07-03 05:19:35.605 ....-> Filter
2025-07-03 05:19:35.610 ........-> Table "TEST2" as "V2_CHK_IR_ASC TEST2" Access By ID
2025-07-03 05:19:35.615 ............-> Index "TEST2_PARTIAL_ASC" Full Scan
2025-07-03 05:19:35.619 3 lowered "L" normal
2025-07-03 05:19:35.624 4 UPPERED "L" normal
2025-07-03 05:19:35.630 Query: select * from v2_chk_ir_dec
2025-07-03 05:19:35.636 Select Expression
2025-07-03 05:19:35.644 ....-> Sort (record length: NN, key length: MM)
2025-07-03 05:19:35.651 ........-> Filter
2025-07-03 05:19:35.658 ............-> Table "TEST2" as "V2_CHK_IR_DEC TEST2" Access By ID
2025-07-03 05:19:35.665 ................-> Bitmap
2025-07-03 05:19:35.672 ....................-> Index "TEST2_PARTIAL_ASC" Full Scan
2025-07-03 05:19:35.678 4 UPPERED "L" normal
2025-07-03 05:19:35.690 3 lowered "L" normal
2025-07-03 05:19:35.699
2025-07-03 05:19:35.706
2025-07-03 05:19:35.712 After alter domain dm_utf8 type varchar(1) character set utf8 collate unicode_ci_ai:
2025-07-03 05:19:35.718
2025-07-03 05:19:35.724 Query: select * from v1_chk_nr
2025-07-03 05:19:35.730 Select Expression
2025-07-03 05:19:35.736 ....-> Sort (record length: NN, key length: MM)
2025-07-03 05:19:35.742 ........-> Filter
2025-07-03 05:19:35.751 ............-> Table "TEST1" as "V1_CHK_NR TEST1" Full Scan
2025-07-03 05:19:35.759 1 lowered "D" w/accent
2025-07-03 05:19:35.769 2 UPPERED "D" w/accent
2025-07-03 05:19:35.777 3 lowered "D" normal
2025-07-03 05:19:35.786 4 UPPERED "D" normal
2025-07-03 05:19:35.793 Query: select * from v1_chk_ir_asc
2025-07-03 05:19:35.799 Select Expression
2025-07-03 05:19:35.805 ....-> Filter
2025-07-03 05:19:35.811 ........-> Table "TEST1" as "V1_CHK_IR_ASC TEST1" Access By ID
2025-07-03 05:19:35.816 ............-> Index "TEST1_ASC" Range Scan (full match)
2025-07-03 05:19:35.821 3 lowered "D" normal
2025-07-03 05:19:35.825 4 UPPERED "D" normal
2025-07-03 05:19:35.830 1 lowered "D" w/accent
2025-07-03 05:19:35.835 2 UPPERED "D" w/accent
2025-07-03 05:19:35.841 Query: select * from v1_chk_ir_dec
2025-07-03 05:19:35.852 Select Expression
2025-07-03 05:19:35.859 ....-> Filter
2025-07-03 05:19:35.868 ........-> Table "TEST1" as "V1_CHK_IR_DEC TEST1" Access By ID
2025-07-03 05:19:35.880 ............-> Index "TEST1_DEC" Range Scan (full match)
2025-07-03 05:19:35.890 2 UPPERED "D" w/accent
2025-07-03 05:19:35.899 1 lowered "D" w/accent
2025-07-03 05:19:35.911 4 UPPERED "D" normal
2025-07-03 05:19:35.921 3 lowered "D" normal
2025-07-03 05:19:35.929 Query: select * from v2_chk_nr
2025-07-03 05:19:35.936 Select Expression
2025-07-03 05:19:35.943 ....-> Sort (record length: NN, key length: MM)
2025-07-03 05:19:35.948 ........-> Filter
2025-07-03 05:19:35.954 ............-> Table "TEST2" as "V2_CHK_NR TEST2" Full Scan
2025-07-03 05:19:35.962 1 lowered "L" w/accent
2025-07-03 05:19:35.969 2 UPPERED "L" w/accent
2025-07-03 05:19:35.974 3 lowered "L" normal
2025-07-03 05:19:35.980 4 UPPERED "L" normal
2025-07-03 05:19:35.986 Query: select * from v2_chk_ir_asc
2025-07-03 05:19:35.992 Select Expression
2025-07-03 05:19:35.998 ....-> Filter
2025-07-03 05:19:36.004 ........-> Table "TEST2" as "V2_CHK_IR_ASC TEST2" Access By ID
2025-07-03 05:19:36.010 ............-> Index "TEST2_PARTIAL_ASC" Full Scan
2025-07-03 05:19:36.016 3 lowered "L" normal
2025-07-03 05:19:36.021 4 UPPERED "L" normal
2025-07-03 05:19:36.027 1 lowered "L" w/accent
2025-07-03 05:19:36.032 2 UPPERED "L" w/accent
2025-07-03 05:19:36.038 Query: select * from v2_chk_ir_dec
2025-07-03 05:19:36.044 Select Expression
2025-07-03 05:19:36.051 ....-> Sort (record length: NN, key length: MM)
2025-07-03 05:19:36.058 ........-> Filter
2025-07-03 05:19:36.065 ............-> Table "TEST2" as "V2_CHK_IR_DEC TEST2" Access By ID
2025-07-03 05:19:36.071 ................-> Bitmap
2025-07-03 05:19:36.077 ....................-> Index "TEST2_PARTIAL_ASC" Full Scan
2025-07-03 05:19:36.082 2 UPPERED "L" w/accent
2025-07-03 05:19:36.089 1 lowered "L" w/accent
2025-07-03 05:19:36.095 4 UPPERED "L" normal
2025-07-03 05:19:36.101 3 lowered "L" normal
2025-07-03 05:19:36.107
2025-07-03 05:19:36.113
2025-07-03 05:19:36.119 After alter domain dm_utf8 type varchar(1) character set utf8:
2025-07-03 05:19:36.126
2025-07-03 05:19:36.132 Query: select * from v1_chk_nr
2025-07-03 05:19:36.138 Select Expression
2025-07-03 05:19:36.145 ....-> Sort (record length: NN, key length: MM)
2025-07-03 05:19:36.152 ........-> Filter
2025-07-03 05:19:36.166 ............-> Table "TEST1" as "V1_CHK_NR TEST1" Full Scan
2025-07-03 05:19:36.174 3 lowered "D" normal
2025-07-03 05:19:36.186 Query: select * from v1_chk_ir_asc
2025-07-03 05:19:36.197 Select Expression
2025-07-03 05:19:36.205 ....-> Filter
2025-07-03 05:19:36.217 ........-> Table "TEST1" as "V1_CHK_IR_ASC TEST1" Access By ID
2025-07-03 05:19:36.227 ............-> Index "TEST1_ASC" Range Scan (full match)
2025-07-03 05:19:36.235 3 lowered "D" normal
2025-07-03 05:19:36.241 Query: select * from v1_chk_ir_dec
2025-07-03 05:19:36.248 Select Expression
2025-07-03 05:19:36.254 ....-> Filter
2025-07-03 05:19:36.260 ........-> Table "TEST1" as "V1_CHK_IR_DEC TEST1" Access By ID
2025-07-03 05:19:36.267 ............-> Index "TEST1_DEC" Range Scan (full match)
2025-07-03 05:19:36.273 3 lowered "D" normal
2025-07-03 05:19:36.279 Query: select * from v2_chk_nr
2025-07-03 05:19:36.286 Select Expression
2025-07-03 05:19:36.292 ....-> Sort (record length: NN, key length: MM)
2025-07-03 05:19:36.298 ........-> Filter
2025-07-03 05:19:36.311 ............-> Table "TEST2" as "V2_CHK_NR TEST2" Full Scan
2025-07-03 05:19:36.322 3 lowered "L" normal
2025-07-03 05:19:36.330 Query: select * from v2_chk_ir_asc
2025-07-03 05:19:36.337 Select Expression
2025-07-03 05:19:36.343 ....-> Filter
2025-07-03 05:19:36.350 ........-> Table "TEST2" as "V2_CHK_IR_ASC TEST2" Access By ID
2025-07-03 05:19:36.356 ............-> Index "TEST2_PARTIAL_ASC" Full Scan
2025-07-03 05:19:36.362 3 lowered "L" normal
2025-07-03 05:19:36.368 Query: select * from v2_chk_ir_dec
2025-07-03 05:19:36.374 Select Expression
2025-07-03 05:19:36.380 ....-> Sort (record length: NN, key length: MM)
2025-07-03 05:19:36.386 ........-> Filter
2025-07-03 05:19:36.392 ............-> Table "TEST2" as "V2_CHK_IR_DEC TEST2" Access By ID
2025-07-03 05:19:36.398 ................-> Bitmap
2025-07-03 05:19:36.405 ....................-> Index "TEST2_PARTIAL_ASC" Full Scan
2025-07-03 05:19:36.412 3 lowered "L" normal
2025-07-03 05:19:36.418 """
2025-07-03 05:19:36.423
2025-07-03 05:19:36.429 act.expected_stdout = expected_stdout
2025-07-03 05:19:36.435
2025-07-03 05:19:36.440 act.stdout = capsys.readouterr().out
2025-07-03 05:19:36.446 >       assert act.clean_stdout == act.clean_expected_stdout
2025-07-03 05:19:36.452 E       assert
2025-07-03 05:19:36.457 E           Initial state:
2025-07-03 05:19:36.463 E           Query: select * from v1_chk_nr
2025-07-03 05:19:36.469 E           Select Expression
2025-07-03 05:19:36.475 E           ....-> Sort (record length: NN, key length: MM)
2025-07-03 05:19:36.482 E           ........-> Filter
2025-07-03 05:19:36.488 E         - ............-> Table "TEST1" as "V1_CHK_NR TEST1" Full Scan
2025-07-03 05:19:36.500 E         + ............-> Table "PUBLIC"."TEST1" as "PUBLIC"."V1_CHK_NR" "PUBLIC"."TEST1" Full Scan
2025-07-03 05:19:36.514 E           3 lowered "D" normal
2025-07-03 05:19:36.521 E           Query: select * from v1_chk_ir_asc
2025-07-03 05:19:36.527 E           Select Expression
2025-07-03 05:19:36.533 E           ....-> Filter
2025-07-03 05:19:36.539 E         - ........-> Table "TEST1" as "V1_CHK_IR_ASC TEST1" Access By ID
2025-07-03 05:19:36.548 E         + ........-> Table "PUBLIC"."TEST1" as "PUBLIC"."V1_CHK_IR_ASC" "PUBLIC"."TEST1" Access By ID
2025-07-03 05:19:36.558 E         - ............-> Index "TEST1_ASC" Range Scan (full match)
2025-07-03 05:19:36.563 E         + ............-> Index "PUBLIC"."TEST1_ASC" Range Scan (full match)
2025-07-03 05:19:36.577 E           3 lowered "D" normal
2025-07-03 05:19:36.585 E           Query: select * from v1_chk_ir_dec
2025-07-03 05:19:36.592 E           Select Expression
2025-07-03 05:19:36.601 E           ....-> Filter
2025-07-03 05:19:36.610 E         - ........-> Table "TEST1" as "V1_CHK_IR_DEC TEST1" Access By ID
2025-07-03 05:19:36.628 E         + ........-> Table "PUBLIC"."TEST1" as "PUBLIC"."V1_CHK_IR_DEC" "PUBLIC"."TEST1" Access By ID
2025-07-03 05:19:36.641 E         - ............-> Index "TEST1_DEC" Range Scan (full match)
2025-07-03 05:19:36.647 E         + ............-> Index "PUBLIC"."TEST1_DEC" Range Scan (full match)
2025-07-03 05:19:36.661 E           3 lowered "D" normal
2025-07-03 05:19:36.668 E           Query: select * from v2_chk_nr
2025-07-03 05:19:36.675 E           Select Expression
2025-07-03 05:19:36.682 E           ....-> Sort (record length: NN, key length: MM)
2025-07-03 05:19:36.688 E           ........-> Filter
2025-07-03 05:19:36.694 E         - ............-> Table "TEST2" as "V2_CHK_NR TEST2" Full Scan
2025-07-03 05:19:36.708 E         + ............-> Table "PUBLIC"."TEST2" as "PUBLIC"."V2_CHK_NR" "PUBLIC"."TEST2" Full Scan
2025-07-03 05:19:36.723 E           3 lowered "L" normal
2025-07-03 05:19:36.735 E           Query: select * from v2_chk_ir_asc
2025-07-03 05:19:36.745 E           Select Expression
2025-07-03 05:19:36.752 E           ....-> Filter
2025-07-03 05:19:36.758 E         - ........-> Table "TEST2" as "V2_CHK_IR_ASC TEST2" Access By ID
2025-07-03 05:19:36.778 E         + ........-> Table "PUBLIC"."TEST2" as "PUBLIC"."V2_CHK_IR_ASC" "PUBLIC"."TEST2" Access By ID
2025-07-03 05:19:36.793 E         - ............-> Index "TEST2_PARTIAL_ASC" Full Scan
2025-07-03 05:19:36.802 E         + ............-> Index "PUBLIC"."TEST2_PARTIAL_ASC" Full Scan
2025-07-03 05:19:36.821 E           3 lowered "L" normal
2025-07-03 05:19:36.829 E           Query: select * from v2_chk_ir_dec
2025-07-03 05:19:36.836 E           Select Expression
2025-07-03 05:19:36.843 E           ....-> Sort (record length: NN, key length: MM)
2025-07-03 05:19:36.849 E           ........-> Filter
2025-07-03 05:19:36.855 E         - ............-> Table "TEST2" as "V2_CHK_IR_DEC TEST2" Access By ID
2025-07-03 05:19:36.873 E         + ............-> Table "PUBLIC"."TEST2" as "PUBLIC"."V2_CHK_IR_DEC" "PUBLIC"."TEST2" Access By ID
2025-07-03 05:19:36.889 E           ................-> Bitmap
2025-07-03 05:19:36.895 E         - ....................-> Index "TEST2_PARTIAL_ASC" Full Scan
2025-07-03 05:19:36.903 E         + ....................-> Index "PUBLIC"."TEST2_PARTIAL_ASC" Full Scan
2025-07-03 05:19:36.921 E           3 lowered "L" normal
2025-07-03 05:19:36.929 E           After alter domain dm_utf8 type varchar(1) character set utf8 collate unicode_ci:
2025-07-03 05:19:36.936 E           Query: select * from v1_chk_nr
2025-07-03 05:19:36.942 E           Select Expression
2025-07-03 05:19:36.951 E           ....-> Sort (record length: NN, key length: MM)
2025-07-03 05:19:36.958 E           ........-> Filter
2025-07-03 05:19:36.969 E         - ............-> Table "TEST1" as "V1_CHK_NR TEST1" Full Scan
2025-07-03 05:19:36.986 E         + ............-> Table "PUBLIC"."TEST1" as "PUBLIC"."V1_CHK_NR" "PUBLIC"."TEST1" Full Scan
2025-07-03 05:19:37.000 E           3 lowered "D" normal
2025-07-03 05:19:37.007 E           4 UPPERED "D" normal
2025-07-03 05:19:37.012 E           Query: select * from v1_chk_ir_asc
2025-07-03 05:19:37.018 E           Select Expression
2025-07-03 05:19:37.028 E           ....-> Filter
2025-07-03 05:19:37.038 E         - ........-> Table "TEST1" as "V1_CHK_IR_ASC TEST1" Access By ID
2025-07-03 05:19:37.054 E         + ........-> Table "PUBLIC"."TEST1" as "PUBLIC"."V1_CHK_IR_ASC" "PUBLIC"."TEST1" Access By ID
2025-07-03 05:19:37.071 E         - ............-> Index "TEST1_ASC" Range Scan (full match)
2025-07-03 05:19:37.081 E         + ............-> Index "PUBLIC"."TEST1_ASC" Range Scan (full match)
2025-07-03 05:19:37.104 E           3 lowered "D" normal
2025-07-03 05:19:37.111 E           4 UPPERED "D" normal
2025-07-03 05:19:37.119 E           Query: select * from v1_chk_ir_dec
2025-07-03 05:19:37.127 E           Select Expression
2025-07-03 05:19:37.134 E           ....-> Filter
2025-07-03 05:19:37.143 E         - ........-> Table "TEST1" as "V1_CHK_IR_DEC TEST1" Access By ID
2025-07-03 05:19:37.165 E         + ........-> Table "PUBLIC"."TEST1" as "PUBLIC"."V1_CHK_IR_DEC" "PUBLIC"."TEST1" Access By ID
2025-07-03 05:19:37.188 E         - ............-> Index "TEST1_DEC" Range Scan (full match)
2025-07-03 05:19:37.194 E         + ............-> Index "PUBLIC"."TEST1_DEC" Range Scan (full match)
2025-07-03 05:19:37.217 E           4 UPPERED "D" normal
2025-07-03 05:19:37.228 E           3 lowered "D" normal
2025-07-03 05:19:37.237 E           Query: select * from v2_chk_nr
2025-07-03 05:19:37.244 E           Select Expression
2025-07-03 05:19:37.251 E           ....-> Sort (record length: NN, key length: MM)
2025-07-03 05:19:37.259 E           ........-> Filter
2025-07-03 05:19:37.270 E         - ............-> Table "TEST2" as "V2_CHK_NR TEST2" Full Scan
2025-07-03 05:19:37.289 E         + ............-> Table "PUBLIC"."TEST2" as "PUBLIC"."V2_CHK_NR" "PUBLIC"."TEST2" Full Scan
2025-07-03 05:19:37.302 E           3 lowered "L" normal
2025-07-03 05:19:37.309 E           4 UPPERED "L" normal
2025-07-03 05:19:37.315 E           Query: select * from v2_chk_ir_asc
2025-07-03 05:19:37.320 E           Select Expression
2025-07-03 05:19:37.325 E           ....-> Filter
2025-07-03 05:19:37.331 E         - ........-> Table "TEST2" as "V2_CHK_IR_ASC TEST2" Access By ID
2025-07-03 05:19:37.349 E         + ........-> Table "PUBLIC"."TEST2" as "PUBLIC"."V2_CHK_IR_ASC" "PUBLIC"."TEST2" Access By ID
2025-07-03 05:19:37.367 E         - ............-> Index "TEST2_PARTIAL_ASC" Full Scan
2025-07-03 05:19:37.373 E         + ............-> Index "PUBLIC"."TEST2_PARTIAL_ASC" Full Scan
2025-07-03 05:19:37.389 E           3 lowered "L" normal
2025-07-03 05:19:37.402 E           4 UPPERED "L" normal
2025-07-03 05:19:37.412 E           Query: select * from v2_chk_ir_dec
2025-07-03 05:19:37.419 E           Select Expression
2025-07-03 05:19:37.424 E           ....-> Sort (record length: NN, key length: MM)
2025-07-03 05:19:37.430 E           ........-> Filter
2025-07-03 05:19:37.437 E         - ............-> Table "TEST2" as "V2_CHK_IR_DEC TEST2" Access By ID
2025-07-03 05:19:37.452 E         + ............-> Table "PUBLIC"."TEST2" as "PUBLIC"."V2_CHK_IR_DEC" "PUBLIC"."TEST2" Access By ID
2025-07-03 05:19:37.467 E           ................-> Bitmap
2025-07-03 05:19:37.477 E         - ....................-> Index "TEST2_PARTIAL_ASC" Full Scan
2025-07-03 05:19:37.485 E         + ....................-> Index "PUBLIC"."TEST2_PARTIAL_ASC" Full Scan
2025-07-03 05:19:37.499 E           4 UPPERED "L" normal
2025-07-03 05:19:37.507 E           3 lowered "L" normal
2025-07-03 05:19:37.517 E           After alter domain dm_utf8 type varchar(1) character set utf8 collate unicode_ci_ai:
2025-07-03 05:19:37.524 E           Query: select * from v1_chk_nr
2025-07-03 05:19:37.531 E           Select Expression
2025-07-03 05:19:37.537 E           ....-> Sort (record length: NN, key length: MM)
2025-07-03 05:19:37.543 E           ........-> Filter
2025-07-03 05:19:37.551 E         - ............-> Table "TEST1" as "V1_CHK_NR TEST1" Full Scan
2025-07-03 05:19:37.568 E         + ............-> Table "PUBLIC"."TEST1" as "PUBLIC"."V1_CHK_NR" "PUBLIC"."TEST1" Full Scan
2025-07-03 05:19:37.580 E           1 lowered "D" w/accent
2025-07-03 05:19:37.584 E           2 UPPERED "D" w/accent
2025-07-03 05:19:37.589 E           3 lowered "D" normal
2025-07-03 05:19:37.593 E           4 UPPERED "D" normal
2025-07-03 05:19:37.598 E           Query: select * from v1_chk_ir_asc
2025-07-03 05:19:37.602 E           Select Expression
2025-07-03 05:19:37.607 E           ....-> Filter
2025-07-03 05:19:37.612 E         - ........-> Table "TEST1" as "V1_CHK_IR_ASC TEST1" Access By ID
2025-07-03 05:19:37.623 E         + ........-> Table "PUBLIC"."TEST1" as "PUBLIC"."V1_CHK_IR_ASC" "PUBLIC"."TEST1" Access By ID
2025-07-03 05:19:37.635 E         - ............-> Index "TEST1_ASC" Range Scan (full match)
2025-07-03 05:19:37.641 E         + ............-> Index "PUBLIC"."TEST1_ASC" Range Scan (full match)
2025-07-03 05:19:37.654 E           3 lowered "D" normal
2025-07-03 05:19:37.659 E           4 UPPERED "D" normal
2025-07-03 05:19:37.671 E           1 lowered "D" w/accent
2025-07-03 05:19:37.680 E           2 UPPERED "D" w/accent
2025-07-03 05:19:37.687 E           Query: select * from v1_chk_ir_dec
2025-07-03 05:19:37.694 E           Select Expression
2025-07-03 05:19:37.701 E           ....-> Filter
2025-07-03 05:19:37.708 E         - ........-> Table "TEST1" as "V1_CHK_IR_DEC TEST1" Access By ID
2025-07-03 05:19:37.721 E         + ........-> Table "PUBLIC"."TEST1" as "PUBLIC"."V1_CHK_IR_DEC" "PUBLIC"."TEST1" Access By ID
2025-07-03 05:19:37.734 E         - ............-> Index "TEST1_DEC" Range Scan (full match)
2025-07-03 05:19:37.739 E         + ............-> Index "PUBLIC"."TEST1_DEC" Range Scan (full match)
2025-07-03 05:19:37.761 E           2 UPPERED "D" w/accent
2025-07-03 05:19:37.769 E           1 lowered "D" w/accent
2025-07-03 05:19:37.776 E           4 UPPERED "D" normal
2025-07-03 05:19:37.783 E           3 lowered "D" normal
2025-07-03 05:19:37.789 E           Query: select * from v2_chk_nr
2025-07-03 05:19:37.795 E           Select Expression
2025-07-03 05:19:37.800 E           ....-> Sort (record length: NN, key length: MM)
2025-07-03 05:19:37.806 E           ........-> Filter
2025-07-03 05:19:37.812 E         - ............-> Table "TEST2" as "V2_CHK_NR TEST2" Full Scan
2025-07-03 05:19:37.831 E         + ............-> Table "PUBLIC"."TEST2" as "PUBLIC"."V2_CHK_NR" "PUBLIC"."TEST2" Full Scan
2025-07-03 05:19:37.853 E           1 lowered "L" w/accent
2025-07-03 05:19:37.861 E           2 UPPERED "L" w/accent
2025-07-03 05:19:37.868 E           3 lowered "L" normal
2025-07-03 05:19:37.877 E           4 UPPERED "L" normal
2025-07-03 05:19:37.888 E           Query: select * from v2_chk_ir_asc
2025-07-03 05:19:37.896 E           Select Expression
2025-07-03 05:19:37.903 E           ....-> Filter
2025-07-03 05:19:37.909 E         - ........-> Table "TEST2" as "V2_CHK_IR_ASC TEST2" Access By ID
2025-07-03 05:19:37.921 E         + ........-> Table "PUBLIC"."TEST2" as "PUBLIC"."V2_CHK_IR_ASC" "PUBLIC"."TEST2" Access By ID
2025-07-03 05:19:37.934 E         - ............-> Index "TEST2_PARTIAL_ASC" Full Scan
2025-07-03 05:19:37.945 E         + ............-> Index "PUBLIC"."TEST2_PARTIAL_ASC" Full Scan
2025-07-03 05:19:37.958 E           3 lowered "L" normal
2025-07-03 05:19:37.964 E           4 UPPERED "L" normal
2025-07-03 05:19:37.970 E           1 lowered "L" w/accent
2025-07-03 05:19:37.976 E           2 UPPERED "L" w/accent
2025-07-03 05:19:37.982 E           Query: select * from v2_chk_ir_dec
2025-07-03 05:19:37.993 E           Select Expression
2025-07-03 05:19:38.001 E           ....-> Sort (record length: NN, key length: MM)
2025-07-03 05:19:38.007 E           ........-> Filter
2025-07-03 05:19:38.013 E         - ............-> Table "TEST2" as "V2_CHK_IR_DEC TEST2" Access By ID
2025-07-03 05:19:38.025 E         + ............-> Table "PUBLIC"."TEST2" as "PUBLIC"."V2_CHK_IR_DEC" "PUBLIC"."TEST2" Access By ID
2025-07-03 05:19:38.043 E           ................-> Bitmap
2025-07-03 05:19:38.050 E         - ....................-> Index "TEST2_PARTIAL_ASC" Full Scan
2025-07-03 05:19:38.056 E         + ....................-> Index "PUBLIC"."TEST2_PARTIAL_ASC" Full Scan
2025-07-03 05:19:38.068 E           2 UPPERED "L" w/accent
2025-07-03 05:19:38.074 E           1 lowered "L" w/accent
2025-07-03 05:19:38.081 E           4 UPPERED "L" normal
2025-07-03 05:19:38.089 E           3 lowered "L" normal
2025-07-03 05:19:38.095 E           After alter domain dm_utf8 type varchar(1) character set utf8:
2025-07-03 05:19:38.100 E           Query: select * from v1_chk_nr
2025-07-03 05:19:38.105 E           Select Expression
2025-07-03 05:19:38.110 E           ....-> Sort (record length: NN, key length: MM)
2025-07-03 05:19:38.114 E           ........-> Filter
2025-07-03 05:19:38.121 E         - ............-> Table "TEST1" as "V1_CHK_NR TEST1" Full Scan
2025-07-03 05:19:38.133 E         + ............-> Table "PUBLIC"."TEST1" as "PUBLIC"."V1_CHK_NR" "PUBLIC"."TEST1" Full Scan
2025-07-03 05:19:38.146 E           3 lowered "D" normal
2025-07-03 05:19:38.153 E           Query: select * from v1_chk_ir_asc
2025-07-03 05:19:38.160 E           Select Expression
2025-07-03 05:19:38.166 E           ....-> Filter
2025-07-03 05:19:38.175 E         - ........-> Table "TEST1" as "V1_CHK_IR_ASC TEST1" Access By ID
2025-07-03 05:19:38.195 E         + ........-> Table "PUBLIC"."TEST1" as "PUBLIC"."V1_CHK_IR_ASC" "PUBLIC"."TEST1" Access By ID
2025-07-03 05:19:38.207 E         - ............-> Index "TEST1_ASC" Range Scan (full match)
2025-07-03 05:19:38.219 E         + ............-> Index "PUBLIC"."TEST1_ASC" Range Scan (full match)
2025-07-03 05:19:38.243 E           3 lowered "D" normal
2025-07-03 05:19:38.254 E           Query: select * from v1_chk_ir_dec
2025-07-03 05:19:38.266 E           Select Expression
2025-07-03 05:19:38.278 E           ....-> Filter
2025-07-03 05:19:38.287 E         - ........-> Table "TEST1" as "V1_CHK_IR_DEC TEST1" Access By ID
2025-07-03 05:19:38.310 E         + ........-> Table "PUBLIC"."TEST1" as "PUBLIC"."V1_CHK_IR_DEC" "PUBLIC"."TEST1" Access By ID
2025-07-03 05:19:38.325 E         - ............-> Index "TEST1_DEC" Range Scan (full match)
2025-07-03 05:19:38.331 E         + ............-> Index "PUBLIC"."TEST1_DEC" Range Scan (full match)
2025-07-03 05:19:38.342 E           3 lowered "D" normal
2025-07-03 05:19:38.351 E           Query: select * from v2_chk_nr
2025-07-03 05:19:38.358 E           Select Expression
2025-07-03 05:19:38.370 E           ....-> Sort (record length: NN, key length: MM)
2025-07-03 05:19:38.381 E           ........-> Filter
2025-07-03 05:19:38.392 E         - ............-> Table "TEST2" as "V2_CHK_NR TEST2" Full Scan
2025-07-03 05:19:38.408 E         + ............-> Table "PUBLIC"."TEST2" as "PUBLIC"."V2_CHK_NR" "PUBLIC"."TEST2" Full Scan
2025-07-03 05:19:38.421 E           3 lowered "L" normal
2025-07-03 05:19:38.428 E           Query: select * from v2_chk_ir_asc
2025-07-03 05:19:38.435 E           Select Expression
2025-07-03 05:19:38.445 E           ....-> Filter
2025-07-03 05:19:38.457 E         - ........-> Table "TEST2" as "V2_CHK_IR_ASC TEST2" Access By ID
2025-07-03 05:19:38.481 E         + ........-> Table "PUBLIC"."TEST2" as "PUBLIC"."V2_CHK_IR_ASC" "PUBLIC"."TEST2" Access By ID
2025-07-03 05:19:38.501 E         - ............-> Index "TEST2_PARTIAL_ASC" Full Scan
2025-07-03 05:19:38.512 E         + ............-> Index "PUBLIC"."TEST2_PARTIAL_ASC" Full Scan
2025-07-03 05:19:38.533 E           3 lowered "L" normal
2025-07-03 05:19:38.541 E           Query: select * from v2_chk_ir_dec
2025-07-03 05:19:38.547 E           Select Expression
2025-07-03 05:19:38.554 E           ....-> Sort (record length: NN, key length: MM)
2025-07-03 05:19:38.559 E           ........-> Filter
2025-07-03 05:19:38.566 E         - ............-> Table "TEST2" as "V2_CHK_IR_DEC TEST2" Access By ID
2025-07-03 05:19:38.585 E         + ............-> Table "PUBLIC"."TEST2" as "PUBLIC"."V2_CHK_IR_DEC" "PUBLIC"."TEST2" Access By ID
2025-07-03 05:19:38.598 E           ................-> Bitmap
2025-07-03 05:19:38.603 E         - ....................-> Index "TEST2_PARTIAL_ASC" Full Scan
2025-07-03 05:19:38.608 E         + ....................-> Index "PUBLIC"."TEST2_PARTIAL_ASC" Full Scan
2025-07-03 05:19:38.618 E           3 lowered "L" normal
2025-07-03 05:19:38.625
2025-07-03 05:19:38.631 tests/bugs/gh_8434_test.py:371: AssertionError
2025-07-03 05:19:38.636 ---------------------------- Captured stdout setup -----------------------------
2025-07-03 05:19:38.641 Creating db: localhost:/var/tmp/qa_2024/test_11742/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('>=6')
    def test_1(act: Action, capsys):
        qry_map = {
            1 : 'select * from v1_chk_nr'
           ,2 : 'select * from v1_chk_ir_asc'
           ,3 : 'select * from v1_chk_ir_dec'
           ,4 : 'select * from v2_chk_nr'
           ,5 : 'select * from v2_chk_ir_asc'
           ,6 : 'select * from v2_chk_ir_dec'
        }
    
        alter_lst = (
            ''
           ,'alter domain dm_utf8 type varchar(1) character set utf8 collate unicode_ci'
           ,'alter domain dm_utf8 type varchar(1) character set utf8 collate unicode_ci_ai'
           ,'alter domain dm_utf8 type varchar(1) character set utf8'
        )
    
        with act.db.connect(charset = 'utf8') as con:
            cur = con.cursor()
            for alter_i in alter_lst:
                if alter_i.strip():
                    con.execute_immediate(alter_i)
                    con.commit()
                    print(f'\nAfter {alter_i}:')
                else:
                    print('Initial state:')
    
                for k, v in qry_map.items():
                    ps, rs = None, None
                    try:
                        ps = cur.prepare(v)
    
                        print('Query:', v)
                        # Print explained plan with padding eash line by dots in order to see indentations:
                        print( '\n'.join([replace_leading(s) for s in ps.detailed_plan.split('\n')]) )
                        print('')
    
                        # ::: NB ::: 'ps' returns data, i.e. this is SELECTABLE expression.
                        # We have to store result of cur.execute(<psInstance>) in order to
                        # close it explicitly.
                        # Otherwise AV can occur during Python garbage collection and this
                        # causes pytest to hang on its final point.
                        # Explained by hvlad, email 26.10.24 17:42
                        rs = cur.execute(ps)
                        for r in rs:
                            print(r[0], r[1])
                    except DatabaseError as e:
                        print(e.__str__())
                        print(e.gds_codes)
                    finally:
                        if rs:
                            rs.close() # <<< EXPLICITLY CLOSING CURSOR RESULTS
                        if ps:
                            ps.free()
    
    
        expected_stdout = """
            Initial state:
    
            Query: select * from v1_chk_nr
            Select Expression
            ....-> Sort (record length: NN, key length: MM)
            ........-> Filter
            ............-> Table "TEST1" as "V1_CHK_NR TEST1" Full Scan
            3 lowered "D" normal
            Query: select * from v1_chk_ir_asc
            Select Expression
            ....-> Filter
            ........-> Table "TEST1" as "V1_CHK_IR_ASC TEST1" Access By ID
            ............-> Index "TEST1_ASC" Range Scan (full match)
            3 lowered "D" normal
            Query: select * from v1_chk_ir_dec
            Select Expression
            ....-> Filter
            ........-> Table "TEST1" as "V1_CHK_IR_DEC TEST1" Access By ID
            ............-> Index "TEST1_DEC" Range Scan (full match)
            3 lowered "D" normal
            Query: select * from v2_chk_nr
            Select Expression
            ....-> Sort (record length: NN, key length: MM)
            ........-> Filter
            ............-> Table "TEST2" as "V2_CHK_NR TEST2" Full Scan
            3 lowered "L" normal
            Query: select * from v2_chk_ir_asc
            Select Expression
            ....-> Filter
            ........-> Table "TEST2" as "V2_CHK_IR_ASC TEST2" Access By ID
            ............-> Index "TEST2_PARTIAL_ASC" Full Scan
            3 lowered "L" normal
            Query: select * from v2_chk_ir_dec
            Select Expression
            ....-> Sort (record length: NN, key length: MM)
            ........-> Filter
            ............-> Table "TEST2" as "V2_CHK_IR_DEC TEST2" Access By ID
            ................-> Bitmap
            ....................-> Index "TEST2_PARTIAL_ASC" Full Scan
            3 lowered "L" normal
    
    
            After alter domain dm_utf8 type varchar(1) character set utf8 collate unicode_ci:
    
            Query: select * from v1_chk_nr
            Select Expression
            ....-> Sort (record length: NN, key length: MM)
            ........-> Filter
            ............-> Table "TEST1" as "V1_CHK_NR TEST1" Full Scan
            3 lowered "D" normal
            4 UPPERED "D" normal
            Query: select * from v1_chk_ir_asc
            Select Expression
            ....-> Filter
            ........-> Table "TEST1" as "V1_CHK_IR_ASC TEST1" Access By ID
            ............-> Index "TEST1_ASC" Range Scan (full match)
            3 lowered "D" normal
            4 UPPERED "D" normal
            Query: select * from v1_chk_ir_dec
            Select Expression
            ....-> Filter
            ........-> Table "TEST1" as "V1_CHK_IR_DEC TEST1" Access By ID
            ............-> Index "TEST1_DEC" Range Scan (full match)
            4 UPPERED "D" normal
            3 lowered "D" normal
            Query: select * from v2_chk_nr
            Select Expression
            ....-> Sort (record length: NN, key length: MM)
            ........-> Filter
            ............-> Table "TEST2" as "V2_CHK_NR TEST2" Full Scan
            3 lowered "L" normal
            4 UPPERED "L" normal
            Query: select * from v2_chk_ir_asc
            Select Expression
            ....-> Filter
            ........-> Table "TEST2" as "V2_CHK_IR_ASC TEST2" Access By ID
            ............-> Index "TEST2_PARTIAL_ASC" Full Scan
            3 lowered "L" normal
            4 UPPERED "L" normal
            Query: select * from v2_chk_ir_dec
            Select Expression
            ....-> Sort (record length: NN, key length: MM)
            ........-> Filter
            ............-> Table "TEST2" as "V2_CHK_IR_DEC TEST2" Access By ID
            ................-> Bitmap
            ....................-> Index "TEST2_PARTIAL_ASC" Full Scan
            4 UPPERED "L" normal
            3 lowered "L" normal
    
    
            After alter domain dm_utf8 type varchar(1) character set utf8 collate unicode_ci_ai:
    
            Query: select * from v1_chk_nr
            Select Expression
            ....-> Sort (record length: NN, key length: MM)
            ........-> Filter
            ............-> Table "TEST1" as "V1_CHK_NR TEST1" Full Scan
            1 lowered "D" w/accent
            2 UPPERED "D" w/accent
            3 lowered "D" normal
            4 UPPERED "D" normal
            Query: select * from v1_chk_ir_asc
            Select Expression
            ....-> Filter
            ........-> Table "TEST1" as "V1_CHK_IR_ASC TEST1" Access By ID
            ............-> Index "TEST1_ASC" Range Scan (full match)
            3 lowered "D" normal
            4 UPPERED "D" normal
            1 lowered "D" w/accent
            2 UPPERED "D" w/accent
            Query: select * from v1_chk_ir_dec
            Select Expression
            ....-> Filter
            ........-> Table "TEST1" as "V1_CHK_IR_DEC TEST1" Access By ID
            ............-> Index "TEST1_DEC" Range Scan (full match)
            2 UPPERED "D" w/accent
            1 lowered "D" w/accent
            4 UPPERED "D" normal
            3 lowered "D" normal
            Query: select * from v2_chk_nr
            Select Expression
            ....-> Sort (record length: NN, key length: MM)
            ........-> Filter
            ............-> Table "TEST2" as "V2_CHK_NR TEST2" Full Scan
            1 lowered "L" w/accent
            2 UPPERED "L" w/accent
            3 lowered "L" normal
            4 UPPERED "L" normal
            Query: select * from v2_chk_ir_asc
            Select Expression
            ....-> Filter
            ........-> Table "TEST2" as "V2_CHK_IR_ASC TEST2" Access By ID
            ............-> Index "TEST2_PARTIAL_ASC" Full Scan
            3 lowered "L" normal
            4 UPPERED "L" normal
            1 lowered "L" w/accent
            2 UPPERED "L" w/accent
            Query: select * from v2_chk_ir_dec
            Select Expression
            ....-> Sort (record length: NN, key length: MM)
            ........-> Filter
            ............-> Table "TEST2" as "V2_CHK_IR_DEC TEST2" Access By ID
            ................-> Bitmap
            ....................-> Index "TEST2_PARTIAL_ASC" Full Scan
            2 UPPERED "L" w/accent
            1 lowered "L" w/accent
            4 UPPERED "L" normal
            3 lowered "L" normal
    
    
            After alter domain dm_utf8 type varchar(1) character set utf8:
    
            Query: select * from v1_chk_nr
            Select Expression
            ....-> Sort (record length: NN, key length: MM)
            ........-> Filter
            ............-> Table "TEST1" as "V1_CHK_NR TEST1" Full Scan
            3 lowered "D" normal
            Query: select * from v1_chk_ir_asc
            Select Expression
            ....-> Filter
            ........-> Table "TEST1" as "V1_CHK_IR_ASC TEST1" Access By ID
            ............-> Index "TEST1_ASC" Range Scan (full match)
            3 lowered "D" normal
            Query: select * from v1_chk_ir_dec
            Select Expression
            ....-> Filter
            ........-> Table "TEST1" as "V1_CHK_IR_DEC TEST1" Access By ID
            ............-> Index "TEST1_DEC" Range Scan (full match)
            3 lowered "D" normal
            Query: select * from v2_chk_nr
            Select Expression
            ....-> Sort (record length: NN, key length: MM)
            ........-> Filter
            ............-> Table "TEST2" as "V2_CHK_NR TEST2" Full Scan
            3 lowered "L" normal
            Query: select * from v2_chk_ir_asc
            Select Expression
            ....-> Filter
            ........-> Table "TEST2" as "V2_CHK_IR_ASC TEST2" Access By ID
            ............-> Index "TEST2_PARTIAL_ASC" Full Scan
            3 lowered "L" normal
            Query: select * from v2_chk_ir_dec
            Select Expression
            ....-> Sort (record length: NN, key length: MM)
            ........-> Filter
            ............-> Table "TEST2" as "V2_CHK_IR_DEC TEST2" Access By ID
            ................-> Bitmap
            ....................-> Index "TEST2_PARTIAL_ASC" Full Scan
            3 lowered "L" normal
        """
    
        act.expected_stdout = expected_stdout
    
        act.stdout = capsys.readouterr().out
>       assert act.clean_stdout == act.clean_expected_stdout
E       assert   
E           Initial state:
E           Query: select * from v1_chk_nr
E           Select Expression
E           ....-> Sort (record length: NN, key length: MM)
E           ........-> Filter
E         - ............-> Table "TEST1" as "V1_CHK_NR TEST1" Full Scan
E         + ............-> Table "PUBLIC"."TEST1" as "PUBLIC"."V1_CHK_NR" "PUBLIC"."TEST1" Full Scan
E           3 lowered "D" normal
E           Query: select * from v1_chk_ir_asc
E           Select Expression
E           ....-> Filter
E         - ........-> Table "TEST1" as "V1_CHK_IR_ASC TEST1" Access By ID
E         + ........-> Table "PUBLIC"."TEST1" as "PUBLIC"."V1_CHK_IR_ASC" "PUBLIC"."TEST1" Access By ID
E         - ............-> Index "TEST1_ASC" Range Scan (full match)
E         + ............-> Index "PUBLIC"."TEST1_ASC" Range Scan (full match)
E           3 lowered "D" normal
E           Query: select * from v1_chk_ir_dec
E           Select Expression
E           ....-> Filter
E         - ........-> Table "TEST1" as "V1_CHK_IR_DEC TEST1" Access By ID
E         + ........-> Table "PUBLIC"."TEST1" as "PUBLIC"."V1_CHK_IR_DEC" "PUBLIC"."TEST1" Access By ID
E         - ............-> Index "TEST1_DEC" Range Scan (full match)
E         + ............-> Index "PUBLIC"."TEST1_DEC" Range Scan (full match)
E           3 lowered "D" normal
E           Query: select * from v2_chk_nr
E           Select Expression
E           ....-> Sort (record length: NN, key length: MM)
E           ........-> Filter
E         - ............-> Table "TEST2" as "V2_CHK_NR TEST2" Full Scan
E         + ............-> Table "PUBLIC"."TEST2" as "PUBLIC"."V2_CHK_NR" "PUBLIC"."TEST2" Full Scan
E           3 lowered "L" normal
E           Query: select * from v2_chk_ir_asc
E           Select Expression
E           ....-> Filter
E         - ........-> Table "TEST2" as "V2_CHK_IR_ASC TEST2" Access By ID
E         + ........-> Table "PUBLIC"."TEST2" as "PUBLIC"."V2_CHK_IR_ASC" "PUBLIC"."TEST2" Access By ID
E         - ............-> Index "TEST2_PARTIAL_ASC" Full Scan
E         + ............-> Index "PUBLIC"."TEST2_PARTIAL_ASC" Full Scan
E           3 lowered "L" normal
E           Query: select * from v2_chk_ir_dec
E           Select Expression
E           ....-> Sort (record length: NN, key length: MM)
E           ........-> Filter
E         - ............-> Table "TEST2" as "V2_CHK_IR_DEC TEST2" Access By ID
E         + ............-> Table "PUBLIC"."TEST2" as "PUBLIC"."V2_CHK_IR_DEC" "PUBLIC"."TEST2" Access By ID
E           ................-> Bitmap
E         - ....................-> Index "TEST2_PARTIAL_ASC" Full Scan
E         + ....................-> Index "PUBLIC"."TEST2_PARTIAL_ASC" Full Scan
E           3 lowered "L" normal
E           After alter domain dm_utf8 type varchar(1) character set utf8 collate unicode_ci:
E           Query: select * from v1_chk_nr
E           Select Expression
E           ....-> Sort (record length: NN, key length: MM)
E           ........-> Filter
E         - ............-> Table "TEST1" as "V1_CHK_NR TEST1" Full Scan
E         + ............-> Table "PUBLIC"."TEST1" as "PUBLIC"."V1_CHK_NR" "PUBLIC"."TEST1" Full Scan
E           3 lowered "D" normal
E           4 UPPERED "D" normal
E           Query: select * from v1_chk_ir_asc
E           Select Expression
E           ....-> Filter
E         - ........-> Table "TEST1" as "V1_CHK_IR_ASC TEST1" Access By ID
E         + ........-> Table "PUBLIC"."TEST1" as "PUBLIC"."V1_CHK_IR_ASC" "PUBLIC"."TEST1" Access By ID
E         - ............-> Index "TEST1_ASC" Range Scan (full match)
E         + ............-> Index "PUBLIC"."TEST1_ASC" Range Scan (full match)
E           3 lowered "D" normal
E           4 UPPERED "D" normal
E           Query: select * from v1_chk_ir_dec
E           Select Expression
E           ....-> Filter
E         - ........-> Table "TEST1" as "V1_CHK_IR_DEC TEST1" Access By ID
E         + ........-> Table "PUBLIC"."TEST1" as "PUBLIC"."V1_CHK_IR_DEC" "PUBLIC"."TEST1" Access By ID
E         - ............-> Index "TEST1_DEC" Range Scan (full match)
E         + ............-> Index "PUBLIC"."TEST1_DEC" Range Scan (full match)
E           4 UPPERED "D" normal
E           3 lowered "D" normal
E           Query: select * from v2_chk_nr
E           Select Expression
E           ....-> Sort (record length: NN, key length: MM)
E           ........-> Filter
E         - ............-> Table "TEST2" as "V2_CHK_NR TEST2" Full Scan
E         + ............-> Table "PUBLIC"."TEST2" as "PUBLIC"."V2_CHK_NR" "PUBLIC"."TEST2" Full Scan
E           3 lowered "L" normal
E           4 UPPERED "L" normal
E           Query: select * from v2_chk_ir_asc
E           Select Expression
E           ....-> Filter
E         - ........-> Table "TEST2" as "V2_CHK_IR_ASC TEST2" Access By ID
E         + ........-> Table "PUBLIC"."TEST2" as "PUBLIC"."V2_CHK_IR_ASC" "PUBLIC"."TEST2" Access By ID
E         - ............-> Index "TEST2_PARTIAL_ASC" Full Scan
E         + ............-> Index "PUBLIC"."TEST2_PARTIAL_ASC" Full Scan
E           3 lowered "L" normal
E           4 UPPERED "L" normal
E           Query: select * from v2_chk_ir_dec
E           Select Expression
E           ....-> Sort (record length: NN, key length: MM)
E           ........-> Filter
E         - ............-> Table "TEST2" as "V2_CHK_IR_DEC TEST2" Access By ID
E         + ............-> Table "PUBLIC"."TEST2" as "PUBLIC"."V2_CHK_IR_DEC" "PUBLIC"."TEST2" Access By ID
E           ................-> Bitmap
E         - ....................-> Index "TEST2_PARTIAL_ASC" Full Scan
E         + ....................-> Index "PUBLIC"."TEST2_PARTIAL_ASC" Full Scan
E           4 UPPERED "L" normal
E           3 lowered "L" normal
E           After alter domain dm_utf8 type varchar(1) character set utf8 collate unicode_ci_ai:
E           Query: select * from v1_chk_nr
E           Select Expression
E           ....-> Sort (record length: NN, key length: MM)
E           ........-> Filter
E         - ............-> Table "TEST1" as "V1_CHK_NR TEST1" Full Scan
E         + ............-> Table "PUBLIC"."TEST1" as "PUBLIC"."V1_CHK_NR" "PUBLIC"."TEST1" Full Scan
E           1 lowered "D" w/accent
E           2 UPPERED "D" w/accent
E           3 lowered "D" normal
E           4 UPPERED "D" normal
E           Query: select * from v1_chk_ir_asc
E           Select Expression
E           ....-> Filter
E         - ........-> Table "TEST1" as "V1_CHK_IR_ASC TEST1" Access By ID
E         + ........-> Table "PUBLIC"."TEST1" as "PUBLIC"."V1_CHK_IR_ASC" "PUBLIC"."TEST1" Access By ID
E         - ............-> Index "TEST1_ASC" Range Scan (full match)
E         + ............-> Index "PUBLIC"."TEST1_ASC" Range Scan (full match)
E           3 lowered "D" normal
E           4 UPPERED "D" normal
E           1 lowered "D" w/accent
E           2 UPPERED "D" w/accent
E           Query: select * from v1_chk_ir_dec
E           Select Expression
E           ....-> Filter
E         - ........-> Table "TEST1" as "V1_CHK_IR_DEC TEST1" Access By ID
E         + ........-> Table "PUBLIC"."TEST1" as "PUBLIC"."V1_CHK_IR_DEC" "PUBLIC"."TEST1" Access By ID
E         - ............-> Index "TEST1_DEC" Range Scan (full match)
E         + ............-> Index "PUBLIC"."TEST1_DEC" Range Scan (full match)
E           2 UPPERED "D" w/accent
E           1 lowered "D" w/accent
E           4 UPPERED "D" normal
E           3 lowered "D" normal
E           Query: select * from v2_chk_nr
E           Select Expression
E           ....-> Sort (record length: NN, key length: MM)
E           ........-> Filter
E         - ............-> Table "TEST2" as "V2_CHK_NR TEST2" Full Scan
E         + ............-> Table "PUBLIC"."TEST2" as "PUBLIC"."V2_CHK_NR" "PUBLIC"."TEST2" Full Scan
E           1 lowered "L" w/accent
E           2 UPPERED "L" w/accent
E           3 lowered "L" normal
E           4 UPPERED "L" normal
E           Query: select * from v2_chk_ir_asc
E           Select Expression
E           ....-> Filter
E         - ........-> Table "TEST2" as "V2_CHK_IR_ASC TEST2" Access By ID
E         + ........-> Table "PUBLIC"."TEST2" as "PUBLIC"."V2_CHK_IR_ASC" "PUBLIC"."TEST2" Access By ID
E         - ............-> Index "TEST2_PARTIAL_ASC" Full Scan
E         + ............-> Index "PUBLIC"."TEST2_PARTIAL_ASC" Full Scan
E           3 lowered "L" normal
E           4 UPPERED "L" normal
E           1 lowered "L" w/accent
E           2 UPPERED "L" w/accent
E           Query: select * from v2_chk_ir_dec
E           Select Expression
E           ....-> Sort (record length: NN, key length: MM)
E           ........-> Filter
E         - ............-> Table "TEST2" as "V2_CHK_IR_DEC TEST2" Access By ID
E         + ............-> Table "PUBLIC"."TEST2" as "PUBLIC"."V2_CHK_IR_DEC" "PUBLIC"."TEST2" Access By ID
E           ................-> Bitmap
E         - ....................-> Index "TEST2_PARTIAL_ASC" Full Scan
E         + ....................-> Index "PUBLIC"."TEST2_PARTIAL_ASC" Full Scan
E           2 UPPERED "L" w/accent
E           1 lowered "L" w/accent
E           4 UPPERED "L" normal
E           3 lowered "L" normal
E           After alter domain dm_utf8 type varchar(1) character set utf8:
E           Query: select * from v1_chk_nr
E           Select Expression
E           ....-> Sort (record length: NN, key length: MM)
E           ........-> Filter
E         - ............-> Table "TEST1" as "V1_CHK_NR TEST1" Full Scan
E         + ............-> Table "PUBLIC"."TEST1" as "PUBLIC"."V1_CHK_NR" "PUBLIC"."TEST1" Full Scan
E           3 lowered "D" normal
E           Query: select * from v1_chk_ir_asc
E           Select Expression
E           ....-> Filter
E         - ........-> Table "TEST1" as "V1_CHK_IR_ASC TEST1" Access By ID
E         + ........-> Table "PUBLIC"."TEST1" as "PUBLIC"."V1_CHK_IR_ASC" "PUBLIC"."TEST1" Access By ID
E         - ............-> Index "TEST1_ASC" Range Scan (full match)
E         + ............-> Index "PUBLIC"."TEST1_ASC" Range Scan (full match)
E           3 lowered "D" normal
E           Query: select * from v1_chk_ir_dec
E           Select Expression
E           ....-> Filter
E         - ........-> Table "TEST1" as "V1_CHK_IR_DEC TEST1" Access By ID
E         + ........-> Table "PUBLIC"."TEST1" as "PUBLIC"."V1_CHK_IR_DEC" "PUBLIC"."TEST1" Access By ID
E         - ............-> Index "TEST1_DEC" Range Scan (full match)
E         + ............-> Index "PUBLIC"."TEST1_DEC" Range Scan (full match)
E           3 lowered "D" normal
E           Query: select * from v2_chk_nr
E           Select Expression
E           ....-> Sort (record length: NN, key length: MM)
E           ........-> Filter
E         - ............-> Table "TEST2" as "V2_CHK_NR TEST2" Full Scan
E         + ............-> Table "PUBLIC"."TEST2" as "PUBLIC"."V2_CHK_NR" "PUBLIC"."TEST2" Full Scan
E           3 lowered "L" normal
E           Query: select * from v2_chk_ir_asc
E           Select Expression
E           ....-> Filter
E         - ........-> Table "TEST2" as "V2_CHK_IR_ASC TEST2" Access By ID
E         + ........-> Table "PUBLIC"."TEST2" as "PUBLIC"."V2_CHK_IR_ASC" "PUBLIC"."TEST2" Access By ID
E         - ............-> Index "TEST2_PARTIAL_ASC" Full Scan
E         + ............-> Index "PUBLIC"."TEST2_PARTIAL_ASC" Full Scan
E           3 lowered "L" normal
E           Query: select * from v2_chk_ir_dec
E           Select Expression
E           ....-> Sort (record length: NN, key length: MM)
E           ........-> Filter
E         - ............-> Table "TEST2" as "V2_CHK_IR_DEC TEST2" Access By ID
E         + ............-> Table "PUBLIC"."TEST2" as "PUBLIC"."V2_CHK_IR_DEC" "PUBLIC"."TEST2" Access By ID
E           ................-> Bitmap
E         - ....................-> Index "TEST2_PARTIAL_ASC" Full Scan
E         + ....................-> Index "PUBLIC"."TEST2_PARTIAL_ASC" Full Scan
E           3 lowered "L" normal

tests/bugs/gh_8434_test.py:371: 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.892 2025.07.02 10f7d F F 944 915 2025.07.03 01:47:45.150 2025.07.03 01:47:46.094 2025.07.02 23:13:21.883 2025.07.02 23:13:22.798
2 6.0.0.889 2025.07.01 969ac F F 1142 472 2025.07.02 02:15:50.156 2025.07.02 02:15:51.298 2025.07.01 23:25:46.279 2025.07.01 23:25:46.751
3 6.0.0.884 2025.06.30 f7e5f F F 1024 811 2025.07.01 02:16:00.909 2025.07.01 02:16:01.933 2025.06.30 23:35:15.710 2025.06.30 23:35:16.521
4 6.0.0.881 2025.06.27 7035d F F 1055 855 2025.06.30 02:06:25.887 2025.06.30 02:06:26.942 2025.06.29 23:22:26.938 2025.06.29 23:22:27.793
5 6.0.0.877 2025.06.26 8e38f F F 973 660 2025.06.27 01:45:15.656 2025.06.27 01:45:16.629 2025.06.26 23:13:19.180 2025.06.26 23:13:19.840
6 6.0.0.876 2025.06.25 b1bec F F 972 960 2025.06.26 01:49:07.669 2025.06.26 01:49:08.641 2025.06.25 23:15:13.822 2025.06.25 23:15:14.782
7 6.0.0.863 2025.06.24 c3c20 F F 986 471 2025.06.25 01:49:26.276 2025.06.25 01:49:27.262 2025.06.24 23:14:56.830 2025.06.24 23:14:57.301
8 6.0.0.858 2025.06.23 8d6f7 F F 987 469 2025.06.24 01:49:47.154 2025.06.24 01:49:48.141 2025.06.23 23:15:07.733 2025.06.23 23:15:08.202
9 6.0.0.849 2025.06.20 7b79c F F 1120 496 2025.06.21 02:01:19.126 2025.06.21 02:01:20.246 2025.06.20 23:24:11.527 2025.06.20 23:24:12.023
10 6.0.0.848 2025.06.19 c483c F F 1035 833 2025.06.20 01:57:41.377 2025.06.20 01:57:42.412 2025.06.19 23:20:59.147 2025.06.19 23:20:59.980
11 6.0.0.845 2025.06.18 22b12 F F 991 518 2025.06.19 02:06:19.202 2025.06.19 02:06:20.193 2025.06.18 23:24:15.990 2025.06.18 23:24:16.508
12 6.0.0.843 2025.06.16 995f4 F F 906 1045 2025.06.18 02:04:36.333 2025.06.18 02:04:37.239 2025.06.17 23:25:50.106 2025.06.17 23:25:51.151
13 6.0.0.840 2025.06.14 29bca F F 1132 774 2025.06.16 01:56:25.919 2025.06.16 01:56:27.051 2025.06.15 23:18:27.624 2025.06.15 23:18:28.398
14 6.0.0.838 2025.06.13 0e28a F F 950 980 2025.06.14 02:09:31.692 2025.06.14 02:09:32.642 2025.06.13 23:26:02.881 2025.06.13 23:26:03.861
15 6.0.0.835 2025.06.12 2cf29 F F 1091 847 2025.06.13 02:09:23.234 2025.06.13 02:09:24.325 2025.06.12 23:30:02.859 2025.06.12 23:30:03.706
16 6.0.0.834 2025.06.11 e889f F F 1047 508 2025.06.12 02:04:38.982 2025.06.12 02:04:40.029 2025.06.11 23:25:55.062 2025.06.11 23:25:55.570
17 6.0.0.800 2025.06.10 1f226 P P 1525 872 2025.06.11 00:33:16.721 2025.06.11 00:33:18.246 2025.06.10 22:25:41.067 2025.06.10 22:25:41.939
18 6.0.0.799 2025.06.07 be644 P P 824 798 2025.06.10 00:35:35.187 2025.06.10 00:35:36.011 2025.06.09 22:25:22.401 2025.06.09 22:25:23.199
19 6.0.0.797 2025.06.06 303e8 P P 1345 796 2025.06.07 00:39:07.938 2025.06.07 00:39:09.283 2025.06.06 22:24:56.138 2025.06.06 22:24:56.934
20 6.0.0.795 2025.05.29 7a71a P P 1662 928 2025.06.06 00:32:50.860 2025.06.06 00:32:52.522 2025.06.05 22:24:03.224 2025.06.05 22:24:04.152
21 6.0.0.792 2025.05.28 b4327 P P 1496 1078 2025.05.29 00:47:51.926 2025.05.29 00:47:53.422 2025.05.28 22:27:21.095 2025.05.28 22:27:22.173
22 6.0.0.791 2025.05.27 02db8 P P 859 898 2025.05.28 00:45:12.713 2025.05.28 00:45:13.572 2025.05.27 22:26:26.802 2025.05.27 22:26:27.700
23 6.0.0.789 2025.05.21 64051 P P 811 992 2025.05.25 00:37:48.352 2025.05.25 00:37:49.163 2025.05.24 22:25:27.634 2025.05.24 22:25:28.626
24 6.0.0.787 2025.05.20 230ad P P 867 760 2025.05.21 00:34:56.195 2025.05.21 00:34:57.062 2025.05.20 22:23:45.854 2025.05.20 22:23:46.614
25 6.0.0.783 2025.05.12 37320 P P 1119 715 2025.05.19 12:07:43.327 2025.05.19 12:07:44.446 2025.05.19 10:11:27.530 2025.05.19 10:11:28.245
26 6.0.0.779 2025.05.11 136fa P P 1566 576 2025.05.12 00:30:04.604 2025.05.12 00:30:06.170 2025.05.11 22:23:11.730 2025.05.11 22:23:12.306
27 6.0.0.778 2025.05.07 d735e P P 841 897 2025.05.08 00:31:42.027 2025.05.08 00:31:42.868 2025.05.07 22:21:56.541 2025.05.07 22:21:57.438
28 6.0.0.776 2025.05.06 007cd P P 1813 960 2025.05.07 00:26:42.535 2025.05.07 00:26:44.348 2025.05.06 22:21:49.634 2025.05.06 22:21:50.594
29 6.0.0.770 2025.05.05 82c4a P P 1585 1016 2025.05.06 00:26:03.194 2025.05.06 00:26:04.779 2025.05.05 22:20:45.499 2025.05.05 22:20:46.515
30 6.0.0.767 2025.05.01 cdd29 P P 1603 963 2025.05.02 00:22:05.467 2025.05.02 00:22:07.070 2025.05.01 22:19:59.539 2025.05.01 22:20:00.502
31 6.0.0.762 2025.04.30 5cb15 P P 1588 919 2025.05.01 00:18:27.810 2025.05.01 00:18:29.398 2025.04.30 22:18:37.395 2025.04.30 22:18:38.314
32 6.0.0.755 2025.04.29 739c6 P P 1207 906 2025.04.30 00:22:21.675 2025.04.30 00:22:22.882 2025.04.29 22:20:02.670 2025.04.29 22:20:03.576
33 6.0.0.753 2025.04.27 29ab3 P P 1013 845 2025.04.28 00:24:00.658 2025.04.28 00:24:01.671 2025.04.27 22:19:18.208 2025.04.27 22:19:19.053
34 6.0.0.745 2025.04.21 78ad8 P P 879 787 2025.04.26 00:20:02.042 2025.04.26 00:20:02.921 2025.04.25 22:21:14.811 2025.04.25 22:21:15.598
35 6.0.0.744 2025.04.19 e883a P P 930 774 2025.04.20 00:22:30.127 2025.04.20 00:22:31.057 2025.04.19 22:20:30.685 2025.04.19 22:20:31.459
36 6.0.0.742 2025.04.17 abc3b P P 849 979 2025.04.19 00:24:22.282 2025.04.19 00:24:23.131 2025.04.18 22:20:55.875 2025.04.18 22:20:56.854
37 6.0.0.737 2025.04.16 fe52b P P 1521 823 2025.04.17 00:20:25.086 2025.04.17 00:20:26.607 2025.04.16 22:20:57.337 2025.04.16 22:20:58.160
38 6.0.0.736 2025.04.14 3e6be P P 1519 776 2025.04.15 00:01:36.674 2025.04.15 00:01:38.193 2025.04.14 22:12:24.653 2025.04.14 22:12:25.429
39 6.0.0.735 2025.04.13 6635c P P 730 435 2025.04.14 00:04:51.547 2025.04.14 00:04:52.277 2025.04.13 22:13:31.746 2025.04.13 22:13:32.181
40 6.0.0.734 2025.04.12 12f3f P P 1503 671 2025.04.13 00:01:50.559 2025.04.13 00:01:52.062 2025.04.12 22:12:50.307 2025.04.12 22:12:50.978
41 6.0.0.730 2025.04.11 240b8 P P 1281 775 2025.04.12 00:04:14.492 2025.04.12 00:04:15.773 2025.04.11 22:12:29.629 2025.04.11 22:12:30.404
42 6.0.0.726 2025.04.10 d79c6 P P 785 521 2025.04.11 00:04:14.519 2025.04.11 00:04:15.304 2025.04.10 22:12:33.355 2025.04.10 22:12:33.876
43 6.0.0.725 2025.04.09 a2b05 P P 856 495 2025.04.10 00:04:42.552 2025.04.10 00:04:43.408 2025.04.09 22:14:01.787 2025.04.09 22:14:02.282
44 6.0.0.722 2025.04.08 a8b86 P P 856 896 2025.04.09 00:21:42.985 2025.04.09 00:21:43.841 2025.04.08 22:20:11.694 2025.04.08 22:20:12.590
45 6.0.0.719 2025.04.06 90fd9 P P 824 433 2025.04.07 00:18:33.915 2025.04.07 00:18:34.739 2025.04.06 22:18:20.803 2025.04.06 22:18:21.236
46 6.0.0.717 2025.04.04 53d70 P P 1519 727 2025.04.05 00:13:40.511 2025.04.05 00:13:42.030 2025.04.04 22:17:44.962 2025.04.04 22:17:45.689
47 6.0.0.716 2025.04.03 fc636 P P 1336 801 2025.04.04 00:18:17.298 2025.04.04 00:18:18.634 2025.04.03 22:19:22.146 2025.04.03 22:19:22.947
48 6.0.0.715 2025.04.02 907ed P P 831 679 2025.04.03 00:18:02.623 2025.04.03 00:18:03.454 2025.04.02 22:19:39.806 2025.04.02 22:19:40.485
49 6.0.0.710 2025.04.01 40651 P P 910 909 2025.04.02 00:16:11.087 2025.04.02 00:16:11.997 2025.04.01 22:18:24.826 2025.04.01 22:18:25.735
50 6.0.0.708 2025.03.31 cb069 P P 1475 442 2025.04.01 00:07:02.283 2025.04.01 00:07:03.758 2025.03.31 22:13:37.726 2025.03.31 22:13:38.168
51 6.0.0.707 2025.03.28 4bd4f P P 865 823 2025.03.31 00:07:20.314 2025.03.31 00:07:21.179 2025.03.30 22:14:14.079 2025.03.30 22:14:14.902
52 6.0.0.698 2025.03.26 d72a7 P P 920 973 2025.03.28 00:30:12.645 2025.03.28 00:30:13.565 2025.03.27 22:20:10.190 2025.03.27 22:20:11.163
53 6.0.0.693 2025.03.24 0b559 P P 1026 477 2025.03.25 00:16:33.728 2025.03.25 00:16:34.754 2025.03.24 22:16:38.487 2025.03.24 22:16:38.964
54 6.0.0.687 2025.03.22 730aa P P 849 767 2025.03.24 00:26:18.270 2025.03.24 00:26:19.119 2025.03.23 22:23:47.287 2025.03.23 22:23:48.054
55 6.0.0.686 2025.03.20 71bf6 P P 1623 1021 2025.03.21 00:33:16.842 2025.03.21 00:33:18.465 2025.03.20 22:26:13.444 2025.03.20 22:26:14.465
56 6.0.0.685 2025.03.19 a8577 P P 1444 861 2025.03.20 00:37:23.470 2025.03.20 00:37:24.914 2025.03.19 22:24:07.142 2025.03.19 22:24:08.003
57 6.0.0.680 2025.03.18 90d29 P P 714 352 2025.03.19 10:55:03.613 2025.03.19 10:55:04.327 2025.03.19 09:09:00.229 2025.03.19 09:09:00.581
58 6.0.0.677 2025.03.16 c0a60 P P 1143 503 2025.03.17 00:25:30.087 2025.03.17 00:25:31.230 2025.03.16 22:23:35.419 2025.03.16 22:23:35.922
59 6.0.0.676 2025.03.15 3034f P P 687 394 2025.03.16 15:57:05.584 2025.03.16 15:57:06.271 2025.03.16 14:13:29.580 2025.03.16 14:13:29.974
60 6.0.0.673 2025.03.13 40f5b P P 598 520 2025.03.14 00:23:48.267 2025.03.14 00:23:48.865 2025.03.13 22:22:29.227 2025.03.13 22:22:29.747
61 6.0.0.671 2025.03.12 a4fff P P 1128 432 2025.03.13 00:27:31.821 2025.03.13 00:27:32.949 2025.03.12 22:25:40.820 2025.03.12 22:25:41.252
62 6.0.0.663 2025.03.11 daad2 P P 880 610 2025.03.12 00:26:04.707 2025.03.12 00:26:05.587 2025.03.11 22:24:47.813 2025.03.11 22:24:48.423
63 6.0.0.661 2025.03.07 b9869 P P 599 280 2025.03.11 00:04:18.967 2025.03.11 00:04:19.566 2025.03.10 22:15:41.951 2025.03.10 22:15:42.231
64 6.0.0.660 2025.03.04 a6700 P P 1178 480 2025.03.07 00:13:33.987 2025.03.07 00:13:35.165 2025.03.06 22:19:37.199 2025.03.06 22:19:37.679
65 6.0.0.658 2025.03.03 f15f8 P P 604 293 2025.03.04 00:08:28.167 2025.03.04 00:08:28.771 2025.03.03 22:15:53.011 2025.03.03 22:15:53.304
66 6.0.0.656 2025.02.27 25fb4 P P 951 556 2025.03.03 00:37:56.750 2025.03.03 00:37:57.701 2025.03.02 22:27:06.207 2025.03.02 22:27:06.763
67 6.0.0.655 2025.02.25 6e3e0 P P 605 491 2025.02.27 00:12:10.610 2025.02.27 00:12:11.215 2025.02.26 22:17:37.102 2025.02.26 22:17:37.593
68 6.0.0.654 2025.02.24 b7141 P P 1100 526 2025.02.25 00:15:47.626 2025.02.25 00:15:48.726 2025.02.24 22:19:17.873 2025.02.24 22:19:18.399
69 6.0.0.652 2025.02.22 22662 P P 2671 2238 2025.02.24 07:31:36.198 2025.02.24 07:31:38.869 2025.02.24 00:31:31.778 2025.02.24 00:31:34.016
70 6.0.0.647 2025.02.21 9fccb P P 2487 2331 2025.02.22 00:15:26.243 2025.02.22 00:15:28.730 2025.02.21 22:23:02.970 2025.02.21 22:23:05.301
71 6.0.0.640 2025.02.19 9b8ac P P 2973 2243 2025.02.20 00:13:25.254 2025.02.20 00:13:28.227 2025.02.19 22:17:10.394 2025.02.19 22:17:12.637
72 6.0.0.639 2025.02.18 201a4 P P 2526 3260 2025.02.19 00:05:45.731 2025.02.19 00:05:48.257 2025.02.18 22:16:04.904 2025.02.18 22:16:08.164
73 6.0.0.637 2025.02.12 6d0f5 P P 2916 2353 2025.02.14 00:23:14.494 2025.02.14 00:23:17.410 2025.02.13 22:22:55.831 2025.02.13 22:22:58.184

Elapsed time, ms. Chart for last 73 runs:

Last commits information (all timestamps in UTC):