You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@trafodion.apache.org by "Alice Chen (JIRA)" <ji...@apache.org> on 2015/07/22 20:17:17 UTC
[jira] [Created] (TRAFODION-530) LP Bug: 1355033 - SPJ w result set
failed with ERROR[8940]
Alice Chen created TRAFODION-530:
------------------------------------
Summary: LP Bug: 1355033 - SPJ w result set failed with ERROR[8940]
Key: TRAFODION-530
URL: https://issues.apache.org/jira/browse/TRAFODION-530
Project: Apache Trafodion
Issue Type: Bug
Components: sql-exe
Reporter: Chong Hsu
Assignee: Pavani Puppala
Priority: Critical
Fix For: 1.0 (pre-incubation)
Tested with Trafodion build, 20140801-0830.
Calling a SPJ with result set:
public static void RS263(String[] paramArrayOfString, ResultSet[] paramArrayOfResultSet)
throws Exception
{
String str1 = "jdbc:default:connection";
Connection localConnection = DriverManager.getConnection(str1);
Statement localStatement = localConnection.createStatement(1003, 1007);
String str2 = "select st1 from trs";
paramArrayOfResultSet[0] = localStatement.executeQuery(str2);
paramArrayOfResultSet[0].next();
paramArrayOfString[0] = paramArrayOfResultSet[0].getString(1);
}
it failed with ERROR[8940]:
*** ERROR[8940] User-defined function returned invalid data for output value 1. Details: VARCHAR length should not exceed 117. [2014-08-04 22:57:48]
Note: There are other QA test cases failed with same error, all have data with NULL value.
The SPJ Jar file is attached. Here are the steps to produce the error:
set schema testspj;
create library spjrs file '/<Jar location>/Testrs.jar';
create procedure RS263(out out_param varchar(150))
language java
parameter style java
external name 'Testrs.RS263'
dynamic result sets 1
library spjrs;
CREATE TABLE TRS
(
ST1 VARCHAR(117) CHARACTER SET ISO88591
COLLATE DEFAULT DEFAULT _ISO88591'B8YNT80Y'
, ST2 CHAR(105) CHARACTER SET ISO88591 COLLATE
DEFAULT DEFAULT _ISO88591'EA6L0UJH'
, ST3 CHAR(106) CHARACTER SET ISO88591 COLLATE
DEFAULT DEFAULT _ISO88591'DNIF7GJH'
, ST4 CHAR(120) CHARACTER SET ISO88591 COLLATE
DEFAULT DEFAULT _ISO88591'J17RQ4WH'
, ST5 CHAR(113) CHARACTER SET ISO88591 COLLATE
DEFAULT DEFAULT _ISO88591'J8N9E0A2'
, ST6 CHAR(102) CHARACTER SET ISO88591 COLLATE
DEFAULT DEFAULT _ISO88591'4MGI4DH1'
, S0 NUMERIC(9, 2) DEFAULT 22
, S1 DECIMAL(9, 2) DEFAULT 9 NOT NULL NOT
DROPPABLE
)
;
INSERT INTO TrS (s1, St1, St2, St3, St4, St5, St6, s0) VALUES (
708.13,
'-275427.08804271324 192 -817608.8332214953 ',
'WWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWW4M6L0UJH KM6L0UJH 1M6L0UJH 8M6L0UJH WM6L0UJH 2M6L0UJH NM6L0UJH ',
' CMIF7GJH 2MIF7GJH several HMIF7GJH 699141.592691117 923846.5980633064 Emma flew ',
'225 quite a few 437RQ close to sprinted F37RQ 637RQ beneath K37RQ 598498.3059382555 cats lots of P37RQ4WH ',
' 8QN9E 6QN9E GQN9E0A2 EQN9E UQN9E Mike OQN9E0A2 Louise many -985737.648297855 Susan ',
null,
78812.7) ;
INSERT INTO TrS (St2, St6, St4, St1, St3, s0, St5, s1) VALUES (
'D66L0UJH 476L0UJH K76L0UJH 176L0UJH 876L0UJH W76L0UJH 276L0UJH N76L0UJH WWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWW',
' Frank ran excitedly. Michael crawled gracefully! Ben hightailed across quite a few turtles??? ',
'6666666666666666666666ZT7RQ beneath UT7RQ RT7RQ 610827.488916235 quickly -636872.9262176658 mice 3T7RQ WT7RQ ET7RQ4WH ',
null,
' close to lots of string C4IF7 Seals and pigs and snails? Oh My! ',
78814.04,
'3HN9E0A2 across carelessly 2HN9E0A2 BHN9E SHN9E0A2 MHN9E goats ZHN9E0A2 split PHN9E CHN9E ',
2128.55) ;
Call RS263(?);
OUT_PARAM
--------------------------------------------------------------------------------------------------------------------------------
-275427.08804271324 192 -817608.8332214953
*** ERROR[8940] User-defined function returned invalid data for output value 1. Details: VARCHAR length should not exceed 117. [2014-08-04 22:57:48]
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)