[jira] [Created] (TRAFODION-529) LP Bug: 1355032 - SPJ with result set failed with ERROR[4011] & ERROR[8804]

["Alice Chen (JIRA)" <ji...@apache.org>]

Alice Chen created TRAFODION-529:
------------------------------------

             Summary: LP Bug: 1355032 - SPJ with result set failed with ERROR[4011] & ERROR[8804]
                 Key: TRAFODION-529
                 URL: https://issues.apache.org/jira/browse/TRAFODION-529
             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 getobject(ResultSet[] paramArrayOfResultSet)
     throws Exception
   {
     String str1 = "jdbc:default:connection";
     String str2 = "select * from t1,t2";
     Connection localConnection = DriverManager.getConnection(str1);
     Statement localStatement = localConnection.createStatement();
     paramArrayOfResultSet[0] = localStatement.executeQuery(str2);
   }

it failed with ERROR[4011]:

*** ERROR[4011] Reference made to column TRAFODION.TESTSPJ.SP_RESULT_SET_1.A via star (*) is ambiguous. [2014-08-08 22:50:35]
*** ERROR[8912] The request to allocate a stored procedure result set failed. An unexpected internal error was encountered. [2014-08-08 22:50:35]

In the same session (from Trafci) after the error, any SPJ calls all failed with error:

*** ERROR[8804] The provided input statement does not exist in the current context. [2014-08-08 22:50:45]
*** ERROR[8804] The provided input statement does not exist in the current context. [2014-08-08 22:50:45]

The SPJ Jar and java file are attached. Here are the steps to produce the error:
  
set schema testspj;

create library spjrs file '/<Jar location>/Testrs.jar';

create procedure RS100()
       language java
       parameter style java
       external name 'Testrs.getobject'
       dynamic result sets 2
      library spjrs;

create table  T1
  (
    A                                INT DEFAULT NULL
  , B                                INT DEFAULT NULL
  ) no partitions; 

create table T2
  (
    A                                CHAR(10) CHARACTER SET ISO88591 COLLATE
      DEFAULT DEFAULT NULL
  , B                                CHAR(10) CHARACTER SET ISO88591 COLLATE
      DEFAULT DEFAULT NULL
  , C                                VARCHAR(10) CHARACTER SET ISO88591 COLLATE
      DEFAULT DEFAULT NULL
  )   no partitions;

call rs100();

*** ERROR[4011] Reference made to column TRAFODION.TESTSPJ.SP_RESULT_SET_1.A via star (*) is ambiguous. [2014-08-08 22:50:35]
*** ERROR[8912] The request to allocate a stored procedure result set failed. An unexpected internal error was encountered. [2014-08-08 22:50:35]

call rs100();

*** ERROR[8804] The provided input statement does not exist in the current context. [2014-08-08 22:50:45]
*** ERROR[8804] The provided input statement does not exist in the current context. [2014-08-08 22:50:45]



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)