[
https://issues.apache.org/jira/browse/TRAFODION-3259?focusedWorklogId=191878&page=com.atlassian.jira.plugin.system.issuetabpanels:worklog-tabpanel#worklog-191878
]
ASF GitHub Bot logged work on TRAFODION-3259:
---------------------------------------------
Author: ASF GitHub Bot
Created on: 29/Jan/19 20:12
Start Date: 29/Jan/19 20:12
Worklog Time Spent: 10m
Work Description: Traf-Jenkins commented on issue #1783: [TRAFODION-3259]
Length of varchar exceeds 65536 insert data will fail
URL: https://github.com/apache/trafodion/pull/1783#issuecomment-458689630
Test Passed. https://jenkins.esgyn.com/job/Check-PR-master/3114/
----------------------------------------------------------------
This is an automated message from the Apache Git Service.
To respond to the message, please log on GitHub and use the
URL above to go to the specific comment.
For queries about this service, please contact Infrastructure at:
[email protected]
Issue Time Tracking
-------------------
Worklog Id: (was: 191878)
Time Spent: 1h 40m (was: 1.5h)
> When the length of the varchar exceeds 65536, insert into data will fail
> ------------------------------------------------------------------------
>
> Key: TRAFODION-3259
> URL: https://issues.apache.org/jira/browse/TRAFODION-3259
> Project: Apache Trafodion
> Issue Type: Bug
> Components: sql-exe
> Affects Versions: any
> Reporter: junluwei
> Priority: Major
> Time Spent: 1h 40m
> Remaining Estimate: 0h
>
> | |Steps To Reproduce:
> 1. create table:
> CREATE TABLE WJL21(C1 VARCHAR(65537 CHARS) CHARACTER SET UTF8)
> 2. execute "insert into" sql
> insert into wjl21 values('qwerasd123af#$asfdadf......')
> the length of the values is 65537
> 3. the fail of information is:
> org.trafodion.jdbc.t4.TrafT4Exception: *** ERROR[8402] A string overflow
> occurred during the evaluation of a character expression. [2019-01-21
> 14:09:01]
> at
> org.trafodion.jdbc.t4.TrafT4Messages.throwSQLException(TrafT4Messages.java:211)
> at
> org.trafodion.jdbc.t4.InterfaceStatement.execute(InterfaceStatement.java:1477)
> at
> org.trafodion.jdbc.t4.TrafT4PreparedStatement.execute(TrafT4PreparedStatement.java:2288)
> at
> org.trafodion.jdbc.t4.TrafT4PreparedStatement.executeUpdate64(TrafT4PreparedStatement.java:429)
> at
> org.trafodion.jdbc.t4.TrafT4PreparedStatement.executeUpdate(TrafT4PreparedStatement.java:375)|
--
This message was sent by Atlassian JIRA
(v7.6.3#76005)
