[jira] [Created] (TRAFODION-1096) LP Bug: 1437098 - Create Procedure statement PARAMETER STYLE clause is required

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

Alice Chen created TRAFODION-1096:
-------------------------------------

             Summary: LP Bug: 1437098 - Create Procedure statement PARAMETER STYLE clause is required
                 Key: TRAFODION-1096
                 URL: https://issues.apache.org/jira/browse/TRAFODION-1096
             Project: Apache Trafodion
          Issue Type: Bug
            Reporter: Chong Hsu
            Assignee: Hans Zeller


Testes in Tarfodion v1.1 build 20150320

QA regression test has a testcase checks the Create Procedure statement syntax:

SQL>Create procedure N1300 (in in1 int, inout inout1 int, out out1 largeint)
        external name 'Procs.N1300 (java.lang.Integer,java.lang.Integer[],long[])'
        library spjcall
        language java;

Before build 205030, an error is returned:

*** ERROR[3202] PARAMETER STYLE clause is required. [2015-03-24 14:52:41]

But now this Create Procedure statement returns "operation complete".


See the steps below to produce the result, a JAR file for SPJ procedure is attached.

---------------

create library spjcall file '/home/trafodion/SPJ/test.jar';

SQL>Create procedure N1300 (in in1 int, inout inout1 int, out out1 largeint)
        external name 'Procs.N1300 (java.lang.Integer,java.lang.Integer[],long[])'
        library spjcall
        language java;
--- SQL operation complete.

Note:  An error is returned before build 20150320

*** ERROR[3202] PARAMETER STYLE clause is required. [2015-03-24 14:52:41]

---------------
SPJ java procedure:

  public static void N1300(Integer paramInteger, Integer[] paramArrayOfInteger, long[] paramArrayOfLong)
  {
    paramArrayOfLong[0] = paramArrayOfInteger[0].longValue();
    paramArrayOfInteger[0] = paramInteger;
  }



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