You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@trafodion.apache.org by "junluwei (JIRA)" <ji...@apache.org> on 2019/01/22 02:12:00 UTC
[jira] [Created] (TRAFODION-3259) When the length of the varchar
exceeds 65536, insert into data will fail
junluwei created TRAFODION-3259:
-----------------------------------
Summary: 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
| |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)