Skip to content

Db2 row validation of test col_char_2 columns fails #1638

@nj1973

Description

@nj1973

Describe the bug
While manually testing Db2 z/OS support I noticed the Db2 LUW row validation tests only hashed a single column.

I added all columns. into the validation and started getting errors like below:

sqlalchemy.exc.DataError: (ibm_db_dbi.DataError) ibm_db_dbi::DataError: Statement Execute Failed: [IBM][CLI Driver] CLI0109E  String data right truncation. SQLSTATE=22001 SQLCODE=-99999

I believe this is because the coalesce(t1.cast__col_char_2, ?) AS ifnull__cast__col_char_2 expression overflows when the replacement token is too long for CHAR(2).

What version of DVT are you using?
8.3.0

What type of connections are you using for source and target?
Db2 LUW

Steps to reproduce the behavior
Add col_char_2 into test test_row_validation_core_types.

Expected behavior
Success.

Metadata

Metadata

Assignees

Labels

No labels
No labels

Type

Projects

No projects

Milestone

No milestone

Relationships

None yet

Development

No branches or pull requests

Issue actions