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-01 06:36:21.944
2025-07-01 06:36:21.944 act = <firebird.qa.plugin.Action object at [hex]>
2025-07-01 06:36:21.945 capsys = <_pytest.capture.CaptureFixture object at [hex]>
2025-07-01 06:36:21.945
2025-07-01 06:36:21.945 @pytest.mark.version('>=6')
2025-07-01 06:36:21.945 def test_1(act: Action, capsys):
2025-07-01 06:36:21.945 qry_map = {
2025-07-01 06:36:21.945 1 : 'select * from v1_chk_nr'
2025-07-01 06:36:21.945 ,2 : 'select * from v1_chk_ir_asc'
2025-07-01 06:36:21.945 ,3 : 'select * from v1_chk_ir_dec'
2025-07-01 06:36:21.945 ,4 : 'select * from v2_chk_nr'
2025-07-01 06:36:21.945 ,5 : 'select * from v2_chk_ir_asc'
2025-07-01 06:36:21.945 ,6 : 'select * from v2_chk_ir_dec'
2025-07-01 06:36:21.945 }
2025-07-01 06:36:21.945
2025-07-01 06:36:21.945 alter_lst = (
2025-07-01 06:36:21.945 ''
2025-07-01 06:36:21.945 ,'alter domain dm_utf8 type varchar(1) character set utf8 collate unicode_ci'
2025-07-01 06:36:21.945 ,'alter domain dm_utf8 type varchar(1) character set utf8 collate unicode_ci_ai'
2025-07-01 06:36:21.945 ,'alter domain dm_utf8 type varchar(1) character set utf8'
2025-07-01 06:36:21.945 )
2025-07-01 06:36:21.945
2025-07-01 06:36:21.945 with act.db.connect(charset = 'utf8') as con:
2025-07-01 06:36:21.946 cur = con.cursor()
2025-07-01 06:36:21.946 for alter_i in alter_lst:
2025-07-01 06:36:21.946 if alter_i.strip():
2025-07-01 06:36:21.946 con.execute_immediate(alter_i)
2025-07-01 06:36:21.946 con.commit()
2025-07-01 06:36:21.946 print(f'\nAfter {alter_i}:')
2025-07-01 06:36:21.946 else:
2025-07-01 06:36:21.946 print('Initial state:')
2025-07-01 06:36:21.946
2025-07-01 06:36:21.946 for k, v in qry_map.items():
2025-07-01 06:36:21.946 ps, rs = None, None
2025-07-01 06:36:21.946 try:
2025-07-01 06:36:21.946 ps = cur.prepare(v)
2025-07-01 06:36:21.946
2025-07-01 06:36:21.946 print('Query:', v)
2025-07-01 06:36:21.946 # Print explained plan with padding eash line by dots in order to see indentations:
2025-07-01 06:36:21.946 print( '\n'.join([replace_leading(s) for s in ps.detailed_plan.split('\n')]) )
2025-07-01 06:36:21.946 print('')
2025-07-01 06:36:21.946
2025-07-01 06:36:21.946 # ::: NB ::: 'ps' returns data, i.e. this is SELECTABLE expression.
2025-07-01 06:36:21.946 # We have to store result of cur.execute(<psInstance>) in order to
2025-07-01 06:36:21.946 # close it explicitly.
2025-07-01 06:36:21.947 # Otherwise AV can occur during Python garbage collection and this
2025-07-01 06:36:21.947 # causes pytest to hang on its final point.
2025-07-01 06:36:21.947 # Explained by hvlad, email 26.10.24 17:42
2025-07-01 06:36:21.947 rs = cur.execute(ps)
2025-07-01 06:36:21.947 for r in rs:
2025-07-01 06:36:21.947 print(r[0], r[1])
2025-07-01 06:36:21.947 except DatabaseError as e:
2025-07-01 06:36:21.947 print(e.__str__())
2025-07-01 06:36:21.947 print(e.gds_codes)
2025-07-01 06:36:21.947 finally:
2025-07-01 06:36:21.947 if rs:
2025-07-01 06:36:21.947 rs.close() # <<< EXPLICITLY CLOSING CURSOR RESULTS
2025-07-01 06:36:21.947 if ps:
2025-07-01 06:36:21.947 ps.free()
2025-07-01 06:36:21.947
2025-07-01 06:36:21.947
2025-07-01 06:36:21.947 expected_stdout = """
2025-07-01 06:36:21.947 Initial state:
2025-07-01 06:36:21.947
2025-07-01 06:36:21.947 Query: select * from v1_chk_nr
2025-07-01 06:36:21.947 Select Expression
2025-07-01 06:36:21.948 ....-> Sort (record length: NN, key length: MM)
2025-07-01 06:36:21.948 ........-> Filter
2025-07-01 06:36:21.948 ............-> Table "TEST1" as "V1_CHK_NR TEST1" Full Scan
2025-07-01 06:36:21.948 3 lowered "D" normal
2025-07-01 06:36:21.948 Query: select * from v1_chk_ir_asc
2025-07-01 06:36:21.948 Select Expression
2025-07-01 06:36:21.948 ....-> Filter
2025-07-01 06:36:21.948 ........-> Table "TEST1" as "V1_CHK_IR_ASC TEST1" Access By ID
2025-07-01 06:36:21.948 ............-> Index "TEST1_ASC" Range Scan (full match)
2025-07-01 06:36:21.948 3 lowered "D" normal
2025-07-01 06:36:21.948 Query: select * from v1_chk_ir_dec
2025-07-01 06:36:21.948 Select Expression
2025-07-01 06:36:21.948 ....-> Filter
2025-07-01 06:36:21.948 ........-> Table "TEST1" as "V1_CHK_IR_DEC TEST1" Access By ID
2025-07-01 06:36:21.948 ............-> Index "TEST1_DEC" Range Scan (full match)
2025-07-01 06:36:21.948 3 lowered "D" normal
2025-07-01 06:36:21.948 Query: select * from v2_chk_nr
2025-07-01 06:36:21.948 Select Expression
2025-07-01 06:36:21.948 ....-> Sort (record length: NN, key length: MM)
2025-07-01 06:36:21.948 ........-> Filter
2025-07-01 06:36:21.948 ............-> Table "TEST2" as "V2_CHK_NR TEST2" Full Scan
2025-07-01 06:36:21.948 3 lowered "L" normal
2025-07-01 06:36:21.949 Query: select * from v2_chk_ir_asc
2025-07-01 06:36:21.949 Select Expression
2025-07-01 06:36:21.949 ....-> Filter
2025-07-01 06:36:21.949 ........-> Table "TEST2" as "V2_CHK_IR_ASC TEST2" Access By ID
2025-07-01 06:36:21.949 ............-> Index "TEST2_PARTIAL_ASC" Full Scan
2025-07-01 06:36:21.949 3 lowered "L" normal
2025-07-01 06:36:21.949 Query: select * from v2_chk_ir_dec
2025-07-01 06:36:21.949 Select Expression
2025-07-01 06:36:21.949 ....-> Sort (record length: NN, key length: MM)
2025-07-01 06:36:21.949 ........-> Filter
2025-07-01 06:36:21.949 ............-> Table "TEST2" as "V2_CHK_IR_DEC TEST2" Access By ID
2025-07-01 06:36:21.949 ................-> Bitmap
2025-07-01 06:36:21.949 ....................-> Index "TEST2_PARTIAL_ASC" Full Scan
2025-07-01 06:36:21.949 3 lowered "L" normal
2025-07-01 06:36:21.949
2025-07-01 06:36:21.949
2025-07-01 06:36:21.949 After alter domain dm_utf8 type varchar(1) character set utf8 collate unicode_ci:
2025-07-01 06:36:21.949
2025-07-01 06:36:21.949 Query: select * from v1_chk_nr
2025-07-01 06:36:21.949 Select Expression
2025-07-01 06:36:21.949 ....-> Sort (record length: NN, key length: MM)
2025-07-01 06:36:21.950 ........-> Filter
2025-07-01 06:36:21.950 ............-> Table "TEST1" as "V1_CHK_NR TEST1" Full Scan
2025-07-01 06:36:21.950 3 lowered "D" normal
2025-07-01 06:36:21.950 4 UPPERED "D" normal
2025-07-01 06:36:21.950 Query: select * from v1_chk_ir_asc
2025-07-01 06:36:21.950 Select Expression
2025-07-01 06:36:21.950 ....-> Filter
2025-07-01 06:36:21.950 ........-> Table "TEST1" as "V1_CHK_IR_ASC TEST1" Access By ID
2025-07-01 06:36:21.950 ............-> Index "TEST1_ASC" Range Scan (full match)
2025-07-01 06:36:21.950 3 lowered "D" normal
2025-07-01 06:36:21.950 4 UPPERED "D" normal
2025-07-01 06:36:21.950 Query: select * from v1_chk_ir_dec
2025-07-01 06:36:21.950 Select Expression
2025-07-01 06:36:21.950 ....-> Filter
2025-07-01 06:36:21.950 ........-> Table "TEST1" as "V1_CHK_IR_DEC TEST1" Access By ID
2025-07-01 06:36:21.950 ............-> Index "TEST1_DEC" Range Scan (full match)
2025-07-01 06:36:21.950 4 UPPERED "D" normal
2025-07-01 06:36:21.950 3 lowered "D" normal
2025-07-01 06:36:21.950 Query: select * from v2_chk_nr
2025-07-01 06:36:21.950 Select Expression
2025-07-01 06:36:21.951 ....-> Sort (record length: NN, key length: MM)
2025-07-01 06:36:21.951 ........-> Filter
2025-07-01 06:36:21.951 ............-> Table "TEST2" as "V2_CHK_NR TEST2" Full Scan
2025-07-01 06:36:21.951 3 lowered "L" normal
2025-07-01 06:36:21.951 4 UPPERED "L" normal
2025-07-01 06:36:21.951 Query: select * from v2_chk_ir_asc
2025-07-01 06:36:21.951 Select Expression
2025-07-01 06:36:21.951 ....-> Filter
2025-07-01 06:36:21.951 ........-> Table "TEST2" as "V2_CHK_IR_ASC TEST2" Access By ID
2025-07-01 06:36:21.951 ............-> Index "TEST2_PARTIAL_ASC" Full Scan
2025-07-01 06:36:21.951 3 lowered "L" normal
2025-07-01 06:36:21.951 4 UPPERED "L" normal
2025-07-01 06:36:21.951 Query: select * from v2_chk_ir_dec
2025-07-01 06:36:21.951 Select Expression
2025-07-01 06:36:21.951 ....-> Sort (record length: NN, key length: MM)
2025-07-01 06:36:21.951 ........-> Filter
2025-07-01 06:36:21.951 ............-> Table "TEST2" as "V2_CHK_IR_DEC TEST2" Access By ID
2025-07-01 06:36:21.951 ................-> Bitmap
2025-07-01 06:36:21.951 ....................-> Index "TEST2_PARTIAL_ASC" Full Scan
2025-07-01 06:36:21.951 4 UPPERED "L" normal
2025-07-01 06:36:21.951 3 lowered "L" normal
2025-07-01 06:36:21.952
2025-07-01 06:36:21.952
2025-07-01 06:36:21.952 After alter domain dm_utf8 type varchar(1) character set utf8 collate unicode_ci_ai:
2025-07-01 06:36:21.952
2025-07-01 06:36:21.952 Query: select * from v1_chk_nr
2025-07-01 06:36:21.952 Select Expression
2025-07-01 06:36:21.952 ....-> Sort (record length: NN, key length: MM)
2025-07-01 06:36:21.952 ........-> Filter
2025-07-01 06:36:21.952 ............-> Table "TEST1" as "V1_CHK_NR TEST1" Full Scan
2025-07-01 06:36:21.952 1 lowered "D" w/accent
2025-07-01 06:36:21.952 2 UPPERED "D" w/accent
2025-07-01 06:36:21.952 3 lowered "D" normal
2025-07-01 06:36:21.952 4 UPPERED "D" normal
2025-07-01 06:36:21.952 Query: select * from v1_chk_ir_asc
2025-07-01 06:36:21.952 Select Expression
2025-07-01 06:36:21.952 ....-> Filter
2025-07-01 06:36:21.952 ........-> Table "TEST1" as "V1_CHK_IR_ASC TEST1" Access By ID
2025-07-01 06:36:21.952 ............-> Index "TEST1_ASC" Range Scan (full match)
2025-07-01 06:36:21.952 3 lowered "D" normal
2025-07-01 06:36:21.952 4 UPPERED "D" normal
2025-07-01 06:36:21.953 1 lowered "D" w/accent
2025-07-01 06:36:21.953 2 UPPERED "D" w/accent
2025-07-01 06:36:21.953 Query: select * from v1_chk_ir_dec
2025-07-01 06:36:21.953 Select Expression
2025-07-01 06:36:21.953 ....-> Filter
2025-07-01 06:36:21.953 ........-> Table "TEST1" as "V1_CHK_IR_DEC TEST1" Access By ID
2025-07-01 06:36:21.953 ............-> Index "TEST1_DEC" Range Scan (full match)
2025-07-01 06:36:21.953 2 UPPERED "D" w/accent
2025-07-01 06:36:21.953 1 lowered "D" w/accent
2025-07-01 06:36:21.953 4 UPPERED "D" normal
2025-07-01 06:36:21.953 3 lowered "D" normal
2025-07-01 06:36:21.953 Query: select * from v2_chk_nr
2025-07-01 06:36:21.953 Select Expression
2025-07-01 06:36:21.953 ....-> Sort (record length: NN, key length: MM)
2025-07-01 06:36:21.953 ........-> Filter
2025-07-01 06:36:21.953 ............-> Table "TEST2" as "V2_CHK_NR TEST2" Full Scan
2025-07-01 06:36:21.953 1 lowered "L" w/accent
2025-07-01 06:36:21.953 2 UPPERED "L" w/accent
2025-07-01 06:36:21.953 3 lowered "L" normal
2025-07-01 06:36:21.953 4 UPPERED "L" normal
2025-07-01 06:36:21.953 Query: select * from v2_chk_ir_asc
2025-07-01 06:36:21.954 Select Expression
2025-07-01 06:36:21.954 ....-> Filter
2025-07-01 06:36:21.954 ........-> Table "TEST2" as "V2_CHK_IR_ASC TEST2" Access By ID
2025-07-01 06:36:21.954 ............-> Index "TEST2_PARTIAL_ASC" Full Scan
2025-07-01 06:36:21.954 3 lowered "L" normal
2025-07-01 06:36:21.954 4 UPPERED "L" normal
2025-07-01 06:36:21.954 1 lowered "L" w/accent
2025-07-01 06:36:21.954 2 UPPERED "L" w/accent
2025-07-01 06:36:21.954 Query: select * from v2_chk_ir_dec
2025-07-01 06:36:21.954 Select Expression
2025-07-01 06:36:21.954 ....-> Sort (record length: NN, key length: MM)
2025-07-01 06:36:21.954 ........-> Filter
2025-07-01 06:36:21.954 ............-> Table "TEST2" as "V2_CHK_IR_DEC TEST2" Access By ID
2025-07-01 06:36:21.954 ................-> Bitmap
2025-07-01 06:36:21.954 ....................-> Index "TEST2_PARTIAL_ASC" Full Scan
2025-07-01 06:36:21.954 2 UPPERED "L" w/accent
2025-07-01 06:36:21.954 1 lowered "L" w/accent
2025-07-01 06:36:21.954 4 UPPERED "L" normal
2025-07-01 06:36:21.954 3 lowered "L" normal
2025-07-01 06:36:21.954
2025-07-01 06:36:21.955
2025-07-01 06:36:21.955 After alter domain dm_utf8 type varchar(1) character set utf8:
2025-07-01 06:36:21.955
2025-07-01 06:36:21.955 Query: select * from v1_chk_nr
2025-07-01 06:36:21.955 Select Expression
2025-07-01 06:36:21.955 ....-> Sort (record length: NN, key length: MM)
2025-07-01 06:36:21.955 ........-> Filter
2025-07-01 06:36:21.955 ............-> Table "TEST1" as "V1_CHK_NR TEST1" Full Scan
2025-07-01 06:36:21.955 3 lowered "D" normal
2025-07-01 06:36:21.955 Query: select * from v1_chk_ir_asc
2025-07-01 06:36:21.955 Select Expression
2025-07-01 06:36:21.955 ....-> Filter
2025-07-01 06:36:21.955 ........-> Table "TEST1" as "V1_CHK_IR_ASC TEST1" Access By ID
2025-07-01 06:36:21.955 ............-> Index "TEST1_ASC" Range Scan (full match)
2025-07-01 06:36:21.955 3 lowered "D" normal
2025-07-01 06:36:21.955 Query: select * from v1_chk_ir_dec
2025-07-01 06:36:21.955 Select Expression
2025-07-01 06:36:21.955 ....-> Filter
2025-07-01 06:36:21.955 ........-> Table "TEST1" as "V1_CHK_IR_DEC TEST1" Access By ID
2025-07-01 06:36:21.955 ............-> Index "TEST1_DEC" Range Scan (full match)
2025-07-01 06:36:21.955 3 lowered "D" normal
2025-07-01 06:36:21.956 Query: select * from v2_chk_nr
2025-07-01 06:36:21.956 Select Expression
2025-07-01 06:36:21.956 ....-> Sort (record length: NN, key length: MM)
2025-07-01 06:36:21.956 ........-> Filter
2025-07-01 06:36:21.956 ............-> Table "TEST2" as "V2_CHK_NR TEST2" Full Scan
2025-07-01 06:36:21.956 3 lowered "L" normal
2025-07-01 06:36:21.956 Query: select * from v2_chk_ir_asc
2025-07-01 06:36:21.956 Select Expression
2025-07-01 06:36:21.956 ....-> Filter
2025-07-01 06:36:21.956 ........-> Table "TEST2" as "V2_CHK_IR_ASC TEST2" Access By ID
2025-07-01 06:36:21.956 ............-> Index "TEST2_PARTIAL_ASC" Full Scan
2025-07-01 06:36:21.956 3 lowered "L" normal
2025-07-01 06:36:21.956 Query: select * from v2_chk_ir_dec
2025-07-01 06:36:21.956 Select Expression
2025-07-01 06:36:21.956 ....-> Sort (record length: NN, key length: MM)
2025-07-01 06:36:21.956 ........-> Filter
2025-07-01 06:36:21.956 ............-> Table "TEST2" as "V2_CHK_IR_DEC TEST2" Access By ID
2025-07-01 06:36:21.956 ................-> Bitmap
2025-07-01 06:36:21.956 ....................-> Index "TEST2_PARTIAL_ASC" Full Scan
2025-07-01 06:36:21.956 3 lowered "L" normal
2025-07-01 06:36:21.956 """
2025-07-01 06:36:21.957
2025-07-01 06:36:21.957 act.expected_stdout = expected_stdout
2025-07-01 06:36:21.957
2025-07-01 06:36:21.957 act.stdout = capsys.readouterr().out
2025-07-01 06:36:21.957 > assert act.clean_stdout == act.clean_expected_stdout
2025-07-01 06:36:21.957 E assert
2025-07-01 06:36:21.957 E Initial state:
2025-07-01 06:36:21.957 E Query: select * from v1_chk_nr
2025-07-01 06:36:21.957 E Select Expression
2025-07-01 06:36:21.957 E ....-> Sort (record length: NN, key length: MM)
2025-07-01 06:36:21.957 E ........-> Filter
2025-07-01 06:36:21.957 E - ............-> Table "TEST1" as "V1_CHK_NR TEST1" Full Scan
2025-07-01 06:36:21.957 E + ............-> Table "PUBLIC"."TEST1" as "PUBLIC"."V1_CHK_NR" "PUBLIC"."TEST1" Full Scan
2025-07-01 06:36:21.957 E 3 lowered "D" normal
2025-07-01 06:36:21.957 E Query: select * from v1_chk_ir_asc
2025-07-01 06:36:21.957 E Select Expression
2025-07-01 06:36:21.957 E ....-> Filter
2025-07-01 06:36:21.957 E - ........-> Table "TEST1" as "V1_CHK_IR_ASC TEST1" Access By ID
2025-07-01 06:36:21.958 E + ........-> Table "PUBLIC"."TEST1" as "PUBLIC"."V1_CHK_IR_ASC" "PUBLIC"."TEST1" Access By ID
2025-07-01 06:36:21.958 E - ............-> Index "TEST1_ASC" Range Scan (full match)
2025-07-01 06:36:21.958 E + ............-> Index "PUBLIC"."TEST1_ASC" Range Scan (full match)
2025-07-01 06:36:21.958 E 3 lowered "D" normal
2025-07-01 06:36:21.958 E Query: select * from v1_chk_ir_dec
2025-07-01 06:36:21.958 E Select Expression
2025-07-01 06:36:21.958 E ....-> Filter
2025-07-01 06:36:21.958 E - ........-> Table "TEST1" as "V1_CHK_IR_DEC TEST1" Access By ID
2025-07-01 06:36:21.958 E + ........-> Table "PUBLIC"."TEST1" as "PUBLIC"."V1_CHK_IR_DEC" "PUBLIC"."TEST1" Access By ID
2025-07-01 06:36:21.958 E - ............-> Index "TEST1_DEC" Range Scan (full match)
2025-07-01 06:36:21.958 E + ............-> Index "PUBLIC"."TEST1_DEC" Range Scan (full match)
2025-07-01 06:36:21.958 E 3 lowered "D" normal
2025-07-01 06:36:21.958 E Query: select * from v2_chk_nr
2025-07-01 06:36:21.958 E Select Expression
2025-07-01 06:36:21.959 E ....-> Sort (record length: NN, key length: MM)
2025-07-01 06:36:21.959 E ........-> Filter
2025-07-01 06:36:21.959 E - ............-> Table "TEST2" as "V2_CHK_NR TEST2" Full Scan
2025-07-01 06:36:21.959 E + ............-> Table "PUBLIC"."TEST2" as "PUBLIC"."V2_CHK_NR" "PUBLIC"."TEST2" Full Scan
2025-07-01 06:36:21.959 E 3 lowered "L" normal
2025-07-01 06:36:21.959 E Query: select * from v2_chk_ir_asc
2025-07-01 06:36:21.959 E Select Expression
2025-07-01 06:36:21.959 E ....-> Filter
2025-07-01 06:36:21.959 E - ........-> Table "TEST2" as "V2_CHK_IR_ASC TEST2" Access By ID
2025-07-01 06:36:21.959 E + ........-> Table "PUBLIC"."TEST2" as "PUBLIC"."V2_CHK_IR_ASC" "PUBLIC"."TEST2" Access By ID
2025-07-01 06:36:21.959 E - ............-> Index "TEST2_PARTIAL_ASC" Full Scan
2025-07-01 06:36:21.959 E + ............-> Index "PUBLIC"."TEST2_PARTIAL_ASC" Full Scan
2025-07-01 06:36:21.959 E 3 lowered "L" normal
2025-07-01 06:36:21.959 E Query: select * from v2_chk_ir_dec
2025-07-01 06:36:21.960 E Select Expression
2025-07-01 06:36:21.960 E ....-> Sort (record length: NN, key length: MM)
2025-07-01 06:36:21.960 E ........-> Filter
2025-07-01 06:36:21.960 E - ............-> Table "TEST2" as "V2_CHK_IR_DEC TEST2" Access By ID
2025-07-01 06:36:21.960 E + ............-> Table "PUBLIC"."TEST2" as "PUBLIC"."V2_CHK_IR_DEC" "PUBLIC"."TEST2" Access By ID
2025-07-01 06:36:21.960 E ................-> Bitmap
2025-07-01 06:36:21.960 E - ....................-> Index "TEST2_PARTIAL_ASC" Full Scan
2025-07-01 06:36:21.960 E + ....................-> Index "PUBLIC"."TEST2_PARTIAL_ASC" Full Scan
2025-07-01 06:36:21.960 E 3 lowered "L" normal
2025-07-01 06:36:21.960 E After alter domain dm_utf8 type varchar(1) character set utf8 collate unicode_ci:
2025-07-01 06:36:21.960 E Query: select * from v1_chk_nr
2025-07-01 06:36:21.960 E Select Expression
2025-07-01 06:36:21.960 E ....-> Sort (record length: NN, key length: MM)
2025-07-01 06:36:21.960 E ........-> Filter
2025-07-01 06:36:21.960 E - ............-> Table "TEST1" as "V1_CHK_NR TEST1" Full Scan
2025-07-01 06:36:21.960 E + ............-> Table "PUBLIC"."TEST1" as "PUBLIC"."V1_CHK_NR" "PUBLIC"."TEST1" Full Scan
2025-07-01 06:36:21.961 E 3 lowered "D" normal
2025-07-01 06:36:21.961 E 4 UPPERED "D" normal
2025-07-01 06:36:21.961 E Query: select * from v1_chk_ir_asc
2025-07-01 06:36:21.961 E Select Expression
2025-07-01 06:36:21.961 E ....-> Filter
2025-07-01 06:36:21.961 E - ........-> Table "TEST1" as "V1_CHK_IR_ASC TEST1" Access By ID
2025-07-01 06:36:21.961 E + ........-> Table "PUBLIC"."TEST1" as "PUBLIC"."V1_CHK_IR_ASC" "PUBLIC"."TEST1" Access By ID
2025-07-01 06:36:21.961 E - ............-> Index "TEST1_ASC" Range Scan (full match)
2025-07-01 06:36:21.961 E + ............-> Index "PUBLIC"."TEST1_ASC" Range Scan (full match)
2025-07-01 06:36:21.961 E 3 lowered "D" normal
2025-07-01 06:36:21.961 E 4 UPPERED "D" normal
2025-07-01 06:36:21.961 E Query: select * from v1_chk_ir_dec
2025-07-01 06:36:21.961 E Select Expression
2025-07-01 06:36:21.961 E ....-> Filter
2025-07-01 06:36:21.961 E - ........-> Table "TEST1" as "V1_CHK_IR_DEC TEST1" Access By ID
2025-07-01 06:36:21.962 E + ........-> Table "PUBLIC"."TEST1" as "PUBLIC"."V1_CHK_IR_DEC" "PUBLIC"."TEST1" Access By ID
2025-07-01 06:36:21.962 E - ............-> Index "TEST1_DEC" Range Scan (full match)
2025-07-01 06:36:21.962 E + ............-> Index "PUBLIC"."TEST1_DEC" Range Scan (full match)
2025-07-01 06:36:21.962 E 4 UPPERED "D" normal
2025-07-01 06:36:21.962 E 3 lowered "D" normal
2025-07-01 06:36:21.962 E Query: select * from v2_chk_nr
2025-07-01 06:36:21.962 E Select Expression
2025-07-01 06:36:21.962 E ....-> Sort (record length: NN, key length: MM)
2025-07-01 06:36:21.962 E ........-> Filter
2025-07-01 06:36:21.962 E - ............-> Table "TEST2" as "V2_CHK_NR TEST2" Full Scan
2025-07-01 06:36:21.962 E + ............-> Table "PUBLIC"."TEST2" as "PUBLIC"."V2_CHK_NR" "PUBLIC"."TEST2" Full Scan
2025-07-01 06:36:21.962 E 3 lowered "L" normal
2025-07-01 06:36:21.962 E 4 UPPERED "L" normal
2025-07-01 06:36:21.962 E Query: select * from v2_chk_ir_asc
2025-07-01 06:36:21.962 E Select Expression
2025-07-01 06:36:21.962 E ....-> Filter
2025-07-01 06:36:21.962 E - ........-> Table "TEST2" as "V2_CHK_IR_ASC TEST2" Access By ID
2025-07-01 06:36:21.963 E + ........-> Table "PUBLIC"."TEST2" as "PUBLIC"."V2_CHK_IR_ASC" "PUBLIC"."TEST2" Access By ID
2025-07-01 06:36:21.963 E - ............-> Index "TEST2_PARTIAL_ASC" Full Scan
2025-07-01 06:36:21.963 E + ............-> Index "PUBLIC"."TEST2_PARTIAL_ASC" Full Scan
2025-07-01 06:36:21.963 E 3 lowered "L" normal
2025-07-01 06:36:21.963 E 4 UPPERED "L" normal
2025-07-01 06:36:21.963 E Query: select * from v2_chk_ir_dec
2025-07-01 06:36:21.963 E Select Expression
2025-07-01 06:36:21.963 E ....-> Sort (record length: NN, key length: MM)
2025-07-01 06:36:21.963 E ........-> Filter
2025-07-01 06:36:21.963 E - ............-> Table "TEST2" as "V2_CHK_IR_DEC TEST2" Access By ID
2025-07-01 06:36:21.963 E + ............-> Table "PUBLIC"."TEST2" as "PUBLIC"."V2_CHK_IR_DEC" "PUBLIC"."TEST2" Access By ID
2025-07-01 06:36:21.963 E ................-> Bitmap
2025-07-01 06:36:21.963 E - ....................-> Index "TEST2_PARTIAL_ASC" Full Scan
2025-07-01 06:36:21.963 E + ....................-> Index "PUBLIC"."TEST2_PARTIAL_ASC" Full Scan
2025-07-01 06:36:21.964 E 4 UPPERED "L" normal
2025-07-01 06:36:21.964 E 3 lowered "L" normal
2025-07-01 06:36:21.964 E After alter domain dm_utf8 type varchar(1) character set utf8 collate unicode_ci_ai:
2025-07-01 06:36:21.964 E Query: select * from v1_chk_nr
2025-07-01 06:36:21.964 E Select Expression
2025-07-01 06:36:21.964 E ....-> Sort (record length: NN, key length: MM)
2025-07-01 06:36:21.964 E ........-> Filter
2025-07-01 06:36:21.964 E - ............-> Table "TEST1" as "V1_CHK_NR TEST1" Full Scan
2025-07-01 06:36:21.964 E + ............-> Table "PUBLIC"."TEST1" as "PUBLIC"."V1_CHK_NR" "PUBLIC"."TEST1" Full Scan
2025-07-01 06:36:21.964 E 1 lowered "D" w/accent
2025-07-01 06:36:21.964 E 2 UPPERED "D" w/accent
2025-07-01 06:36:21.964 E 3 lowered "D" normal
2025-07-01 06:36:21.964 E 4 UPPERED "D" normal
2025-07-01 06:36:21.964 E Query: select * from v1_chk_ir_asc
2025-07-01 06:36:21.964 E Select Expression
2025-07-01 06:36:21.964 E ....-> Filter
2025-07-01 06:36:21.964 E - ........-> Table "TEST1" as "V1_CHK_IR_ASC TEST1" Access By ID
2025-07-01 06:36:21.965 E + ........-> Table "PUBLIC"."TEST1" as "PUBLIC"."V1_CHK_IR_ASC" "PUBLIC"."TEST1" Access By ID
2025-07-01 06:36:21.965 E - ............-> Index "TEST1_ASC" Range Scan (full match)
2025-07-01 06:36:21.965 E + ............-> Index "PUBLIC"."TEST1_ASC" Range Scan (full match)
2025-07-01 06:36:21.965 E 3 lowered "D" normal
2025-07-01 06:36:21.965 E 4 UPPERED "D" normal
2025-07-01 06:36:21.965 E 1 lowered "D" w/accent
2025-07-01 06:36:21.965 E 2 UPPERED "D" w/accent
2025-07-01 06:36:21.965 E Query: select * from v1_chk_ir_dec
2025-07-01 06:36:21.965 E Select Expression
2025-07-01 06:36:21.965 E ....-> Filter
2025-07-01 06:36:21.965 E - ........-> Table "TEST1" as "V1_CHK_IR_DEC TEST1" Access By ID
2025-07-01 06:36:21.965 E + ........-> Table "PUBLIC"."TEST1" as "PUBLIC"."V1_CHK_IR_DEC" "PUBLIC"."TEST1" Access By ID
2025-07-01 06:36:21.965 E - ............-> Index "TEST1_DEC" Range Scan (full match)
2025-07-01 06:36:21.965 E + ............-> Index "PUBLIC"."TEST1_DEC" Range Scan (full match)
2025-07-01 06:36:21.965 E 2 UPPERED "D" w/accent
2025-07-01 06:36:21.966 E 1 lowered "D" w/accent
2025-07-01 06:36:21.966 E 4 UPPERED "D" normal
2025-07-01 06:36:21.966 E 3 lowered "D" normal
2025-07-01 06:36:21.966 E Query: select * from v2_chk_nr
2025-07-01 06:36:21.966 E Select Expression
2025-07-01 06:36:21.966 E ....-> Sort (record length: NN, key length: MM)
2025-07-01 06:36:21.970 E ........-> Filter
2025-07-01 06:36:21.970 E - ............-> Table "TEST2" as "V2_CHK_NR TEST2" Full Scan
2025-07-01 06:36:21.970 E + ............-> Table "PUBLIC"."TEST2" as "PUBLIC"."V2_CHK_NR" "PUBLIC"."TEST2" Full Scan
2025-07-01 06:36:21.970 E 1 lowered "L" w/accent
2025-07-01 06:36:21.970 E 2 UPPERED "L" w/accent
2025-07-01 06:36:21.970 E 3 lowered "L" normal
2025-07-01 06:36:21.970 E 4 UPPERED "L" normal
2025-07-01 06:36:21.970 E Query: select * from v2_chk_ir_asc
2025-07-01 06:36:21.970 E Select Expression
2025-07-01 06:36:21.970 E ....-> Filter
2025-07-01 06:36:21.970 E - ........-> Table "TEST2" as "V2_CHK_IR_ASC TEST2" Access By ID
2025-07-01 06:36:21.970 E + ........-> Table "PUBLIC"."TEST2" as "PUBLIC"."V2_CHK_IR_ASC" "PUBLIC"."TEST2" Access By ID
2025-07-01 06:36:21.970 E - ............-> Index "TEST2_PARTIAL_ASC" Full Scan
2025-07-01 06:36:21.970 E + ............-> Index "PUBLIC"."TEST2_PARTIAL_ASC" Full Scan
2025-07-01 06:36:21.971 E 3 lowered "L" normal
2025-07-01 06:36:21.971 E 4 UPPERED "L" normal
2025-07-01 06:36:21.971 E 1 lowered "L" w/accent
2025-07-01 06:36:21.971 E 2 UPPERED "L" w/accent
2025-07-01 06:36:21.971 E Query: select * from v2_chk_ir_dec
2025-07-01 06:36:21.971 E Select Expression
2025-07-01 06:36:21.971 E ....-> Sort (record length: NN, key length: MM)
2025-07-01 06:36:21.971 E ........-> Filter
2025-07-01 06:36:21.971 E - ............-> Table "TEST2" as "V2_CHK_IR_DEC TEST2" Access By ID
2025-07-01 06:36:21.971 E + ............-> Table "PUBLIC"."TEST2" as "PUBLIC"."V2_CHK_IR_DEC" "PUBLIC"."TEST2" Access By ID
2025-07-01 06:36:21.971 E ................-> Bitmap
2025-07-01 06:36:21.971 E - ....................-> Index "TEST2_PARTIAL_ASC" Full Scan
2025-07-01 06:36:21.971 E + ....................-> Index "PUBLIC"."TEST2_PARTIAL_ASC" Full Scan
2025-07-01 06:36:21.971 E 2 UPPERED "L" w/accent
2025-07-01 06:36:21.971 E 1 lowered "L" w/accent
2025-07-01 06:36:21.971 E 4 UPPERED "L" normal
2025-07-01 06:36:21.972 E 3 lowered "L" normal
2025-07-01 06:36:21.972 E After alter domain dm_utf8 type varchar(1) character set utf8:
2025-07-01 06:36:21.972 E Query: select * from v1_chk_nr
2025-07-01 06:36:21.972 E Select Expression
2025-07-01 06:36:21.972 E ....-> Sort (record length: NN, key length: MM)
2025-07-01 06:36:21.972 E ........-> Filter
2025-07-01 06:36:21.972 E - ............-> Table "TEST1" as "V1_CHK_NR TEST1" Full Scan
2025-07-01 06:36:21.972 E + ............-> Table "PUBLIC"."TEST1" as "PUBLIC"."V1_CHK_NR" "PUBLIC"."TEST1" Full Scan
2025-07-01 06:36:21.972 E 3 lowered "D" normal
2025-07-01 06:36:21.972 E Query: select * from v1_chk_ir_asc
2025-07-01 06:36:21.972 E Select Expression
2025-07-01 06:36:21.972 E ....-> Filter
2025-07-01 06:36:21.972 E - ........-> Table "TEST1" as "V1_CHK_IR_ASC TEST1" Access By ID
2025-07-01 06:36:21.972 E + ........-> Table "PUBLIC"."TEST1" as "PUBLIC"."V1_CHK_IR_ASC" "PUBLIC"."TEST1" Access By ID
2025-07-01 06:36:21.972 E - ............-> Index "TEST1_ASC" Range Scan (full match)
2025-07-01 06:36:21.972 E + ............-> Index "PUBLIC"."TEST1_ASC" Range Scan (full match)
2025-07-01 06:36:21.973 E 3 lowered "D" normal
2025-07-01 06:36:21.973 E Query: select * from v1_chk_ir_dec
2025-07-01 06:36:21.973 E Select Expression
2025-07-01 06:36:21.973 E ....-> Filter
2025-07-01 06:36:21.973 E - ........-> Table "TEST1" as "V1_CHK_IR_DEC TEST1" Access By ID
2025-07-01 06:36:21.973 E + ........-> Table "PUBLIC"."TEST1" as "PUBLIC"."V1_CHK_IR_DEC" "PUBLIC"."TEST1" Access By ID
2025-07-01 06:36:21.973 E - ............-> Index "TEST1_DEC" Range Scan (full match)
2025-07-01 06:36:21.973 E + ............-> Index "PUBLIC"."TEST1_DEC" Range Scan (full match)
2025-07-01 06:36:21.973 E 3 lowered "D" normal
2025-07-01 06:36:21.973 E Query: select * from v2_chk_nr
2025-07-01 06:36:21.973 E Select Expression
2025-07-01 06:36:21.973 E ....-> Sort (record length: NN, key length: MM)
2025-07-01 06:36:21.973 E ........-> Filter
2025-07-01 06:36:21.973 E - ............-> Table "TEST2" as "V2_CHK_NR TEST2" Full Scan
2025-07-01 06:36:21.974 E + ............-> Table "PUBLIC"."TEST2" as "PUBLIC"."V2_CHK_NR" "PUBLIC"."TEST2" Full Scan
2025-07-01 06:36:21.974 E 3 lowered "L" normal
2025-07-01 06:36:21.974 E Query: select * from v2_chk_ir_asc
2025-07-01 06:36:21.974 E Select Expression
2025-07-01 06:36:21.974 E ....-> Filter
2025-07-01 06:36:21.974 E - ........-> Table "TEST2" as "V2_CHK_IR_ASC TEST2" Access By ID
2025-07-01 06:36:21.974 E + ........-> Table "PUBLIC"."TEST2" as "PUBLIC"."V2_CHK_IR_ASC" "PUBLIC"."TEST2" Access By ID
2025-07-01 06:36:21.974 E - ............-> Index "TEST2_PARTIAL_ASC" Full Scan
2025-07-01 06:36:21.974 E + ............-> Index "PUBLIC"."TEST2_PARTIAL_ASC" Full Scan
2025-07-01 06:36:21.974 E 3 lowered "L" normal
2025-07-01 06:36:21.974 E Query: select * from v2_chk_ir_dec
2025-07-01 06:36:21.974 E Select Expression
2025-07-01 06:36:21.974 E ....-> Sort (record length: NN, key length: MM)
2025-07-01 06:36:21.974 E ........-> Filter
2025-07-01 06:36:21.974 E - ............-> Table "TEST2" as "V2_CHK_IR_DEC TEST2" Access By ID
2025-07-01 06:36:21.975 E + ............-> Table "PUBLIC"."TEST2" as "PUBLIC"."V2_CHK_IR_DEC" "PUBLIC"."TEST2" Access By ID
2025-07-01 06:36:21.975 E ................-> Bitmap
2025-07-01 06:36:21.975 E - ....................-> Index "TEST2_PARTIAL_ASC" Full Scan
2025-07-01 06:36:21.975 E + ....................-> Index "PUBLIC"."TEST2_PARTIAL_ASC" Full Scan
2025-07-01 06:36:21.975 E 3 lowered "L" normal
2025-07-01 06:36:21.975
2025-07-01 06:36:21.975 tests\bugs\gh_8434_test.py:371: AssertionError
2025-07-01 06:36:21.975 ---------------------------- Captured stdout setup ----------------------------
2025-07-01 06:36:21.975 Creating db: localhost:H:\QA\temp\qa2024.tmp\fbqa\test_11764\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
|