You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@trafodion.apache.org by "ASF GitHub Bot (JIRA)" <ji...@apache.org> on 2019/01/29 08:24:00 UTC
[jira] [Work logged] (TRAFODION-3259) When the length of the
varchar exceeds 65536, insert into data will fail
[ https://issues.apache.org/jira/browse/TRAFODION-3259?focusedWorklogId=191523&page=com.atlassian.jira.plugin.system.issuetabpanels:worklog-tabpanel#worklog-191523 ]
ASF GitHub Bot logged work on TRAFODION-3259:
---------------------------------------------
Author: ASF GitHub Bot
Created on: 29/Jan/19 08:23
Start Date: 29/Jan/19 08:23
Worklog Time Spent: 10m
Work Description: zhenxingh commented on pull request #1783: [TRAFODION-3259] Length of varchar exceeds 65536 insert data will fail
URL: https://github.com/apache/trafodion/pull/1783
The precision_ of Attributes class is defined as Int16, this patch
expanded it to 32bit by adding a precision_high_ to hold the higher
16 bits of the precision.
----------------------------------------------------------------
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:
users@infra.apache.org
Issue Time Tracking
-------------------
Worklog Id: (was: 191523)
Time Spent: 10m
Remaining Estimate: 0h
> 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: 10m
> 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)