java.sql.SQLException: *** ERROR[8402] A string overflow occurred during the evaluation of a character expression. Conversion of Source Type:NCHAR VARYING(REC_NCHAR_V_UNICODE,96000 BYTES,UTF8) Source Value
Affects | Status | Importance | Assigned to | Milestone | |
---|---|---|---|---|---|
Trafodion |
In Progress
|
High
|
Weiqing Xu |
Bug Description
Defect Description:
When insert UCS2 charset with 32K or 200K column length, an error "java.sql.
Test Environment:
codes' version: commit 1c7265ab7addcd0
Test Steps:
Step 1. create a table.
405 sql = "create table tblcolumnsize32
Step 2. insert UCS2 sql text.
409 String a = "";
410 String b = "";
411
412 for (int i = 1; i < 16000; i++) {
413 //a += URLEncoder.
414 //b += URLEncoder.
415 a += new String(
416 b += new String(
417 }
418
419 //a += URLEncoder.
420 //b += URLEncoder.
421 a += new String(
422 b += new String(
423
424 sql = "insert into tblcolumnsize32
425 iRet = stmt.executeUpd
426 assertEquals(1, iRet);
in the step 2, there is an error happened when execute the line 425, here is the console output:
-bash-4.1$ java -Dprop=t2prop TestBigColumnSize
Jun 09, 2015 9:49:58 AM TestBigColumnSize <clinit>
INFO: ============= START ALL TEST CASES =============
---
SLF4J: Class path contains multiple SLF4J bindings.
SLF4J: Found binding in [jar:file:
SLF4J: Found binding in [jar:file:
SLF4J: See http://
SLF4J: Actual binding is of type [org.slf4j.
java.sql.
*** ERROR[8402] A string overflow occurred during the evaluation of a character expression. Conversion of Source Type:NCHAR VARYING(
java.sql.
at org.trafodion.
at org.trafodion.
at TestBigColumnSi
at TestBigColumnSi
---
java.sql.
*** ERROR[8402] A string overflow occurred during the evaluation of a character expression. Conversion of Source Type:NCHAR VARYING(
java.sql.
at org.trafodion.
at org.trafodion.
at TestBigColumnSi
at TestBigColumnSi
Changed in trafodion: | |
milestone: | none → r2.0 |
assignee: | nobody → Weiqing Xu (wei-qing-xu) |
Changed in trafodion: | |
importance: | Undecided → High |
status: | New → Confirmed |
Changed in trafodion: | |
status: | Confirmed → In Progress |