Source IBM Db2: Connector provides wrong values for a datatype

[irynakruk]

Expected Behavior

A connector should transform source data into an Airbyte datatype without value/meaning losses.

Current Behavior

General source implementation:

• DECFLOAT : in case of NaN, +Infinity, -Infinity fails with com.ibm.db2.jcc.am.SqlException during conversion to BigDecimal.
  Could be fixed by mapping DECFLOAT to Double or String according to:
  https://www.ibm.com/docs/en/db2/11.5?topic=dttmddtija-retrieval-special-values-from-decfloat-columns-in-java-applications

Logs

Caused by: com.ibm.db2.jcc.am.SqlException: [jcc][t4][6011][10987][4.28.11] An error occurred during the conversion of column 2 of type DECFLOAT(34) with a Infinity value to a value of type java.math.BigDecimal. ERRORCODE=-4231, SQLSTATE=null

Caused by: com.ibm.db2.jcc.am.SqlException: [jcc][t4][6011][10987][4.28.11] An error occurred during the conversion of column 2 of type DECFLOAT(34) with a NaN value to a value of type java.math.BigDecimal. ERRORCODE=-4231, SQLSTATE=null

Steps to Reproduce

Short way:

1. Checkout master branch
2. Go to Db2SourceComprehensiveTest.java and find a test with appropriate type. Uncomment the test.
3. Run the test.

NOTES: To REMEMBER while fixing this bug: Most of the cases would need to be corrected at JdbcUtils, but this is based class that is used by all others JDBC DBs, i.e. all other JDBC DBs will be affected

Severity of the bug for you

High

Airbyte Version

0.26.1-alpha

Connector Version (if applicable)

0.1.0

Additional context

Origin ticket: #2975