[TRAFODION-3259] When the length of the varchar exceeds 65536, insert into data will fail

• Type: Bug
• Status: Open
• Priority: Major
• Resolution: Unresolved
• Affects Version/s: any
• Component/s: sql-exe
• Assignee: Unassigned
• Reporter: junluwei
• Created: 22/Jan/19 02:11
• Updated: 01/Feb/19 16:34

Description

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)

Issue Links

• links to: GitHub Pull Request #1783