[BEAM-13269] Data exceeds database column capacity error while inserting in fixed length string column

• Type: Bug
• Status: Resolved
• Priority: P1
• Resolution: Fixed
• Affects Version/s: 2.33.0
• Fix Version/s: 2.35.0
• Component/s: io-java-jdbc
• Assignee: Vitaly Ivanov
• Reporter: Vitaly Ivanov
• Created: 17/Nov/21 13:47
• Updated: 12/Jan/22 07:01
• Resolved: 12/Jan/22 07:01

Description

 

The bug in org.apache.beam.sdk.io.jdbc.JdbcUtil#validateLogicalTypeLength

if (length >= maxLimit) {
  throw new RuntimeException(
      String.format(
          "Length of Schema.Field[%s] data exceeds database column capacity",
          field.getName()));
}

Should be

if (length > maxLimit) { 

How to reproduce:

• Create column with type VARCHAR(4).
• Try to insert "Test"

ER: Success

AR: Error "Length of Schema.Field[%s] data exceeds database column capacity"

Issue Links

• links to: GitHub Pull Request #16005