[ 
https://issues.apache.org/jira/browse/BEAM-13269?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
 ]

Vitaly Ivanov updated BEAM-13269:
---------------------------------
    Description: 
 

The bug in org.apache.beam.sdk.io.jdbc.JdbcUtil#validateLogicalTypeLength
{code:java}
if (length >= maxLimit) {
  throw new RuntimeException(
      String.format(
          "Length of Schema.Field[%s] data exceeds database column capacity",
          field.getName()));
}{code}
Should be
{code:java}
if (length > maxLimit) { {code}
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"

  was:
 

The bug in org.apache.beam.sdk.io.jdbc.JdbcUtil#validateLogicalTypeLength
{code:java}
if (length >= maxLimit) {
  throw new RuntimeException(
      String.format(
          "Length of Schema.Field[%s] data exceeds database column capacity",
          field.getName()));
}{code}
Should be

 
{code:java}
if (length > maxLimit) { {code}
 

 

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"

 


> Data exceeds database column capacity error while inserting in fixed length 
> string column
> -----------------------------------------------------------------------------------------
>
>                 Key: BEAM-13269
>                 URL: https://issues.apache.org/jira/browse/BEAM-13269
>             Project: Beam
>          Issue Type: Bug
>          Components: io-java-jdbc
>    Affects Versions: 2.33.0
>            Reporter: Vitaly Ivanov
>            Priority: P1
>          Time Spent: 20m
>  Remaining Estimate: 0h
>
>  
> The bug in org.apache.beam.sdk.io.jdbc.JdbcUtil#validateLogicalTypeLength
> {code:java}
> if (length >= maxLimit) {
>   throw new RuntimeException(
>       String.format(
>           "Length of Schema.Field[%s] data exceeds database column capacity",
>           field.getName()));
> }{code}
> Should be
> {code:java}
> if (length > maxLimit) { {code}
> 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"



--
This message was sent by Atlassian Jira
(v8.20.1#820001)

Reply via email to