db-derby-commits mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From davi...@apache.org
Subject svn commit: r386169 [36/36] - in /db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master: DerbyNet/jdk16/ DerbyNetClient/jdk16/ jdk16/
Date Wed, 15 Mar 2006 21:31:59 GMT
Added: db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/jdk16/procedure.out
URL: http://svn.apache.org/viewcvs/db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/jdk16/procedure.out?rev=386169&view=auto
==============================================================================
--- db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/jdk16/procedure.out (added)
+++ db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/jdk16/procedure.out Wed Mar 15 13:31:53 2006
@@ -0,0 +1,1018 @@
+testNegative
+create procedure asdf() language java external name 'asdfasdf' parameter style java
+EXPECTED SQL Exception: (42Y04) Cannot create a procedure or function with EXTERNAL NAME 'asdfasdf' because it is not a list separated by periods. The expected format is <full java path>.<method name>.
+create procedure asdf() language java external name 'asdfasdf.' parameter style java
+EXPECTED SQL Exception: (42Y04) Cannot create a procedure or function with EXTERNAL NAME 'asdfasdf.' because it is not a list separated by periods. The expected format is <full java path>.<method name>.
+create procedure a23456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789() language java external name 'asdf.asdf' parameter style java
+EXPECTED SQL Exception: (42622) The name 'A23456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789' is too long. The maximum length is '128'.
+create procedure asdf language java external name java.lang.Thread.currentThread parameter style java
+EXPECTED SQL Exception: (42X01) Syntax error: Encountered "language" at line 1, column 23.
+CREATE PROCEDURE ASSEMBLY_PARTS (IN ASSEMBLY_NUM INTEGER, OUT NUM_PARTS INTEGER, OUT COST DOUBLE) EXTERNAL NAME 'parts!assembly' DYNAMIC RESULT SETS 1 LANGUAGE C PARAMETER STYLE GENERAL
+EXPECTED SQL Exception: (42X01) Syntax error: Encountered "C" at line 1, column 161.
+create procedure sys.proc1() language java external name 'java.lang.System.gc' parameter style java
+EXPECTED SQL Exception: (42X62) 'CREATE PROCEDURE' is not allowed in the 'SYS' schema.
+create procedure noclass() language java external name 'asdf.asdf' parameter style java language java
+EXPECTED SQL Exception: (42613) Multiple or conflicting keywords involving the 'LANGUAGE' clause are present.
+create procedure noclass() parameter style java language java external name 'asdf.asdf' parameter style java
+EXPECTED SQL Exception: (42613) Multiple or conflicting keywords involving the 'PARAMETER STYLE' clause are present.
+create procedure noclass() external name 'asdf.xxxx' language java external name 'asdf.asdf' parameter style java
+EXPECTED SQL Exception: (42613) Multiple or conflicting keywords involving the 'EXTERNAL NAME' clause are present.
+create procedure noclass() parameter style java language java external name 'asdf.asdf' parameter style derby_rs_collection
+EXPECTED SQL Exception: (42X01) Syntax error: Encountered "derby_rs_collection" at line 1, column 105.
+create procedure missing01()
+EXPECTED SQL Exception: (42X01) Syntax error: Encountered "<EOF>" at line 1, column 28.
+create procedure missing02() language java
+EXPECTED SQL Exception: (42X01) Syntax error: EXTERNAL NAME.
+create procedure missing03() language java parameter style java
+EXPECTED SQL Exception: (42X01) Syntax error: EXTERNAL NAME.
+create procedure missing04() language java external name 'foo.bar'
+EXPECTED SQL Exception: (42X01) Syntax error: PARAMETER STYLE.
+create procedure missing05() parameter style java
+EXPECTED SQL Exception: (42X01) Syntax error: LANGUAGE.
+create procedure missing06() parameter style java external name 'foo.bar'
+EXPECTED SQL Exception: (42X01) Syntax error: LANGUAGE.
+create procedure missing07() external name 'goo.bar'
+EXPECTED SQL Exception: (42X01) Syntax error: LANGUAGE.
+create procedure missing08() dynamic result sets 1
+EXPECTED SQL Exception: (42X01) Syntax error: LANGUAGE.
+create procedure nullinput2() returns null on null input language java parameter style java external name 'foo.bar'
+EXPECTED SQL Exception: (42X01) Syntax error: RETURNS NULL ON NULL INPUT.
+create procedure NO_BLOB(IN P1 BLOB(3k)) language java parameter style java external name 'no.blob'
+EXPECTED SQL Exception: (42962) Long column type column or parameter 'P1' not permitted in declared global temporary tables or procedure definitions. 
+create procedure NO_CLOB(IN P1 CLOB(3k)) language java parameter style java external name 'no.clob'
+EXPECTED SQL Exception: (42962) Long column type column or parameter 'P1' not permitted in declared global temporary tables or procedure definitions. 
+create procedure NO_LVC(IN P1 LONG VARCHAR) language java parameter style java external name 'no.lvc'
+EXPECTED SQL Exception: (42962) Long column type column or parameter 'P1' not permitted in declared global temporary tables or procedure definitions. 
+create procedure DUP_P1(IN FRED INT, OUT RON CHAR(10), IN FRED INT) language java parameter style java external name 'no.dup1'
+EXPECTED SQL Exception: (42734) Name 'FRED' specified in context 'DUP_P1' is not unique.
+create procedure D2.DUP_P2(IN "FreD" INT, OUT RON CHAR(10), IN "FreD" INT) language java parameter style java external name 'no.dup2'
+EXPECTED SQL Exception: (42734) Name 'FreD' specified in context 'D2.DUP_P2' is not unique.
+create procedure D3.DUP_P3(IN "FRED" INT, OUT RON CHAR(10), IN fred INT) language java parameter style java external name 'no.dup3'
+EXPECTED SQL Exception: (42734) Name 'FRED' specified in context 'D3.DUP_P3' is not unique.
+CALL APP.NSP(?, ?)
+EXPECTED SQL Exception: (42Y03) 'APP.NSP' is not recognized as a function or procedure.
+call syscs_util.syscs_set_database_property("foo", "bar")
+EXPECTED SQL Exception: (42X15) Column name 'foo' appears in a statement without a FROM list.
+signature mismatched types
+CALL APP.SIGNATURE_BUG_DERBY_258_A(4)
+EXPECTED SQL Exception: (22005) An attempt was made to get a data value of type 'java.lang.String' from a data value of type 'INTEGER'.
+signature too many parameters
+VALUES APP.SIGNATURE_BUG_DERBY_258_B(4)
+EXPECTED SQL Exception: (46J02) Java method signature contains incorrect number (2) of parameters, expected 1.
+signature too few parameters
+CALL APP.SIGNATURE_BUG_DERBY_258_C(4)
+EXPECTED SQL Exception: (46J02) Java method signature contains incorrect number (0) of parameters, expected 1.
+signature invalid format
+CALL APP.SIGNATURE_BUG_DERBY_258_F(4)
+EXPECTED SQL Exception: (46J01) Java method signature has invalid format.
+signature invalid format
+CALL APP.SIGNATURE_BUG_DERBY_258_G(4)
+EXPECTED SQL Exception: (46J01) Java method signature has invalid format.
+signature invalid format
+CALL APP.SIGNATURE_BUG_DERBY_258_H(4)
+EXPECTED SQL Exception: (46J01) Java method signature has invalid format.
+signature invalid format
+CALL APP.SIGNATURE_BUG_DERBY_258_I(4)
+EXPECTED SQL Exception: (46J01) Java method signature has invalid format.
+testDelayedClassChecking
+call noclass()
+EXPECTED SQL Exception: (42X51) The class 'asdf' does not exist or is inaccessible. This can happen if the class is not public.
+call nomethod()
+EXPECTED SQL Exception: (42X50) No method was found that matched the method call java.lang.Integer.asdf(), tried all combinations of object and primitive types and any possible type conversion for any  parameters the method call may have. The method might exist but it is not public and/or static, or the parameter types are not method invocation convertible.
+call notstatic()
+EXPECTED SQL Exception: (42X50) No method was found that matched the method call java.lang.Integer.equals(), tried all combinations of object and primitive types and any possible type conversion for any  parameters the method call may have. The method might exist but it is not public and/or static, or the parameter types are not method invocation convertible.
+call notvoid()
+EXPECTED SQL Exception: (42X50) No method was found that matched the method call void java.lang.Runtime.getRuntime(), tried all combinations of object and primitive types and any possible type conversion for any  parameters the method call may have. The method might exist but it is not public and/or static, or the parameter types are not method invocation convertible.
+testDuplicates
+create procedure PROCDUP() language java external name 'failAPP.fail0' parameter style java
+EXPECTED SQL Exception: (X0Y68) PROCEDURE 'PROCDUP' already exists.
+create procedure s1.PROCDUP() language java external name 'fails1.fail0' parameter style java
+EXPECTED SQL Exception: (X0Y68) PROCEDURE 'PROCDUP' already exists.
+create procedure s2.PROCDUP() language java external name 'fails2.fail0' parameter style java
+EXPECTED SQL Exception: (X0Y68) PROCEDURE 'PROCDUP' already exists.
+DEFINED PROCEDURES FOR PROCDUP
+  APP.PROCDUP AS okAPP.ok0() LANGUAGE JAVA PARAMETER STYLE JAVA MODIFIES SQL DATA
+  S1.PROCDUP AS oks1.ok0() LANGUAGE JAVA PARAMETER STYLE JAVA MODIFIES SQL DATA
+  S2.PROCDUP AS oks2.ok0() LANGUAGE JAVA PARAMETER STYLE JAVA MODIFIES SQL DATA
+DATABASE METATDATA PROCEDURES FOR PROCDUP
+  APP.PROCDUP AS okAPP.ok0 type procedureNoResult
+  S1.PROCDUP AS oks1.ok0 type procedureNoResult
+  S2.PROCDUP AS oks2.ok0 type procedureNoResult
+------------
+create procedure S1.NOTYET() SPECIFIC fred language java external name 'failAPP.fail0' parameter style java
+EXPECTED SQL Exception: (0A000) Feature not implemented: SPECIFIC identifier.
+ambigiousMethods
+call AMBIGIOUS01(?, ?)
+EXPECTED SQL Exception: (42X73) Method resolution for signature org.apache.derbyTesting.functionTests.util.ProcedureTest.ambigious1(int, java.lang.String, [Ljava.sql.ResultSet;) was ambiguous. (No single maximally specific method.)
+call AMBIGIOUS02(?, ?)
+EXPECTED SQL Exception: (42X50) No method was found that matched the method call org.apache.derbyTesting.functionTests.util.ProcedureTest.ambigious2(int, int, java.sql.ResultSet[]), tried all combinations of object and primitive types and any possible type conversion for any  parameters the method call may have. The method might exist but it is not public and/or static, or the parameter types are not method invocation convertible.
+ambigious2(int,Integer) called
+UPDATE COUNT 0
+ambigious2(Integer,int) called
+UPDATE COUNT 0
+zeroArgProcedures
+zeroArg() called
+UPDATE COUNT 0
+zeroArg() called
+UPDATE COUNT 0
+zeroArg() called
+UPDATE COUNT 0
+EXPECTED SQL Exception: 'ZA' is not recognized as a function or procedure.
+zeroArg() called
+UPDATE COUNT 0
+zeroArg() called
+UPDATE COUNT 0
+DEFINED PROCEDURES FOR ZA
+  APP.ZA AS org.apache.derbyTesting.functionTests.util.ProcedureTest.zeroArg() LANGUAGE JAVA PARAMETER STYLE JAVA MODIFIES SQL DATA
+DATABASE METATDATA PROCEDURES FOR ZA
+  APP.ZA AS org.apache.derbyTesting.functionTests.util.ProcedureTest.zeroArg type procedureNoResult
+------------
+DEFINED PROCEDURES FOR ZA
+DATABASE METATDATA PROCEDURES FOR ZA
+------------
+sqlProcedures()
+DEFINED PROCEDURES FOR IR%
+  APP.IR AS org.apache.derbyTesting.functionTests.util.ProcedureTest.insertRow(IN P1 INTEGER) LANGUAGE JAVA PARAMETER STYLE JAVA MODIFIES SQL DATA
+  APP.IR2 AS org.apache.derbyTesting.functionTests.util.ProcedureTest.insertRow(IN P1 INTEGER,IN P2 CHAR(10)) LANGUAGE JAVA PARAMETER STYLE JAVA MODIFIES SQL DATA
+DATABASE METATDATA PROCEDURES FOR IR%
+  APP.IR AS org.apache.derbyTesting.functionTests.util.ProcedureTest.insertRow type procedureNoResult
+    procedureColumnIn P1 INTEGER
+  APP.IR2 AS org.apache.derbyTesting.functionTests.util.ProcedureTest.insertRow type procedureNoResult
+    procedureColumnIn P1 INTEGER
+    procedureColumnIn P2 CHAR
+------------
+CALL IR()
+EXPECTED SQL Exception: (42Y03) 'IR' is not recognized as a function or procedure.
+UPDATE COUNT 0
+UPDATE COUNT 0
+EXPECTED SQL Exception: The exception 'java.sql.SQLIntegrityConstraintViolationException: The statement was aborted because it would have caused a duplicate key value in a unique or primary key constraint or unique index identified by 'xxxxGENERATED-IDxxxx' defined on 'T1'.' was thrown while evaluating an expression.
+UPDATE COUNT 0
+UPDATE COUNT 0
+UPDATE COUNT 0
+UPDATE COUNT 0
+UPDATE COUNT 0
+I          |B              
+---------------------------
+1          |int            
+2          |int            
+3          |int            
+7          |int            
+4          |4              
+5          |ir2            
+6          |'012345678     
+CALL IR2(2, 'no way')
+EXPECTED SQL Exception: (38000) The exception 'java.sql.SQLIntegrityConstraintViolationException: The statement was aborted because it would have caused a duplicate key value in a unique or primary key constraint or unique index identified by 'xxxxGENERATED-IDxxxx' defined on 'T1'.' was thrown while evaluating an expression.
+CALL IR2(?, 'no way')
+EXPECTED SQL Exception: (07000) At least one parameter to the current statement is uninitialized.
+CALL IR2(2, ?)
+EXPECTED SQL Exception: (07000) At least one parameter to the current statement is uninitialized.
+dynamicResultSets - parameter style JAVA
+create procedure DRS(p1 int) parameter style JAVA READS SQL DATA dynamic result sets -1 language java external name 'org.apache.derbyTesting.functionTests.util.ProcedureTest.selectRows'
+EXPECTED SQL Exception: (42X01) Syntax error: Encountered "-" at line 1, column 86.
+DEFINED PROCEDURES FOR DRS
+  APP.DRS AS org.apache.derbyTesting.functionTests.util.ProcedureTest.selectRows(IN P1 INTEGER) LANGUAGE JAVA PARAMETER STYLE JAVA READS SQL DATA DYNAMIC RESULT SETS 1
+DATABASE METATDATA PROCEDURES FOR DRS
+  APP.DRS AS org.apache.derbyTesting.functionTests.util.ProcedureTest.selectRows type procedureNoResult
+    procedureColumnIn P1 INTEGER
+------------
+CALL DRS()
+EXPECTED SQL Exception: (42Y03) 'DRS' is not recognized as a function or procedure.
+CALL DRS(?,?)
+EXPECTED SQL Exception: (42Y03) 'DRS' is not recognized as a function or procedure.
+selectRows - 1 arg - 1 rs
+I          |B              
+---------------------------
+3          |int            
+DEFINED PROCEDURES FOR DRS2
+  APP.DRS2 AS org.apache.derbyTesting.functionTests.util.ProcedureTest.selectRows(IN P1 INTEGER,IN P2 INTEGER) LANGUAGE JAVA PARAMETER STYLE JAVA READS SQL DATA DYNAMIC RESULT SETS 2
+DATABASE METATDATA PROCEDURES FOR DRS2
+  APP.DRS2 AS org.apache.derbyTesting.functionTests.util.ProcedureTest.selectRows type procedureNoResult
+    procedureColumnIn P1 INTEGER
+    procedureColumnIn P2 INTEGER
+------------
+selectRows - 2 arg - 2 rs
+I          |B              
+---------------------------
+2          |int            
+I          |B              
+---------------------------
+6          |'012345678     
+7          |int            
+selectRows - 2 arg - 2 rs
+I          |B              
+---------------------------
+2          |int            
+selectRows - 2 arg - 2 rs
+UPDATE COUNT 0
+selectRows - 2 arg - 2 rs
+I          |B              
+---------------------------
+2          |int            
+I          |B              
+---------------------------
+selectRows - 2 arg - 2 rs
+pass 1 got result set true
+EXPECTED : ResultSet not open. Operation 'next' not permitted. Verify that autocommit is OFF.
+pass 2 got result set true
+EXPECTED : ResultSet not open. Operation 'next' not permitted. Verify that autocommit is OFF.
+pass 3 got result set false
+auto commit is true
+lock count before execution 0
+selectRows - 2 arg - 2 rs
+lock count after execution 1
+lock count after next on first rs 3
+Is there a second result ? true
+lock count after first getMoreResults() 2
+lock count after next on second rs 7
+more results (should be false) false
+lock count after second getMoreResults() 0
+auto commit is false
+lock count before execution 0
+selectRows - 2 arg - 2 rs
+lock count after execution 1
+lock count after next on first rs 3
+Is there a second result ? true
+lock count after first getMoreResults() 2
+lock count after next on second rs 7
+more results (should be false) false
+lock count after second getMoreResults() 7
+auto commit is true
+lock count before execution 0
+selectRows - 2 arg - 2 rs
+lock count after execution 1
+lock count after next on first rs 3
+executing statement to force auto commit on open CALL statement
+lock count after statement execution 0
+Expected - ResultSet not open. Operation 'next' not permitted. Verify that autocommit is OFF.
+Is there a second result ? true
+lock count after first getMoreResults() 0
+Expected - ResultSet not open. Operation 'next' not permitted. Verify that autocommit is OFF.
+lock count after next on second rs 0
+more results (should be false) false
+lock count after second getMoreResults() 0
+selectRows - 2 arg - 2 rs
+I          |B              
+---------------------------
+2          |int            
+I          |B              
+---------------------------
+6          |'012345678     
+7          |int            
+CALL IRDRS(?)
+EXPECTED SQL Exception: (42X50) No method was found that matched the method call org.apache.derbyTesting.functionTests.util.ProcedureTest.missingDynamicParameter(int, java.sql.ResultSet[]), tried all combinations of object and primitive types and any possible type conversion for any  parameters the method call may have. The method might exist but it is not public and/or static, or the parameter types are not method invocation convertible.
+CALL rsi(?)
+EXPECTED SQL Exception: (42X50) No method was found that matched the method call org.apache.derbyTesting.functionTests.util.ProcedureTest.badDynamicParameter(int, java.sql.ResultSet[]), tried all combinations of object and primitive types and any possible type conversion for any  parameters the method call may have. The method might exist but it is not public and/or static, or the parameter types are not method invocation convertible.
+no dynamic result sets
+zeroArgDynamicResult called
+UPDATE COUNT 0
+Testing too many result sets
+... too many result sets
+selectRows - 2 arg - 2 rs
+WARNING 0100E: XX Attempt to return too many result sets. 
+I          |B              
+---------------------------
+2          |int            
+... one additional closed result set
+selectRows - 2 arg - 2 rs
+I          |B              
+---------------------------
+2          |int            
+Stored Procedure w/ CLOB in result set.
+C                             
+------------------------------
+yayorsomething                
+yayorsomething2               
+1          
+-----------
+2          
+C                             
+------------------------------
+yayorsomething                
+yayorsomething2               
+Stored Procedure w/ BLOB in result set.
+B                                                           
+------------------------------------------------------------
+003100300031003000310030003000300031003100300031            
+003100300031003000310030003000300031003100300031            
+parameterTypes
+DEFINED PROCEDURES FOR PT1
+  APP.PT1 AS org.apache.derbyTesting.functionTests.util.ProcedureTest.parameter1(IN A INTEGER,IN B CHAR(10),IN C VARCHAR(20)) LANGUAGE JAVA PARAMETER STYLE JAVA MODIFIES SQL DATA DYNAMIC RESULT SETS 1
+DATABASE METATDATA PROCEDURES FOR PT1
+  APP.PT1 AS org.apache.derbyTesting.functionTests.util.ProcedureTest.parameter1 type procedureNoResult
+    procedureColumnIn A INTEGER
+    procedureColumnIn B CHAR
+    procedureColumnIn C VARCHAR
+------------
+PT1 a=20 b=<abc       >(10) c=<efgh>(4)
+A          |B         |3          |C                   |5          
+-------------------------------------------------------------------
+20         |abc       |10         |efgh                |4          
+PT1 a=30 b=<abc       >(10) c=<efgh  >(6)
+A          |B         |3          |C                   |5          
+-------------------------------------------------------------------
+30         |abc       |10         |efgh                |6          
+PT1 a=40 b=<abc       >(10) c=<efgh                >(20)
+A          |B         |3          |C                   |5          
+-------------------------------------------------------------------
+40         |abc       |10         |efgh                |20         
+PT1 a=50 b=<0123456789>(10) c=<efgh  >(6)
+A          |B         |3          |C                   |5          
+-------------------------------------------------------------------
+50         |0123456789|10         |efgh                |6          
+DEFINED PROCEDURES FOR PT2
+  APP.PT2 AS org.apache.derbyTesting.functionTests.util.ProcedureTest.parameter2(IN A INTEGER,IN B DECIMAL(4,0),IN C DECIMAL(7,3)) LANGUAGE JAVA PARAMETER STYLE JAVA MODIFIES SQL DATA DYNAMIC RESULT SETS 1
+DATABASE METATDATA PROCEDURES FOR PT2
+  APP.PT2 AS org.apache.derbyTesting.functionTests.util.ProcedureTest.parameter2 type procedureNoResult
+    procedureColumnIn A INTEGER
+    procedureColumnIn B DECIMAL
+    procedureColumnIn C DECIMAL
+------------
+A          |B         |C                   
+-------------------------------------------
+60         |34        |54.100              
+A          |B         |C                   
+-------------------------------------------
+70         |831       |45.700              
+EXPECTED SQL Exception: The resulting value is outside the range for the data type DECIMAL/NUMERIC(4,0).
+A          |B         |C                   
+-------------------------------------------
+80         |993       |1234.567            
+DEFINED PROCEDURES FOR PTSMALLINT%
+  APP.PTSMALLINT2 AS org.apache.derbyTesting.functionTests.util.ProcedureTest.pSMALLINT(IN P_IN SMALLINT,INOUT P_INOUT SMALLINT,OUT P_OUT SMALLINT) LANGUAGE JAVA PARAMETER STYLE JAVA NO SQL
+DATABASE METATDATA PROCEDURES FOR PTSMALLINT%
+  APP.PTSMALLINT2 AS org.apache.derbyTesting.functionTests.util.ProcedureTest.pSMALLINT type procedureNoResult
+    procedureColumnIn P_IN SMALLINT
+    procedureColumnInOut P_INOUT SMALLINT
+    procedureColumnOut P_OUT SMALLINT
+------------
+EXPECTED SQL Exception: (39004) A NULL value cannot be passed to a method which takes a parameter of primitive type 'short'.
+EXPECTED SQL Exception: (39004) A NULL value cannot be passed to a method which takes a parameter of primitive type 'short'.
+p_inout 9 p_out 6
+p_inout 9 null?false p_out 6 null?false
+p_inout 9 null?false p_out 6 null?false
+outparams
+DEFINED PROCEDURES FOR OP1
+  APP.OP1 AS org.apache.derbyTesting.functionTests.util.ProcedureTest.outparams1(OUT A INTEGER,IN B INTEGER) LANGUAGE JAVA PARAMETER STYLE JAVA MODIFIES SQL DATA
+DATABASE METATDATA PROCEDURES FOR OP1
+  APP.OP1 AS org.apache.derbyTesting.functionTests.util.ProcedureTest.outparams1 type procedureNoResult
+    procedureColumnOut A INTEGER
+    procedureColumnIn B INTEGER
+------------
+EXPECTED SQL Exception: Use of CallableStatement required for stored procedure call or use of output parameters: CALL OP1(?, ?)
+EXPECTED SQL Exception: Use of CallableStatement required for stored procedure call or use of output parameters: CALL OP1(?, ?)
+UPDATE COUNT 0
+OP1 14 null ? false
+DEFINED PROCEDURES FOR OP2
+  APP.OP2 AS org.apache.derbyTesting.functionTests.util.ProcedureTest.inoutparams2(INOUT A INTEGER,IN B INTEGER) LANGUAGE JAVA PARAMETER STYLE JAVA MODIFIES SQL DATA
+DATABASE METATDATA PROCEDURES FOR OP2
+  APP.OP2 AS org.apache.derbyTesting.functionTests.util.ProcedureTest.inoutparams2 type procedureNoResult
+    procedureColumnInOut A INTEGER
+    procedureColumnIn B INTEGER
+------------
+EXPECTED SQL Exception: Use of CallableStatement required for stored procedure call or use of output parameters: CALL OP2(?, ?)
+EXPECTED SQL Exception: Use of CallableStatement required for stored procedure call or use of output parameters: CALL OP2(?, ?)
+UPDATE COUNT 0
+OP2 17 null ? false
+DEFINED PROCEDURES FOR OP3
+  APP.OP3 AS org.apache.derbyTesting.functionTests.util.ProcedureTest.inoutparams3(INOUT A CHAR(10),IN B INTEGER) LANGUAGE JAVA PARAMETER STYLE JAVA MODIFIES SQL DATA
+DATABASE METATDATA PROCEDURES FOR OP3
+  APP.OP3 AS org.apache.derbyTesting.functionTests.util.ProcedureTest.inoutparams3 type procedureNoResult
+    procedureColumnInOut A CHAR
+    procedureColumnIn B INTEGER
+------------
+p1= >dan       < length 10
+UPDATE COUNT 0
+OP3 >nad       < null ? false
+DEFINED PROCEDURES FOR OP4
+  APP.OP4 AS org.apache.derbyTesting.functionTests.util.ProcedureTest.inoutparams4(OUT A DECIMAL(4,2),IN B VARCHAR(255)) LANGUAGE JAVA PARAMETER STYLE JAVA MODIFIES SQL DATA
+DATABASE METATDATA PROCEDURES FOR OP4
+  APP.OP4 AS org.apache.derbyTesting.functionTests.util.ProcedureTest.inoutparams4 type procedureNoResult
+    procedureColumnOut A DECIMAL
+    procedureColumnIn B VARCHAR
+------------
+UPDATE COUNT 0
+OP4 null >null< null ? true
+UPDATE COUNT 0
+OP4 14 >31.00< null ? false
+UPDATE COUNT 0
+OP4 11.3 >28.30< null ? false
+UPDATE COUNT 0
+OP4 39.345 >56.34< null ? false
+EXPECTED SQL Exception: The resulting value is outside the range for the data type DECIMAL/NUMERIC(4,2).
+EXPECTED SQL Exception: At least one parameter to the current statement is uninitialized.
+EXPECTED SQL Exception: Return output parameters cannot be set.
+EXPECTED SQL Exception: Return output parameters cannot be set.
+EXPECTED SQL Exception: Return output parameters cannot be set.
+UPDATE COUNT 0
+OP4 49.345 >66.34< null ? false
+EXPECTED SQL Exception: Parameter 2 is not an output parameter.
+EXPECTED SQL Exception: (07004) Parameter 1 is an OUT procedure parameter and must be registered with CallableStatement.registerOutParameter before execution.
+DEFINED PROCEDURES FOR OP4INOUT
+  APP.OP4INOUT AS org.apache.derbyTesting.functionTests.util.ProcedureTest.inoutparams4(INOUT A DECIMAL(4,2),IN B VARCHAR(255)) LANGUAGE JAVA PARAMETER STYLE JAVA MODIFIES SQL DATA
+DATABASE METATDATA PROCEDURES FOR OP4INOUT
+  APP.OP4INOUT AS org.apache.derbyTesting.functionTests.util.ProcedureTest.inoutparams4 type procedureNoResult
+    procedureColumnInOut A DECIMAL
+    procedureColumnIn B VARCHAR
+------------
+UPDATE COUNT 0
+OP4INOUT null >null< null ? true
+UPDATE COUNT 0
+OP4INOUT null(2) >null< null ? true
+UPDATE COUNT 0
+OP4INOUT 14+23.5 >37.50< null ? false
+UPDATE COUNT 0
+OP4INOUT 9+23.505 >32.50< null ? false
+UPDATE COUNT 0
+OP4INOUT 32.50+23.505 >56.00< null ? false
+EXPECTED SQL Exception: The resulting value is outside the range for the data type DECIMAL/NUMERIC(4,2).
+EXPECTED SQL Exception: The resulting value is outside the range for the data type DECIMAL/NUMERIC(4,2).
+EXPECTED SQL Exception: At least one parameter to the current statement is uninitialized.
+EXPECTED SQL Exception: At least one parameter to the current statement is uninitialized.
+EXPECTED SQL Exception: (07000) At least one parameter to the current statement is uninitialized.
+EXPECTED SQL Exception: (07004) Parameter 1 is an INOUT procedure parameter and must be registered with CallableStatement.registerOutParameter before execution.
+SQL Control
+CREATE PROCEDURE SQLC.SQLCONTROL1_0 (OUT E1 VARCHAR(128), OUT E2 VARCHAR(128), OUT E3 VARCHAR(128), OUT E4 VARCHAR(128), OUT E5 VARCHAR(128), OUT E6 VARCHAR(128), OUT E7 VARCHAR(128))  PARAMETER STYLE JAVA LANGUAGE JAVA EXTERNAL NAME 'org.apache.derbyTesting.functionTests.util.ProcedureTest.sqlControl'
+CREATE PROCEDURE SQLC.SQLCONTROL2_0 (OUT E1 VARCHAR(128), OUT E2 VARCHAR(128), OUT E3 VARCHAR(128), OUT E4 VARCHAR(128), OUT E5 VARCHAR(128), OUT E6 VARCHAR(128), OUT E7 VARCHAR(128))  PARAMETER STYLE JAVA LANGUAGE JAVA EXTERNAL NAME 'org.apache.derbyTesting.functionTests.util.ProcedureTest.sqlControl2'
+CREATE PROCEDURE SQLC.SQLCONTROL3_0 (OUT E1 VARCHAR(128), OUT E2 VARCHAR(128), OUT E3 VARCHAR(128), OUT E4 VARCHAR(128), OUT E5 VARCHAR(128), OUT E6 VARCHAR(128), OUT E7 VARCHAR(128))  PARAMETER STYLE JAVA LANGUAGE JAVA EXTERNAL NAME 'org.apache.derbyTesting.functionTests.util.ProcedureTest.sqlControl3'
+CREATE PROCEDURE SQLC.SQLCONTROL4_0 (IN SQLC INTEGER, OUT E1 VARCHAR(128), OUT E2 VARCHAR(128), OUT E3 VARCHAR(128), OUT E4 VARCHAR(128), OUT E5 VARCHAR(128), OUT E6 VARCHAR(128), OUT E7 VARCHAR(128), OUT E8 VARCHAR(128))  PARAMETER STYLE JAVA LANGUAGE JAVA EXTERNAL NAME 'org.apache.derbyTesting.functionTests.util.ProcedureTest.sqlControl4'
+CREATE PROCEDURE SQLC.SQLCONTROL1_1 (OUT E1 VARCHAR(128), OUT E2 VARCHAR(128), OUT E3 VARCHAR(128), OUT E4 VARCHAR(128), OUT E5 VARCHAR(128), OUT E6 VARCHAR(128), OUT E7 VARCHAR(128)) NO SQL PARAMETER STYLE JAVA LANGUAGE JAVA EXTERNAL NAME 'org.apache.derbyTesting.functionTests.util.ProcedureTest.sqlControl'
+CREATE PROCEDURE SQLC.SQLCONTROL2_1 (OUT E1 VARCHAR(128), OUT E2 VARCHAR(128), OUT E3 VARCHAR(128), OUT E4 VARCHAR(128), OUT E5 VARCHAR(128), OUT E6 VARCHAR(128), OUT E7 VARCHAR(128)) NO SQL PARAMETER STYLE JAVA LANGUAGE JAVA EXTERNAL NAME 'org.apache.derbyTesting.functionTests.util.ProcedureTest.sqlControl2'
+CREATE PROCEDURE SQLC.SQLCONTROL3_1 (OUT E1 VARCHAR(128), OUT E2 VARCHAR(128), OUT E3 VARCHAR(128), OUT E4 VARCHAR(128), OUT E5 VARCHAR(128), OUT E6 VARCHAR(128), OUT E7 VARCHAR(128)) NO SQL PARAMETER STYLE JAVA LANGUAGE JAVA EXTERNAL NAME 'org.apache.derbyTesting.functionTests.util.ProcedureTest.sqlControl3'
+CREATE PROCEDURE SQLC.SQLCONTROL4_1 (IN SQLC INTEGER, OUT E1 VARCHAR(128), OUT E2 VARCHAR(128), OUT E3 VARCHAR(128), OUT E4 VARCHAR(128), OUT E5 VARCHAR(128), OUT E6 VARCHAR(128), OUT E7 VARCHAR(128), OUT E8 VARCHAR(128)) NO SQL PARAMETER STYLE JAVA LANGUAGE JAVA EXTERNAL NAME 'org.apache.derbyTesting.functionTests.util.ProcedureTest.sqlControl4'
+CREATE PROCEDURE SQLC.SQLCONTROL1_2 (OUT E1 VARCHAR(128), OUT E2 VARCHAR(128), OUT E3 VARCHAR(128), OUT E4 VARCHAR(128), OUT E5 VARCHAR(128), OUT E6 VARCHAR(128), OUT E7 VARCHAR(128)) CONTAINS SQL PARAMETER STYLE JAVA LANGUAGE JAVA EXTERNAL NAME 'org.apache.derbyTesting.functionTests.util.ProcedureTest.sqlControl'
+CREATE PROCEDURE SQLC.SQLCONTROL2_2 (OUT E1 VARCHAR(128), OUT E2 VARCHAR(128), OUT E3 VARCHAR(128), OUT E4 VARCHAR(128), OUT E5 VARCHAR(128), OUT E6 VARCHAR(128), OUT E7 VARCHAR(128)) CONTAINS SQL PARAMETER STYLE JAVA LANGUAGE JAVA EXTERNAL NAME 'org.apache.derbyTesting.functionTests.util.ProcedureTest.sqlControl2'
+CREATE PROCEDURE SQLC.SQLCONTROL3_2 (OUT E1 VARCHAR(128), OUT E2 VARCHAR(128), OUT E3 VARCHAR(128), OUT E4 VARCHAR(128), OUT E5 VARCHAR(128), OUT E6 VARCHAR(128), OUT E7 VARCHAR(128)) CONTAINS SQL PARAMETER STYLE JAVA LANGUAGE JAVA EXTERNAL NAME 'org.apache.derbyTesting.functionTests.util.ProcedureTest.sqlControl3'
+CREATE PROCEDURE SQLC.SQLCONTROL4_2 (IN SQLC INTEGER, OUT E1 VARCHAR(128), OUT E2 VARCHAR(128), OUT E3 VARCHAR(128), OUT E4 VARCHAR(128), OUT E5 VARCHAR(128), OUT E6 VARCHAR(128), OUT E7 VARCHAR(128), OUT E8 VARCHAR(128)) CONTAINS SQL PARAMETER STYLE JAVA LANGUAGE JAVA EXTERNAL NAME 'org.apache.derbyTesting.functionTests.util.ProcedureTest.sqlControl4'
+CREATE PROCEDURE SQLC.SQLCONTROL1_3 (OUT E1 VARCHAR(128), OUT E2 VARCHAR(128), OUT E3 VARCHAR(128), OUT E4 VARCHAR(128), OUT E5 VARCHAR(128), OUT E6 VARCHAR(128), OUT E7 VARCHAR(128)) READS SQL DATA PARAMETER STYLE JAVA LANGUAGE JAVA EXTERNAL NAME 'org.apache.derbyTesting.functionTests.util.ProcedureTest.sqlControl'
+CREATE PROCEDURE SQLC.SQLCONTROL2_3 (OUT E1 VARCHAR(128), OUT E2 VARCHAR(128), OUT E3 VARCHAR(128), OUT E4 VARCHAR(128), OUT E5 VARCHAR(128), OUT E6 VARCHAR(128), OUT E7 VARCHAR(128)) READS SQL DATA PARAMETER STYLE JAVA LANGUAGE JAVA EXTERNAL NAME 'org.apache.derbyTesting.functionTests.util.ProcedureTest.sqlControl2'
+CREATE PROCEDURE SQLC.SQLCONTROL3_3 (OUT E1 VARCHAR(128), OUT E2 VARCHAR(128), OUT E3 VARCHAR(128), OUT E4 VARCHAR(128), OUT E5 VARCHAR(128), OUT E6 VARCHAR(128), OUT E7 VARCHAR(128)) READS SQL DATA PARAMETER STYLE JAVA LANGUAGE JAVA EXTERNAL NAME 'org.apache.derbyTesting.functionTests.util.ProcedureTest.sqlControl3'
+CREATE PROCEDURE SQLC.SQLCONTROL4_3 (IN SQLC INTEGER, OUT E1 VARCHAR(128), OUT E2 VARCHAR(128), OUT E3 VARCHAR(128), OUT E4 VARCHAR(128), OUT E5 VARCHAR(128), OUT E6 VARCHAR(128), OUT E7 VARCHAR(128), OUT E8 VARCHAR(128)) READS SQL DATA PARAMETER STYLE JAVA LANGUAGE JAVA EXTERNAL NAME 'org.apache.derbyTesting.functionTests.util.ProcedureTest.sqlControl4'
+CREATE PROCEDURE SQLC.SQLCONTROL1_4 (OUT E1 VARCHAR(128), OUT E2 VARCHAR(128), OUT E3 VARCHAR(128), OUT E4 VARCHAR(128), OUT E5 VARCHAR(128), OUT E6 VARCHAR(128), OUT E7 VARCHAR(128)) MODIFIES SQL DATA PARAMETER STYLE JAVA LANGUAGE JAVA EXTERNAL NAME 'org.apache.derbyTesting.functionTests.util.ProcedureTest.sqlControl'
+CREATE PROCEDURE SQLC.SQLCONTROL2_4 (OUT E1 VARCHAR(128), OUT E2 VARCHAR(128), OUT E3 VARCHAR(128), OUT E4 VARCHAR(128), OUT E5 VARCHAR(128), OUT E6 VARCHAR(128), OUT E7 VARCHAR(128)) MODIFIES SQL DATA PARAMETER STYLE JAVA LANGUAGE JAVA EXTERNAL NAME 'org.apache.derbyTesting.functionTests.util.ProcedureTest.sqlControl2'
+CREATE PROCEDURE SQLC.SQLCONTROL3_4 (OUT E1 VARCHAR(128), OUT E2 VARCHAR(128), OUT E3 VARCHAR(128), OUT E4 VARCHAR(128), OUT E5 VARCHAR(128), OUT E6 VARCHAR(128), OUT E7 VARCHAR(128)) MODIFIES SQL DATA PARAMETER STYLE JAVA LANGUAGE JAVA EXTERNAL NAME 'org.apache.derbyTesting.functionTests.util.ProcedureTest.sqlControl3'
+CREATE PROCEDURE SQLC.SQLCONTROL4_4 (IN SQLC INTEGER, OUT E1 VARCHAR(128), OUT E2 VARCHAR(128), OUT E3 VARCHAR(128), OUT E4 VARCHAR(128), OUT E5 VARCHAR(128), OUT E6 VARCHAR(128), OUT E7 VARCHAR(128), OUT E8 VARCHAR(128)) MODIFIES SQL DATA PARAMETER STYLE JAVA LANGUAGE JAVA EXTERNAL NAME 'org.apache.derbyTesting.functionTests.util.ProcedureTest.sqlControl4'
+DEFINED PROCEDURES FOR SQLCONTROL1_%
+  SQLC.SQLCONTROL1_0 AS org.apache.derbyTesting.functionTests.util.ProcedureTest.sqlControl(OUT E1 VARCHAR(128),OUT E2 VARCHAR(128),OUT E3 VARCHAR(128),OUT E4 VARCHAR(128),OUT E5 VARCHAR(128),OUT E6 VARCHAR(128),OUT E7 VARCHAR(128)) LANGUAGE JAVA PARAMETER STYLE JAVA MODIFIES SQL DATA
+  SQLC.SQLCONTROL1_1 AS org.apache.derbyTesting.functionTests.util.ProcedureTest.sqlControl(OUT E1 VARCHAR(128),OUT E2 VARCHAR(128),OUT E3 VARCHAR(128),OUT E4 VARCHAR(128),OUT E5 VARCHAR(128),OUT E6 VARCHAR(128),OUT E7 VARCHAR(128)) LANGUAGE JAVA PARAMETER STYLE JAVA NO SQL
+  SQLC.SQLCONTROL1_2 AS org.apache.derbyTesting.functionTests.util.ProcedureTest.sqlControl(OUT E1 VARCHAR(128),OUT E2 VARCHAR(128),OUT E3 VARCHAR(128),OUT E4 VARCHAR(128),OUT E5 VARCHAR(128),OUT E6 VARCHAR(128),OUT E7 VARCHAR(128)) LANGUAGE JAVA PARAMETER STYLE JAVA CONTAINS SQL
+  SQLC.SQLCONTROL1_3 AS org.apache.derbyTesting.functionTests.util.ProcedureTest.sqlControl(OUT E1 VARCHAR(128),OUT E2 VARCHAR(128),OUT E3 VARCHAR(128),OUT E4 VARCHAR(128),OUT E5 VARCHAR(128),OUT E6 VARCHAR(128),OUT E7 VARCHAR(128)) LANGUAGE JAVA PARAMETER STYLE JAVA READS SQL DATA
+  SQLC.SQLCONTROL1_4 AS org.apache.derbyTesting.functionTests.util.ProcedureTest.sqlControl(OUT E1 VARCHAR(128),OUT E2 VARCHAR(128),OUT E3 VARCHAR(128),OUT E4 VARCHAR(128),OUT E5 VARCHAR(128),OUT E6 VARCHAR(128),OUT E7 VARCHAR(128)) LANGUAGE JAVA PARAMETER STYLE JAVA MODIFIES SQL DATA
+DATABASE METATDATA PROCEDURES FOR SQLCONTROL1_%
+  SQLC.SQLCONTROL1_0 AS org.apache.derbyTesting.functionTests.util.ProcedureTest.sqlControl type procedureNoResult
+    procedureColumnOut E1 VARCHAR
+    procedureColumnOut E2 VARCHAR
+    procedureColumnOut E3 VARCHAR
+    procedureColumnOut E4 VARCHAR
+    procedureColumnOut E5 VARCHAR
+    procedureColumnOut E6 VARCHAR
+    procedureColumnOut E7 VARCHAR
+  SQLC.SQLCONTROL1_1 AS org.apache.derbyTesting.functionTests.util.ProcedureTest.sqlControl type procedureNoResult
+    procedureColumnOut E1 VARCHAR
+    procedureColumnOut E2 VARCHAR
+    procedureColumnOut E3 VARCHAR
+    procedureColumnOut E4 VARCHAR
+    procedureColumnOut E5 VARCHAR
+    procedureColumnOut E6 VARCHAR
+    procedureColumnOut E7 VARCHAR
+  SQLC.SQLCONTROL1_2 AS org.apache.derbyTesting.functionTests.util.ProcedureTest.sqlControl type procedureNoResult
+    procedureColumnOut E1 VARCHAR
+    procedureColumnOut E2 VARCHAR
+    procedureColumnOut E3 VARCHAR
+    procedureColumnOut E4 VARCHAR
+    procedureColumnOut E5 VARCHAR
+    procedureColumnOut E6 VARCHAR
+    procedureColumnOut E7 VARCHAR
+  SQLC.SQLCONTROL1_3 AS org.apache.derbyTesting.functionTests.util.ProcedureTest.sqlControl type procedureNoResult
+    procedureColumnOut E1 VARCHAR
+    procedureColumnOut E2 VARCHAR
+    procedureColumnOut E3 VARCHAR
+    procedureColumnOut E4 VARCHAR
+    procedureColumnOut E5 VARCHAR
+    procedureColumnOut E6 VARCHAR
+    procedureColumnOut E7 VARCHAR
+  SQLC.SQLCONTROL1_4 AS org.apache.derbyTesting.functionTests.util.ProcedureTest.sqlControl type procedureNoResult
+    procedureColumnOut E1 VARCHAR
+    procedureColumnOut E2 VARCHAR
+    procedureColumnOut E3 VARCHAR
+    procedureColumnOut E4 VARCHAR
+    procedureColumnOut E5 VARCHAR
+    procedureColumnOut E6 VARCHAR
+    procedureColumnOut E7 VARCHAR
+------------
+DEFINED PROCEDURES FOR SQLCONTROL2_%
+  SQLC.SQLCONTROL2_0 AS org.apache.derbyTesting.functionTests.util.ProcedureTest.sqlControl2(OUT E1 VARCHAR(128),OUT E2 VARCHAR(128),OUT E3 VARCHAR(128),OUT E4 VARCHAR(128),OUT E5 VARCHAR(128),OUT E6 VARCHAR(128),OUT E7 VARCHAR(128)) LANGUAGE JAVA PARAMETER STYLE JAVA MODIFIES SQL DATA
+  SQLC.SQLCONTROL2_1 AS org.apache.derbyTesting.functionTests.util.ProcedureTest.sqlControl2(OUT E1 VARCHAR(128),OUT E2 VARCHAR(128),OUT E3 VARCHAR(128),OUT E4 VARCHAR(128),OUT E5 VARCHAR(128),OUT E6 VARCHAR(128),OUT E7 VARCHAR(128)) LANGUAGE JAVA PARAMETER STYLE JAVA NO SQL
+  SQLC.SQLCONTROL2_2 AS org.apache.derbyTesting.functionTests.util.ProcedureTest.sqlControl2(OUT E1 VARCHAR(128),OUT E2 VARCHAR(128),OUT E3 VARCHAR(128),OUT E4 VARCHAR(128),OUT E5 VARCHAR(128),OUT E6 VARCHAR(128),OUT E7 VARCHAR(128)) LANGUAGE JAVA PARAMETER STYLE JAVA CONTAINS SQL
+  SQLC.SQLCONTROL2_3 AS org.apache.derbyTesting.functionTests.util.ProcedureTest.sqlControl2(OUT E1 VARCHAR(128),OUT E2 VARCHAR(128),OUT E3 VARCHAR(128),OUT E4 VARCHAR(128),OUT E5 VARCHAR(128),OUT E6 VARCHAR(128),OUT E7 VARCHAR(128)) LANGUAGE JAVA PARAMETER STYLE JAVA READS SQL DATA
+  SQLC.SQLCONTROL2_4 AS org.apache.derbyTesting.functionTests.util.ProcedureTest.sqlControl2(OUT E1 VARCHAR(128),OUT E2 VARCHAR(128),OUT E3 VARCHAR(128),OUT E4 VARCHAR(128),OUT E5 VARCHAR(128),OUT E6 VARCHAR(128),OUT E7 VARCHAR(128)) LANGUAGE JAVA PARAMETER STYLE JAVA MODIFIES SQL DATA
+DATABASE METATDATA PROCEDURES FOR SQLCONTROL2_%
+  SQLC.SQLCONTROL2_0 AS org.apache.derbyTesting.functionTests.util.ProcedureTest.sqlControl2 type procedureNoResult
+    procedureColumnOut E1 VARCHAR
+    procedureColumnOut E2 VARCHAR
+    procedureColumnOut E3 VARCHAR
+    procedureColumnOut E4 VARCHAR
+    procedureColumnOut E5 VARCHAR
+    procedureColumnOut E6 VARCHAR
+    procedureColumnOut E7 VARCHAR
+  SQLC.SQLCONTROL2_1 AS org.apache.derbyTesting.functionTests.util.ProcedureTest.sqlControl2 type procedureNoResult
+    procedureColumnOut E1 VARCHAR
+    procedureColumnOut E2 VARCHAR
+    procedureColumnOut E3 VARCHAR
+    procedureColumnOut E4 VARCHAR
+    procedureColumnOut E5 VARCHAR
+    procedureColumnOut E6 VARCHAR
+    procedureColumnOut E7 VARCHAR
+  SQLC.SQLCONTROL2_2 AS org.apache.derbyTesting.functionTests.util.ProcedureTest.sqlControl2 type procedureNoResult
+    procedureColumnOut E1 VARCHAR
+    procedureColumnOut E2 VARCHAR
+    procedureColumnOut E3 VARCHAR
+    procedureColumnOut E4 VARCHAR
+    procedureColumnOut E5 VARCHAR
+    procedureColumnOut E6 VARCHAR
+    procedureColumnOut E7 VARCHAR
+  SQLC.SQLCONTROL2_3 AS org.apache.derbyTesting.functionTests.util.ProcedureTest.sqlControl2 type procedureNoResult
+    procedureColumnOut E1 VARCHAR
+    procedureColumnOut E2 VARCHAR
+    procedureColumnOut E3 VARCHAR
+    procedureColumnOut E4 VARCHAR
+    procedureColumnOut E5 VARCHAR
+    procedureColumnOut E6 VARCHAR
+    procedureColumnOut E7 VARCHAR
+  SQLC.SQLCONTROL2_4 AS org.apache.derbyTesting.functionTests.util.ProcedureTest.sqlControl2 type procedureNoResult
+    procedureColumnOut E1 VARCHAR
+    procedureColumnOut E2 VARCHAR
+    procedureColumnOut E3 VARCHAR
+    procedureColumnOut E4 VARCHAR
+    procedureColumnOut E5 VARCHAR
+    procedureColumnOut E6 VARCHAR
+    procedureColumnOut E7 VARCHAR
+------------
+DEFINED PROCEDURES FOR SQLCONTROL3_%
+  SQLC.SQLCONTROL3_0 AS org.apache.derbyTesting.functionTests.util.ProcedureTest.sqlControl3(OUT E1 VARCHAR(128),OUT E2 VARCHAR(128),OUT E3 VARCHAR(128),OUT E4 VARCHAR(128),OUT E5 VARCHAR(128),OUT E6 VARCHAR(128),OUT E7 VARCHAR(128)) LANGUAGE JAVA PARAMETER STYLE JAVA MODIFIES SQL DATA
+  SQLC.SQLCONTROL3_1 AS org.apache.derbyTesting.functionTests.util.ProcedureTest.sqlControl3(OUT E1 VARCHAR(128),OUT E2 VARCHAR(128),OUT E3 VARCHAR(128),OUT E4 VARCHAR(128),OUT E5 VARCHAR(128),OUT E6 VARCHAR(128),OUT E7 VARCHAR(128)) LANGUAGE JAVA PARAMETER STYLE JAVA NO SQL
+  SQLC.SQLCONTROL3_2 AS org.apache.derbyTesting.functionTests.util.ProcedureTest.sqlControl3(OUT E1 VARCHAR(128),OUT E2 VARCHAR(128),OUT E3 VARCHAR(128),OUT E4 VARCHAR(128),OUT E5 VARCHAR(128),OUT E6 VARCHAR(128),OUT E7 VARCHAR(128)) LANGUAGE JAVA PARAMETER STYLE JAVA CONTAINS SQL
+  SQLC.SQLCONTROL3_3 AS org.apache.derbyTesting.functionTests.util.ProcedureTest.sqlControl3(OUT E1 VARCHAR(128),OUT E2 VARCHAR(128),OUT E3 VARCHAR(128),OUT E4 VARCHAR(128),OUT E5 VARCHAR(128),OUT E6 VARCHAR(128),OUT E7 VARCHAR(128)) LANGUAGE JAVA PARAMETER STYLE JAVA READS SQL DATA
+  SQLC.SQLCONTROL3_4 AS org.apache.derbyTesting.functionTests.util.ProcedureTest.sqlControl3(OUT E1 VARCHAR(128),OUT E2 VARCHAR(128),OUT E3 VARCHAR(128),OUT E4 VARCHAR(128),OUT E5 VARCHAR(128),OUT E6 VARCHAR(128),OUT E7 VARCHAR(128)) LANGUAGE JAVA PARAMETER STYLE JAVA MODIFIES SQL DATA
+DATABASE METATDATA PROCEDURES FOR SQLCONTROL3_%
+  SQLC.SQLCONTROL3_0 AS org.apache.derbyTesting.functionTests.util.ProcedureTest.sqlControl3 type procedureNoResult
+    procedureColumnOut E1 VARCHAR
+    procedureColumnOut E2 VARCHAR
+    procedureColumnOut E3 VARCHAR
+    procedureColumnOut E4 VARCHAR
+    procedureColumnOut E5 VARCHAR
+    procedureColumnOut E6 VARCHAR
+    procedureColumnOut E7 VARCHAR
+  SQLC.SQLCONTROL3_1 AS org.apache.derbyTesting.functionTests.util.ProcedureTest.sqlControl3 type procedureNoResult
+    procedureColumnOut E1 VARCHAR
+    procedureColumnOut E2 VARCHAR
+    procedureColumnOut E3 VARCHAR
+    procedureColumnOut E4 VARCHAR
+    procedureColumnOut E5 VARCHAR
+    procedureColumnOut E6 VARCHAR
+    procedureColumnOut E7 VARCHAR
+  SQLC.SQLCONTROL3_2 AS org.apache.derbyTesting.functionTests.util.ProcedureTest.sqlControl3 type procedureNoResult
+    procedureColumnOut E1 VARCHAR
+    procedureColumnOut E2 VARCHAR
+    procedureColumnOut E3 VARCHAR
+    procedureColumnOut E4 VARCHAR
+    procedureColumnOut E5 VARCHAR
+    procedureColumnOut E6 VARCHAR
+    procedureColumnOut E7 VARCHAR
+  SQLC.SQLCONTROL3_3 AS org.apache.derbyTesting.functionTests.util.ProcedureTest.sqlControl3 type procedureNoResult
+    procedureColumnOut E1 VARCHAR
+    procedureColumnOut E2 VARCHAR
+    procedureColumnOut E3 VARCHAR
+    procedureColumnOut E4 VARCHAR
+    procedureColumnOut E5 VARCHAR
+    procedureColumnOut E6 VARCHAR
+    procedureColumnOut E7 VARCHAR
+  SQLC.SQLCONTROL3_4 AS org.apache.derbyTesting.functionTests.util.ProcedureTest.sqlControl3 type procedureNoResult
+    procedureColumnOut E1 VARCHAR
+    procedureColumnOut E2 VARCHAR
+    procedureColumnOut E3 VARCHAR
+    procedureColumnOut E4 VARCHAR
+    procedureColumnOut E5 VARCHAR
+    procedureColumnOut E6 VARCHAR
+    procedureColumnOut E7 VARCHAR
+------------
+DEFINED PROCEDURES FOR SQLCONTROL4_%
+  SQLC.SQLCONTROL4_0 AS org.apache.derbyTesting.functionTests.util.ProcedureTest.sqlControl4(IN SQLC INTEGER,OUT E1 VARCHAR(128),OUT E2 VARCHAR(128),OUT E3 VARCHAR(128),OUT E4 VARCHAR(128),OUT E5 VARCHAR(128),OUT E6 VARCHAR(128),OUT E7 VARCHAR(128),OUT E8 VARCHAR(128)) LANGUAGE JAVA PARAMETER STYLE JAVA MODIFIES SQL DATA
+  SQLC.SQLCONTROL4_1 AS org.apache.derbyTesting.functionTests.util.ProcedureTest.sqlControl4(IN SQLC INTEGER,OUT E1 VARCHAR(128),OUT E2 VARCHAR(128),OUT E3 VARCHAR(128),OUT E4 VARCHAR(128),OUT E5 VARCHAR(128),OUT E6 VARCHAR(128),OUT E7 VARCHAR(128),OUT E8 VARCHAR(128)) LANGUAGE JAVA PARAMETER STYLE JAVA NO SQL
+  SQLC.SQLCONTROL4_2 AS org.apache.derbyTesting.functionTests.util.ProcedureTest.sqlControl4(IN SQLC INTEGER,OUT E1 VARCHAR(128),OUT E2 VARCHAR(128),OUT E3 VARCHAR(128),OUT E4 VARCHAR(128),OUT E5 VARCHAR(128),OUT E6 VARCHAR(128),OUT E7 VARCHAR(128),OUT E8 VARCHAR(128)) LANGUAGE JAVA PARAMETER STYLE JAVA CONTAINS SQL
+  SQLC.SQLCONTROL4_3 AS org.apache.derbyTesting.functionTests.util.ProcedureTest.sqlControl4(IN SQLC INTEGER,OUT E1 VARCHAR(128),OUT E2 VARCHAR(128),OUT E3 VARCHAR(128),OUT E4 VARCHAR(128),OUT E5 VARCHAR(128),OUT E6 VARCHAR(128),OUT E7 VARCHAR(128),OUT E8 VARCHAR(128)) LANGUAGE JAVA PARAMETER STYLE JAVA READS SQL DATA
+  SQLC.SQLCONTROL4_4 AS org.apache.derbyTesting.functionTests.util.ProcedureTest.sqlControl4(IN SQLC INTEGER,OUT E1 VARCHAR(128),OUT E2 VARCHAR(128),OUT E3 VARCHAR(128),OUT E4 VARCHAR(128),OUT E5 VARCHAR(128),OUT E6 VARCHAR(128),OUT E7 VARCHAR(128),OUT E8 VARCHAR(128)) LANGUAGE JAVA PARAMETER STYLE JAVA MODIFIES SQL DATA
+DATABASE METATDATA PROCEDURES FOR SQLCONTROL4_%
+  SQLC.SQLCONTROL4_0 AS org.apache.derbyTesting.functionTests.util.ProcedureTest.sqlControl4 type procedureNoResult
+    procedureColumnIn SQLC INTEGER
+    procedureColumnOut E1 VARCHAR
+    procedureColumnOut E2 VARCHAR
+    procedureColumnOut E3 VARCHAR
+    procedureColumnOut E4 VARCHAR
+    procedureColumnOut E5 VARCHAR
+    procedureColumnOut E6 VARCHAR
+    procedureColumnOut E7 VARCHAR
+    procedureColumnOut E8 VARCHAR
+  SQLC.SQLCONTROL4_1 AS org.apache.derbyTesting.functionTests.util.ProcedureTest.sqlControl4 type procedureNoResult
+    procedureColumnIn SQLC INTEGER
+    procedureColumnOut E1 VARCHAR
+    procedureColumnOut E2 VARCHAR
+    procedureColumnOut E3 VARCHAR
+    procedureColumnOut E4 VARCHAR
+    procedureColumnOut E5 VARCHAR
+    procedureColumnOut E6 VARCHAR
+    procedureColumnOut E7 VARCHAR
+    procedureColumnOut E8 VARCHAR
+  SQLC.SQLCONTROL4_2 AS org.apache.derbyTesting.functionTests.util.ProcedureTest.sqlControl4 type procedureNoResult
+    procedureColumnIn SQLC INTEGER
+    procedureColumnOut E1 VARCHAR
+    procedureColumnOut E2 VARCHAR
+    procedureColumnOut E3 VARCHAR
+    procedureColumnOut E4 VARCHAR
+    procedureColumnOut E5 VARCHAR
+    procedureColumnOut E6 VARCHAR
+    procedureColumnOut E7 VARCHAR
+    procedureColumnOut E8 VARCHAR
+  SQLC.SQLCONTROL4_3 AS org.apache.derbyTesting.functionTests.util.ProcedureTest.sqlControl4 type procedureNoResult
+    procedureColumnIn SQLC INTEGER
+    procedureColumnOut E1 VARCHAR
+    procedureColumnOut E2 VARCHAR
+    procedureColumnOut E3 VARCHAR
+    procedureColumnOut E4 VARCHAR
+    procedureColumnOut E5 VARCHAR
+    procedureColumnOut E6 VARCHAR
+    procedureColumnOut E7 VARCHAR
+    procedureColumnOut E8 VARCHAR
+  SQLC.SQLCONTROL4_4 AS org.apache.derbyTesting.functionTests.util.ProcedureTest.sqlControl4 type procedureNoResult
+    procedureColumnIn SQLC INTEGER
+    procedureColumnOut E1 VARCHAR
+    procedureColumnOut E2 VARCHAR
+    procedureColumnOut E3 VARCHAR
+    procedureColumnOut E4 VARCHAR
+    procedureColumnOut E5 VARCHAR
+    procedureColumnOut E6 VARCHAR
+    procedureColumnOut E7 VARCHAR
+    procedureColumnOut E8 VARCHAR
+------------
+** SQL ** DEFAULT (MODIFIES SQL DATA)
+    CREATE TABLE SQ-UPDATE 0-EXECUTE OK
+    ALTER TABLE SQL-UPDATE 0-EXECUTE OK
+    INSERT INTO SQL-UPDATE 1-EXECUTE OK
+    UPDATE SQLC.SQL-UPDATE 2-EXECUTE OK
+    SELECT * FROM S- ROW(15)- ROW(12)-EXECUTE OK
+    DELETE FROM SQL-UPDATE 2-EXECUTE OK
+    DROP TABLE SQLC-UPDATE 0-EXECUTE OK
+    CREATE VIEW SQL-42X05
+    DROP VIEW SQLCO-X0X05
+    LOCK TABLE SQLC-42X05
+    VALUES 1,2,3- ROW(1)- ROW(2)- ROW(3)-EXECUTE OK
+    SET SCHEMA SQLC-UPDATE 0-EXECUTE OK
+    CREATE SCHEMA S-UPDATE 0-EXECUTE OK
+    DROP SCHEMA SQL-UPDATE 0-EXECUTE OK
+    IBM CS FEATURE
+    IBM CS FEATURE
+    SET ISOLATION C-UPDATE 0-EXECUTE OK
+    SET RUNTIMESTAT-42X01
+    SET STATISTICS -42X01
+    VALUES 1- ROW(1)-EXECUTE OK
+    VALUES 1- ROW(1)-EXECUTE OK
+** SQL ** NO SQL
+    CREATE TABLE SQ-38001
+    ALTER TABLE SQL-42Y55
+    INSERT INTO SQL-42X05
+    UPDATE SQLC.SQL-42X05
+    SELECT * FROM S-42X05
+    DELETE FROM SQL-42X05
+    DROP TABLE SQLC-42Y55
+    CREATE VIEW SQL-42X05
+    DROP VIEW SQLCO-38001
+    LOCK TABLE SQLC-42X05
+    VALUES 1,2,3-38001
+    SET SCHEMA SQLC-38001
+    CREATE SCHEMA S-38001
+    DROP SCHEMA SQL-38001
+    IBM CS FEATURE
+    IBM CS FEATURE
+    SET ISOLATION C-38001
+    SET RUNTIMESTAT-42X01
+    SET STATISTICS -42X01
+    VALUES 1-38001
+    VALUES 1-38001
+** SQL ** CONTAINS SQL
+    CREATE TABLE SQ-38002
+    ALTER TABLE SQL-42Y55
+    INSERT INTO SQL-42X05
+    UPDATE SQLC.SQL-42X05
+    SELECT * FROM S-42X05
+    DELETE FROM SQL-42X05
+    DROP TABLE SQLC-42Y55
+    CREATE VIEW SQL-42X05
+    DROP VIEW SQLCO-38002
+    LOCK TABLE SQLC-42X05
+    VALUES 1,2,3-38004
+    SET SCHEMA SQLC-UPDATE 0-EXECUTE OK
+    CREATE SCHEMA S-38002
+    DROP SCHEMA SQL-38002
+    IBM CS FEATURE
+    IBM CS FEATURE
+    SET ISOLATION C-UPDATE 0-EXECUTE OK
+    SET RUNTIMESTAT-42X01
+    SET STATISTICS -42X01
+    VALUES 1-38004
+    VALUES 1-38004
+** SQL ** READS SQL DATA
+    CREATE TABLE SQ-38002
+    ALTER TABLE SQL-42Y55
+    INSERT INTO SQL-42X05
+    UPDATE SQLC.SQL-42X05
+    SELECT * FROM S-42X05
+    DELETE FROM SQL-42X05
+    DROP TABLE SQLC-42Y55
+    CREATE VIEW SQL-42X05
+    DROP VIEW SQLCO-38002
+    LOCK TABLE SQLC-42X05
+    VALUES 1,2,3- ROW(1)- ROW(2)- ROW(3)-EXECUTE OK
+    SET SCHEMA SQLC-UPDATE 0-EXECUTE OK
+    CREATE SCHEMA S-38002
+    DROP SCHEMA SQL-38002
+    IBM CS FEATURE
+    IBM CS FEATURE
+    SET ISOLATION C-UPDATE 0-EXECUTE OK
+    SET RUNTIMESTAT-42X01
+    SET STATISTICS -42X01
+    VALUES 1- ROW(1)-EXECUTE OK
+    VALUES 1- ROW(1)-EXECUTE OK
+** SQL ** MODIFIES SQL DATA
+    CREATE TABLE SQ-UPDATE 0-EXECUTE OK
+    ALTER TABLE SQL-42Y55
+    INSERT INTO SQL-42X05
+    UPDATE SQLC.SQL-42X05
+    SELECT * FROM S-42X05
+    DELETE FROM SQL-42X05
+    DROP TABLE SQLC-42Y55
+    CREATE VIEW SQL-42X05
+    DROP VIEW SQLCO-X0X05
+    LOCK TABLE SQLC-42X05
+    VALUES 1,2,3- ROW(1)- ROW(2)- ROW(3)-EXECUTE OK
+    SET SCHEMA SQLC-UPDATE 0-EXECUTE OK
+    CREATE SCHEMA S-UPDATE 0-EXECUTE OK
+    DROP SCHEMA SQL-UPDATE 0-EXECUTE OK
+    IBM CS FEATURE
+    IBM CS FEATURE
+    SET ISOLATION C-UPDATE 0-EXECUTE OK
+    SET RUNTIMESTAT-42X01
+    SET STATISTICS -42X01
+    VALUES 1- ROW(1)-EXECUTE OK
+    VALUES 1- ROW(1)-EXECUTE OK
+CALL ** DEFAULT (MODIFIES SQL DATA)
+    CALLLING DEFAULT (MODIFIES SQL DATA)
+         CALL SQLC.SQLCONTROL2_0 (?, ?, ?, ?, ?, ?, ?) 
+         CREATE VIEW SQL-UPDATE 0-EXECUTE OK
+         DROP VIEW SQLCO-UPDATE 0-EXECUTE OK
+         LOCK TABLE SQLC-UPDATE 0-EXECUTE OK
+         VALUES 1,2,3- ROW(1)- ROW(2)- ROW(3)-EXECUTE OK
+         SET SCHEMA SQLC-UPDATE 0-EXECUTE OK
+         CREATE SCHEMA S-UPDATE 0-EXECUTE OK
+         DROP SCHEMA SQL-UPDATE 0-EXECUTE OK
+    CALLLING NO SQL
+         CALL SQLC.SQLCONTROL2_1 (?, ?, ?, ?, ?, ?, ?) 
+         CREATE VIEW SQL-38001
+         DROP VIEW SQLCO-38001
+         LOCK TABLE SQLC-38001
+         VALUES 1,2,3-38001
+         SET SCHEMA SQLC-38001
+         CREATE SCHEMA S-38001
+         DROP SCHEMA SQL-38001
+    CALLLING CONTAINS SQL
+         CALL SQLC.SQLCONTROL2_2 (?, ?, ?, ?, ?, ?, ?) 
+         CREATE VIEW SQL-38002
+         DROP VIEW SQLCO-38002
+         LOCK TABLE SQLC-UPDATE 0-EXECUTE OK
+         VALUES 1,2,3-38004
+         SET SCHEMA SQLC-UPDATE 0-EXECUTE OK
+         CREATE SCHEMA S-38002
+         DROP SCHEMA SQL-38002
+    CALLLING READS SQL DATA
+         CALL SQLC.SQLCONTROL2_3 (?, ?, ?, ?, ?, ?, ?) 
+         CREATE VIEW SQL-38002
+         DROP VIEW SQLCO-38002
+         LOCK TABLE SQLC-UPDATE 0-EXECUTE OK
+         VALUES 1,2,3- ROW(1)- ROW(2)- ROW(3)-EXECUTE OK
+         SET SCHEMA SQLC-UPDATE 0-EXECUTE OK
+         CREATE SCHEMA S-38002
+         DROP SCHEMA SQL-38002
+    CALLLING MODIFIES SQL DATA
+         CALL SQLC.SQLCONTROL2_4 (?, ?, ?, ?, ?, ?, ?) 
+         CREATE VIEW SQL-UPDATE 0-EXECUTE OK
+         DROP VIEW SQLCO-UPDATE 0-EXECUTE OK
+         LOCK TABLE SQLC-UPDATE 0-EXECUTE OK
+         VALUES 1,2,3- ROW(1)- ROW(2)- ROW(3)-EXECUTE OK
+         SET SCHEMA SQLC-UPDATE 0-EXECUTE OK
+         CREATE SCHEMA S-UPDATE 0-EXECUTE OK
+         DROP SCHEMA SQL-UPDATE 0-EXECUTE OK
+CALL ** NO SQL
+    CALLLING DEFAULT (MODIFIES SQL DATA)
+         CALL SQLC.SQLCONTROL2_0 (?, ?, ?, ?, ?, ?, ?) 
+         STATE-38001
+    CALLLING NO SQL
+         CALL SQLC.SQLCONTROL2_1 (?, ?, ?, ?, ?, ?, ?) 
+         STATE-38001
+    CALLLING CONTAINS SQL
+         CALL SQLC.SQLCONTROL2_2 (?, ?, ?, ?, ?, ?, ?) 
+         STATE-38001
+    CALLLING READS SQL DATA
+         CALL SQLC.SQLCONTROL2_3 (?, ?, ?, ?, ?, ?, ?) 
+         STATE-38001
+    CALLLING MODIFIES SQL DATA
+         CALL SQLC.SQLCONTROL2_4 (?, ?, ?, ?, ?, ?, ?) 
+         STATE-38001
+CALL ** CONTAINS SQL
+    CALLLING DEFAULT (MODIFIES SQL DATA)
+         CALL SQLC.SQLCONTROL2_0 (?, ?, ?, ?, ?, ?, ?) 
+         STATE-38002
+    CALLLING NO SQL
+         CALL SQLC.SQLCONTROL2_1 (?, ?, ?, ?, ?, ?, ?) 
+         CREATE VIEW SQL-38001
+         DROP VIEW SQLCO-38001
+         LOCK TABLE SQLC-38001
+         VALUES 1,2,3-38001
+         SET SCHEMA SQLC-38001
+         CREATE SCHEMA S-38001
+         DROP SCHEMA SQL-38001
+    CALLLING CONTAINS SQL
+         CALL SQLC.SQLCONTROL2_2 (?, ?, ?, ?, ?, ?, ?) 
+         CREATE VIEW SQL-38002
+         DROP VIEW SQLCO-38002
+         LOCK TABLE SQLC-UPDATE 0-EXECUTE OK
+         VALUES 1,2,3-38004
+         SET SCHEMA SQLC-UPDATE 0-EXECUTE OK
+         CREATE SCHEMA S-38002
+         DROP SCHEMA SQL-38002
+    CALLLING READS SQL DATA
+         CALL SQLC.SQLCONTROL2_3 (?, ?, ?, ?, ?, ?, ?) 
+         STATE-38004
+    CALLLING MODIFIES SQL DATA
+         CALL SQLC.SQLCONTROL2_4 (?, ?, ?, ?, ?, ?, ?) 
+         STATE-38002
+CALL ** READS SQL DATA
+    CALLLING DEFAULT (MODIFIES SQL DATA)
+         CALL SQLC.SQLCONTROL2_0 (?, ?, ?, ?, ?, ?, ?) 
+         STATE-38002
+    CALLLING NO SQL
+         CALL SQLC.SQLCONTROL2_1 (?, ?, ?, ?, ?, ?, ?) 
+         CREATE VIEW SQL-38001
+         DROP VIEW SQLCO-38001
+         LOCK TABLE SQLC-38001
+         VALUES 1,2,3-38001
+         SET SCHEMA SQLC-38001
+         CREATE SCHEMA S-38001
+         DROP SCHEMA SQL-38001
+    CALLLING CONTAINS SQL
+         CALL SQLC.SQLCONTROL2_2 (?, ?, ?, ?, ?, ?, ?) 
+         CREATE VIEW SQL-38002
+         DROP VIEW SQLCO-38002
+         LOCK TABLE SQLC-UPDATE 0-EXECUTE OK
+         VALUES 1,2,3-38004
+         SET SCHEMA SQLC-UPDATE 0-EXECUTE OK
+         CREATE SCHEMA S-38002
+         DROP SCHEMA SQL-38002
+    CALLLING READS SQL DATA
+         CALL SQLC.SQLCONTROL2_3 (?, ?, ?, ?, ?, ?, ?) 
+         CREATE VIEW SQL-38002
+         DROP VIEW SQLCO-38002
+         LOCK TABLE SQLC-UPDATE 0-EXECUTE OK
+         VALUES 1,2,3- ROW(1)- ROW(2)- ROW(3)-EXECUTE OK
+         SET SCHEMA SQLC-UPDATE 0-EXECUTE OK
+         CREATE SCHEMA S-38002
+         DROP SCHEMA SQL-38002
+    CALLLING MODIFIES SQL DATA
+         CALL SQLC.SQLCONTROL2_4 (?, ?, ?, ?, ?, ?, ?) 
+         STATE-38002
+CALL ** MODIFIES SQL DATA
+    CALLLING DEFAULT (MODIFIES SQL DATA)
+         CALL SQLC.SQLCONTROL2_0 (?, ?, ?, ?, ?, ?, ?) 
+         CREATE VIEW SQL-UPDATE 0-EXECUTE OK
+         DROP VIEW SQLCO-UPDATE 0-EXECUTE OK
+         LOCK TABLE SQLC-UPDATE 0-EXECUTE OK
+         VALUES 1,2,3- ROW(1)- ROW(2)- ROW(3)-EXECUTE OK
+         SET SCHEMA SQLC-UPDATE 0-EXECUTE OK
+         CREATE SCHEMA S-UPDATE 0-EXECUTE OK
+         DROP SCHEMA SQL-UPDATE 0-EXECUTE OK
+    CALLLING NO SQL
+         CALL SQLC.SQLCONTROL2_1 (?, ?, ?, ?, ?, ?, ?) 
+         CREATE VIEW SQL-38001
+         DROP VIEW SQLCO-38001
+         LOCK TABLE SQLC-38001
+         VALUES 1,2,3-38001
+         SET SCHEMA SQLC-38001
+         CREATE SCHEMA S-38001
+         DROP SCHEMA SQL-38001
+    CALLLING CONTAINS SQL
+         CALL SQLC.SQLCONTROL2_2 (?, ?, ?, ?, ?, ?, ?) 
+         CREATE VIEW SQL-38002
+         DROP VIEW SQLCO-38002
+         LOCK TABLE SQLC-UPDATE 0-EXECUTE OK
+         VALUES 1,2,3-38004
+         SET SCHEMA SQLC-UPDATE 0-EXECUTE OK
+         CREATE SCHEMA S-38002
+         DROP SCHEMA SQL-38002
+    CALLLING READS SQL DATA
+         CALL SQLC.SQLCONTROL2_3 (?, ?, ?, ?, ?, ?, ?) 
+         CREATE VIEW SQL-38002
+         DROP VIEW SQLCO-38002
+         LOCK TABLE SQLC-UPDATE 0-EXECUTE OK
+         VALUES 1,2,3- ROW(1)- ROW(2)- ROW(3)-EXECUTE OK
+         SET SCHEMA SQLC-UPDATE 0-EXECUTE OK
+         CREATE SCHEMA S-38002
+         DROP SCHEMA SQL-38002
+    CALLLING MODIFIES SQL DATA
+         CALL SQLC.SQLCONTROL2_4 (?, ?, ?, ?, ?, ?, ?) 
+         CREATE VIEW SQL-UPDATE 0-EXECUTE OK
+         DROP VIEW SQLCO-UPDATE 0-EXECUTE OK
+         LOCK TABLE SQLC-UPDATE 0-EXECUTE OK
+         VALUES 1,2,3- ROW(1)- ROW(2)- ROW(3)-EXECUTE OK
+         SET SCHEMA SQLC-UPDATE 0-EXECUTE OK
+         CREATE SCHEMA S-UPDATE 0-EXECUTE OK
+         DROP SCHEMA SQL-UPDATE 0-EXECUTE OK
+CALL SQLCONTROL3_0 (?, ?, ?, ?, ?, ?, ?)
+EXPECTED SQL Exception: (07004) Parameter 1 is an OUT procedure parameter and must be registered with CallableStatement.registerOutParameter before execution.
+literals
+DEFINED PROCEDURES FOR TY_%
+  LITT.TY_BIGINT AS org.apache.derbyTesting.functionTests.util.ProcedureTest.literalTest(IN P1 BIGINT,OUT P2 VARCHAR(256)) LANGUAGE JAVA PARAMETER STYLE JAVA NO SQL
+  LITT.TY_CHAR AS org.apache.derbyTesting.functionTests.util.ProcedureTest.literalTest(IN P1 CHAR(10),OUT P2 VARCHAR(256)) LANGUAGE JAVA PARAMETER STYLE JAVA NO SQL
+  LITT.TY_DECIMAL AS org.apache.derbyTesting.functionTests.util.ProcedureTest.literalTest(IN P1 DECIMAL(5,2),OUT P2 VARCHAR(256)) LANGUAGE JAVA PARAMETER STYLE JAVA NO SQL
+  LITT.TY_DOUBLE AS org.apache.derbyTesting.functionTests.util.ProcedureTest.literalTest(IN P1 DOUBLE,OUT P2 VARCHAR(256)) LANGUAGE JAVA PARAMETER STYLE JAVA NO SQL
+  LITT.TY_INTEGER AS org.apache.derbyTesting.functionTests.util.ProcedureTest.literalTest(IN P1 INTEGER,OUT P2 VARCHAR(256)) LANGUAGE JAVA PARAMETER STYLE JAVA NO SQL
+  LITT.TY_REAL AS org.apache.derbyTesting.functionTests.util.ProcedureTest.literalTest(IN P1 REAL,OUT P2 VARCHAR(256)) LANGUAGE JAVA PARAMETER STYLE JAVA NO SQL
+  LITT.TY_SMALLINT AS org.apache.derbyTesting.functionTests.util.ProcedureTest.literalTest(IN P1 SMALLINT,OUT P2 VARCHAR(256)) LANGUAGE JAVA PARAMETER STYLE JAVA NO SQL
+  LITT.TY_VARCHAR AS org.apache.derbyTesting.functionTests.util.ProcedureTest.literalTest(IN P1 VARCHAR(10),OUT P2 VARCHAR(256)) LANGUAGE JAVA PARAMETER STYLE JAVA NO SQL
+DATABASE METATDATA PROCEDURES FOR TY_%
+  LITT.TY_BIGINT AS org.apache.derbyTesting.functionTests.util.ProcedureTest.literalTest type procedureNoResult
+    procedureColumnIn P1 BIGINT
+    procedureColumnOut P2 VARCHAR
+  LITT.TY_CHAR AS org.apache.derbyTesting.functionTests.util.ProcedureTest.literalTest type procedureNoResult
+    procedureColumnIn P1 CHAR
+    procedureColumnOut P2 VARCHAR
+  LITT.TY_DECIMAL AS org.apache.derbyTesting.functionTests.util.ProcedureTest.literalTest type procedureNoResult
+    procedureColumnIn P1 DECIMAL
+    procedureColumnOut P2 VARCHAR
+  LITT.TY_DOUBLE AS org.apache.derbyTesting.functionTests.util.ProcedureTest.literalTest type procedureNoResult
+    procedureColumnIn P1 DOUBLE
+    procedureColumnOut P2 VARCHAR
+  LITT.TY_INTEGER AS org.apache.derbyTesting.functionTests.util.ProcedureTest.literalTest type procedureNoResult
+    procedureColumnIn P1 INTEGER
+    procedureColumnOut P2 VARCHAR
+  LITT.TY_REAL AS org.apache.derbyTesting.functionTests.util.ProcedureTest.literalTest type procedureNoResult
+    procedureColumnIn P1 REAL
+    procedureColumnOut P2 VARCHAR
+  LITT.TY_SMALLINT AS org.apache.derbyTesting.functionTests.util.ProcedureTest.literalTest type procedureNoResult
+    procedureColumnIn P1 SMALLINT
+    procedureColumnOut P2 VARCHAR
+  LITT.TY_VARCHAR AS org.apache.derbyTesting.functionTests.util.ProcedureTest.literalTest type procedureNoResult
+    procedureColumnIn P1 VARCHAR
+    procedureColumnOut P2 VARCHAR
+------------
+CALL LITT.TY_SMALLINT (null, ?) (39004) A NULL value cannot be passed to a method which takes a parameter of primitive type 'short'.
+CALL LITT.TY_INTEGER (null, ?) (39004) A NULL value cannot be passed to a method which takes a parameter of primitive type 'int'.
+CALL LITT.TY_BIGINT (null, ?) (39004) A NULL value cannot be passed to a method which takes a parameter of primitive type 'long'.
+CALL LITT.TY_REAL (null, ?) (39004) A NULL value cannot be passed to a method which takes a parameter of primitive type 'float'.
+CALL LITT.TY_DOUBLE (null, ?) (39004) A NULL value cannot be passed to a method which takes a parameter of primitive type 'double'.
+CALL LITT.TY_DECIMAL (null, ?)=>NULL<
+CALL LITT.TY_CHAR (null, ?)=>NULL<
+CALL LITT.TY_VARCHAR (null, ?)=>NULL<
+CALL LITT.TY_SMALLINT (12, ?)=>12<
+CALL LITT.TY_INTEGER (12, ?)=>12<
+CALL LITT.TY_BIGINT (12, ?)=>12<
+CALL LITT.TY_REAL (12, ?)=>12.0<
+CALL LITT.TY_DOUBLE (12, ?)=>12.0<
+CALL LITT.TY_DECIMAL (12, ?)=>12.00<
+CALL LITT.TY_CHAR (12, ?) (42821) Columns of type 'CHAR' cannot hold values of type 'INTEGER'. 
+CALL LITT.TY_VARCHAR (12, ?) (42821) Columns of type 'VARCHAR' cannot hold values of type 'INTEGER'. 
+CALL LITT.TY_SMALLINT (23.43e1, ?)=>234<
+CALL LITT.TY_INTEGER (23.43e1, ?)=>234<
+CALL LITT.TY_BIGINT (23.43e1, ?)=>234<
+CALL LITT.TY_REAL (23.43e1, ?)=>234.3<
+CALL LITT.TY_DOUBLE (23.43e1, ?)=>234.3<
+CALL LITT.TY_DECIMAL (23.43e1, ?)=>234.30<
+CALL LITT.TY_CHAR (23.43e1, ?) (42821) Columns of type 'CHAR' cannot hold values of type 'DOUBLE'. 
+CALL LITT.TY_VARCHAR (23.43e1, ?) (42821) Columns of type 'VARCHAR' cannot hold values of type 'DOUBLE'. 
+CALL LITT.TY_SMALLINT (176.3, ?)=>176<
+CALL LITT.TY_INTEGER (176.3, ?)=>176<
+CALL LITT.TY_BIGINT (176.3, ?)=>176<
+CALL LITT.TY_REAL (176.3, ?)=>176.3<
+CALL LITT.TY_DOUBLE (176.3, ?)=>176.3<
+CALL LITT.TY_DECIMAL (176.3, ?)=>176.30<
+CALL LITT.TY_CHAR (176.3, ?) (42821) Columns of type 'CHAR' cannot hold values of type 'DECIMAL'. 
+CALL LITT.TY_VARCHAR (176.3, ?) (42821) Columns of type 'VARCHAR' cannot hold values of type 'DECIMAL'. 
+CALL LITT.TY_SMALLINT ('12.34', ?) (42821) Columns of type 'SMALLINT' cannot hold values of type 'CHAR'. 
+CALL LITT.TY_INTEGER ('12.34', ?) (42821) Columns of type 'INTEGER' cannot hold values of type 'CHAR'. 
+CALL LITT.TY_BIGINT ('12.34', ?) (42821) Columns of type 'BIGINT' cannot hold values of type 'CHAR'. 
+CALL LITT.TY_REAL ('12.34', ?) (42821) Columns of type 'REAL' cannot hold values of type 'CHAR'. 
+CALL LITT.TY_DOUBLE ('12.34', ?) (42821) Columns of type 'DOUBLE' cannot hold values of type 'CHAR'. 
+CALL LITT.TY_DECIMAL ('12.34', ?) (42821) Columns of type 'DECIMAL' cannot hold values of type 'CHAR'. 
+CALL LITT.TY_CHAR ('12.34', ?)=>12.34     <
+CALL LITT.TY_VARCHAR ('12.34', ?)=>12.34<
+MultipleRSAutoCommit: PASS. 
+MultipleRSNoCommit: PASS. 
+JIRA-491 Successful.
+JIRA-492 successful -- no hang!
+testImplicitClose(): PASSED

Added: db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/jdk16/releaseCompileLocks.out
URL: http://svn.apache.org/viewcvs/db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/jdk16/releaseCompileLocks.out?rev=386169&view=auto
==============================================================================
--- db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/jdk16/releaseCompileLocks.out (added)
+++ db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/jdk16/releaseCompileLocks.out Wed Mar 15 13:31:53 2006
@@ -0,0 +1,213 @@
+ij> autocommit off;
+ij> -- move static initializer tests to front, hoping to avoid class garbage
+-- collection in jdk18.  Sometimes the static initializer in the 
+-- DMLInStaticInitializer and InsertInStaticInitializer classes gets called
+-- twice in jdk118 - causing a diff.  This can happen if for some reason the
+-- JVM decides to garbage collect the class between references to the class
+-- in the course of executing the query.
+-- static initializers.
+create table t1 (s int);
+0 rows inserted/updated/deleted
+ij> commit;
+ij> create function dmlstatic() returns INT
+parameter style java language java
+external name 'org.apache.derbyTesting.functionTests.util.StaticInitializers.DMLInStaticInitializer.getANumber'
+no sql;
+0 rows inserted/updated/deleted
+ij> create function insertstatic() returns INT
+parameter style java language java
+external name 'org.apache.derbyTesting.functionTests.util.StaticInitializers.InsertInStaticInitializer.getANumber'
+no sql;
+0 rows inserted/updated/deleted
+ij> commit;
+ij> -- the static initializer in DMLInStaticInitializer will select from t1 
+-- the DML will be executed within a nested query-- however all locks 
+-- on system tables which the static initializer gets should be released.
+select 
+(dmlstatic()) 
+from sys.systables where tablename = 'SYSCONGLOMERATES';
+1          
+-----------
+Caught exception java.sql.SQLException: The external routine is not allowed to execute SQL statements.
+java.sql.SQLException: The external routine is not allowed to execute SQL statements.
+Caused by: ERROR 38001: The external routine is not allowed to execute SQL statements.
+	... 29 more
+1          
+ij> select TYPE, MODE, TABLENAME, LOCKNAME, STATE from syscs_diag.lock_table
+order by 1;
+TYPE |MODE|TABLENAME                                                                                                                       |LOCKNAME            |STATE
+----------------------------------------------------------------------------------------------------------------------------------------------------------------------
+ij> commit;
+ij> drop table t1;
+0 rows inserted/updated/deleted
+ij> create table t1 (s int);
+0 rows inserted/updated/deleted
+ij> commit;
+ij> select 
+(insertstatic()) 
+from sys.systables where tablename = 'SYSCONGLOMERATES';
+1          
+-----------
+Caught exception java.sql.SQLException: The external routine is not allowed to execute SQL statements.
+java.sql.SQLException: The external routine is not allowed to execute SQL statements.
+Caused by: ERROR 38001: The external routine is not allowed to execute SQL statements.
+	... 30 more
+1          
+ij> -- only two locks!
+select TYPE, MODE, TABLENAME, LOCKNAME, STATE from syscs_diag.lock_table
+order by 1;
+TYPE |MODE|TABLENAME                                                                                                                       |LOCKNAME            |STATE
+----------------------------------------------------------------------------------------------------------------------------------------------------------------------
+ij> -- verify that the row went into t1.
+select * from t1;
+S          
+-----------
+ij> drop table t1;
+0 rows inserted/updated/deleted
+ij> commit;
+ij> select TYPE, MODE, TABLENAME, LOCKNAME, STATE from syscs_diag.lock_table
+order by 1;
+TYPE |MODE|TABLENAME                                                                                                                       |LOCKNAME            |STATE
+----------------------------------------------------------------------------------------------------------------------------------------------------------------------
+ij> commit;
+ij> -- some really simple tests to start off.
+create table test_tab (x int);
+0 rows inserted/updated/deleted
+ij> insert into test_tab values (1);
+1 row inserted/updated/deleted
+ij> commit;
+ij> -- earlier we would get a bunch of locks on the system catalogs 
+-- when trying to resolve the method alias.
+select count(*) from syscs_diag.lock_table;
+1          
+-----------
+0          
+ij> -- select from a system catalog.
+select count(*) from sys.sysviews;
+1          
+-----------
+0          
+ij> -- look ma, no locks.
+select count(*) from syscs_diag.lock_table;
+1          
+-----------
+0          
+ij> insert into test_tab values (2);
+1 row inserted/updated/deleted
+ij> -- only see locks on test_tab, none on system catalogs
+-- 
+select TYPE, MODE, TABLENAME, LOCKNAME, STATE from syscs_diag.lock_table
+order by 1;
+TYPE |MODE|TABLENAME                                                                                                                       |LOCKNAME            |STATE
+----------------------------------------------------------------------------------------------------------------------------------------------------------------------
+ROW  |X   |TEST_TAB                                                                                                                        |(1,8)               |GRANT
+TABLE|IX  |TEST_TAB                                                                                                                        |Tablelock           |GRANT
+ij> -- bugid 3214, atlas case: 962505
+-- selecting from a table would hold locks which would disallow creating
+-- another table.
+drop table t1;
+ERROR 42Y55: 'DROP TABLE' cannot be performed on 'T1' because it does not exist.
+ij> create table t1 (x int);
+0 rows inserted/updated/deleted
+ij> commit;
+ij> select * from t1;
+X          
+-----------
+ij> connect 'wombat' as conn1;
+ij(CONN1)> -- this should not time out waiting for locks.
+create table t2 (x int);
+0 rows inserted/updated/deleted
+ij(CONN1)> drop table t2;
+0 rows inserted/updated/deleted
+ij(CONN1)> set connection connection0;
+ij(CONNECTION0)> disconnect conn1;
+ij> commit;
+ij> show connections;
+CONNECTION0* - 	jdbc:derby:wombat
+* = current connection
+ij> -- create table again to force scanning system catalogs.
+drop table test_tab;
+0 rows inserted/updated/deleted
+ij> create table test_tab (x int);
+0 rows inserted/updated/deleted
+ij> insert into test_tab values (1);
+1 row inserted/updated/deleted
+ij> commit;
+ij> -- prepare a statement-- no locks.
+prepare cursor1 as 'update test_tab set x=2 where x=?';
+ij> select count(*) from syscs_diag.lock_table;
+1          
+-----------
+0          
+ij> -- now execute it-- should see locks on test_tab
+execute cursor1 using 'values (1)';
+1 row inserted/updated/deleted
+ij> select TYPE, MODE, TABLENAME, LOCKNAME, STATE from syscs_diag.lock_table
+order by 1;
+TYPE |MODE|TABLENAME                                                                                                                       |LOCKNAME            |STATE
+----------------------------------------------------------------------------------------------------------------------------------------------------------------------
+ROW  |X   |TEST_TAB                                                                                                                        |(1,7)               |GRANT
+TABLE|IX  |TEST_TAB                                                                                                                        |Tablelock           |GRANT
+ij> commit;
+ij> -- problem with backing index scans.
+create table t (c1 int not null primary key, c2 int references t);
+0 rows inserted/updated/deleted
+ij> insert into t values (1,1);
+1 row inserted/updated/deleted
+ij> insert into t values (2,1);
+1 row inserted/updated/deleted
+ij> commit;
+ij> prepare ps as 'select * from t where c1 = ? and c2 = ?';
+ij> -- no locks, no locks at all.
+select * from syscs_diag.lock_table;
+XID            |TYPE |MODE|TABLENAME                                                                                                                       |LOCKNAME            |STATE|TABLETYPE|LOCK&|INDEXNAME                                                                                                                       
+---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
+ij> -- clear DataDictionary cache
+create table x(c1 int);
+0 rows inserted/updated/deleted
+ij> drop table x;
+0 rows inserted/updated/deleted
+ij> commit;
+ij> -- try inserting into the table; no locks on system catalogs.
+prepare pi as 'insert into t values (3,2)';
+ij> select * from syscs_diag.lock_table;
+XID            |TYPE |MODE|TABLENAME                                                                                                                       |LOCKNAME            |STATE|TABLETYPE|LOCK&|INDEXNAME                                                                                                                       
+---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
+ij> commit;
+ij> -- clear DataDictionary cache
+create table x(c1 int);
+0 rows inserted/updated/deleted
+ij> drop table x;
+0 rows inserted/updated/deleted
+ij> commit;
+ij> -- try updating the table; no locks on system catalogs.
+prepare p1 as 'update t set c2 = c1, c1 = c2';
+ij> select * from syscs_diag.lock_table;
+XID            |TYPE |MODE|TABLENAME                                                                                                                       |LOCKNAME            |STATE|TABLETYPE|LOCK&|INDEXNAME                                                                                                                       
+---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
+ij> commit;
+ij> -- clear DataDictionary cache
+create table x(c1 int);
+0 rows inserted/updated/deleted
+ij> drop table x;
+0 rows inserted/updated/deleted
+ij> commit;
+ij> -- try deleting from the table; no locks on system catalogs.
+prepare p1 as 'delete from t';
+ij> select * from syscs_diag.lock_table;
+XID            |TYPE |MODE|TABLENAME                                                                                                                       |LOCKNAME            |STATE|TABLETYPE|LOCK&|INDEXNAME                                                                                                                       
+---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
+ij> commit;
+ij> -- create some triggers.
+create trigger update_of_t after update on t for each row mode db2sql values 2;
+0 rows inserted/updated/deleted
+ij> create trigger insert_of_t after insert on t for each row mode db2sql values 3;
+0 rows inserted/updated/deleted
+ij> commit;
+ij> -- t has (1,1) (2,1) (3,2)
+prepare pu as 'update t set c2=2 where c1=2';
+ij> select * from syscs_diag.lock_table;
+XID            |TYPE |MODE|TABLENAME                                                                                                                       |LOCKNAME            |STATE|TABLETYPE|LOCK&|INDEXNAME                                                                                                                       
+---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
+ij> commit;
+ij> 

Added: db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/jdk16/statementJdbc20.out
URL: http://svn.apache.org/viewcvs/db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/jdk16/statementJdbc20.out?rev=386169&view=auto
==============================================================================
--- db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/jdk16/statementJdbc20.out (added)
+++ db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/jdk16/statementJdbc20.out Wed Mar 15 13:31:53 2006
@@ -0,0 +1,27 @@
+Test statementJdbc20 starting
+PASS -- expected exception
+SQLSTATE(XJ065): java.sql.SQLException: Invalid parameter value '-1,000' for Statement.setFetchSize(int rows).
+PASS -- expected exception
+SQLSTATE(XJ064): java.sql.SQLException: Invalid parameter value '-1,000' for setFetchDirection(int direction).
+Fetch Size 25
+Fetch Direction 1001
+1 2 3.1
+Result Set Fetch Size 25
+Result Set Fetch Direction 1001
+PASS -- expected exception
+SQLSTATE(XJ061): java.sql.SQLException: The 'setFetchDirection()' method is only allowed on scroll cursors.
+Result Set Fetch Size 250
+Result Set Fetch Direction 1001
+PASS -- expected exception
+SQLSTATE(XJ062): java.sql.SQLException: Invalid parameter value '100' for ResultSet.setFetchSize(int rows).
+PASS -- expected exception
+SQLSTATE(XJ062): java.sql.SQLException: Invalid parameter value '-2,000' for ResultSet.setFetchSize(int rows).
+PASS -- expected exception
+SQLSTATE(XJ061): java.sql.SQLException: The 'setFetchDirection()' method is only allowed on scroll cursors.
+PASS -- expected exception
+SQLSTATE(X0Y78): java.sql.SQLException: Statement.executeQuery() cannot be called with a statement that returns a row count.
+PASS -- expected exception
+SQLSTATE(42X05): java.sql.SQLSyntaxErrorException: Table 'TRASH' does not exist.
+PASS -- expected exception
+SQLSTATE(X0Y79): java.sql.SQLException: Statement.executeUpdate() cannot be called with a statement that returns a ResultSet.
+Test statementJdbc20 finished

Added: db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/jdk16/statementJdbc30.out
URL: http://svn.apache.org/viewcvs/db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/jdk16/statementJdbc30.out?rev=386169&view=auto
==============================================================================
--- db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/jdk16/statementJdbc30.out (added)
+++ db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/jdk16/statementJdbc30.out Wed Mar 15 13:31:53 2006
@@ -0,0 +1,19 @@
+Test statementJdbc30 starting
+trying stmt.getMoreResults(int) :
+trying stmt.executeUpdate(String, int) :
+trying stmt.executeUpdate(String, int[]) :
+PASS -- expected exception
+SQLSTATE(0A000): java.sql.SQLException: Feature not implemented: executeUpdate(String, int[]).
+trying stmt.executeUpdate(String, String[]) :
+PASS -- expected exception
+SQLSTATE(0A000): java.sql.SQLException: Feature not implemented: executeUpdate(String, String[]).
+trying stmt.execute(String, int) :
+trying stmt.execute(String, int[]) :
+PASS -- expected exception
+SQLSTATE(0A000): java.sql.SQLException: Feature not implemented: execute(String, int[]).
+trying stmt.execute(String, String[]) :
+PASS -- expected exception
+SQLSTATE(0A000): java.sql.SQLException: Feature not implemented: execute(String, String[]).
+trying stmt.getResultSetHoldability() :
+trying stmt.getGeneratedKeys() :
+Test statementJdbc30 finished

Added: db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/jdk16/streamingColumn.out
URL: http://svn.apache.org/viewcvs/db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/jdk16/streamingColumn.out?rev=386169&view=auto
==============================================================================
--- db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/jdk16/streamingColumn.out (added)
+++ db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/jdk16/streamingColumn.out Wed Mar 15 13:31:53 2006
@@ -0,0 +1,165 @@
+Test streamingColumn starting
+===> testing extin/short.data length = 56
+No truncation and hence no error
+===> testing extin/shortbanner length = 8282
+No truncation and hence no error
+===> testing extin/derby.banner length = 414000
+expected exception for data > 32700 in length
+===> testing extin/empty.data length = 0
+No truncation and hence no error
+===> verified length 56
+===> verified length 8282
+===> verified length 0
+===> verified length 56
+===> verified length 8282
+===> verified length 0
+===> verified length 56
+===> verified length 8282
+===> verified length 0
+===> verified length 56
+===> verified length 8282
+===> verified length 0
+expect to get null string back
+a = -1 got null string back
+a = -1 got null string back
+===> testing extin/short.data length = 56
+===> testing extin/shortbanner length = 8282
+===> testing extin/derby.banner length = 414000
+===> testing extin/empty.data length = 0
+streamTest7
+Starting streamTest8(conn, 10, 2500)
+Finishing streamTest8(conn, 10, 2500)
+Starting streamTest9(conn, 10, 2500)
+Finishing streamTest9(conn, 10, 2500)
+Starting streamTest8(conn, 2500, 10)
+Finishing streamTest8(conn, 2500, 10)
+Starting streamTest9(conn, 2500, 10)
+Finishing streamTest9(conn, 2500, 10)
+Testing 10 starts from here
+===> testing extin/short.data length = 56
+No truncation and hence no error
+===> testing extin/shortbanner length = 8282
+No truncation and hence no error
+===> testing extin/derby.banner length = 414000
+expected exception for data > 32700 in length
+===> testing extin/empty.data length = 0
+No truncation and hence no error
+Testing 10 ends in here
+Test 11 - Can't pass negative length as the stream length for various setXXXStream methods
+===> testing using setAsciiStream with -2 as length
+PASS -- expected exception:java.sql.SQLException: Input stream cannot have negative length.
+===> testing using setCharacterStream with -1 as length
+PASS -- expected exception:java.sql.SQLException: Input stream cannot have negative length.
+===> testing using setBinaryStream with -1 as length
+PASS -- expected exception:java.sql.SQLException: Input stream cannot have negative length.
+Test 11 - negative stream length tests end in here
+Test 12 - varchar truncation tests start from here
+===> testing(using setAsciiStream) extin/char32675trailingblanks.data length = 32675
+No truncation and hence no error
+===> testing(using setCharacterStream) extin/char32675trailingblanks.data length = 32675
+No truncation and hence no error
+===> testing trailing blanks(using setString) length = 32675
+No truncation and hence no error
+===> testing trailing blanks(using setObject) length = 32675
+No truncation and hence no error
+===> testing trailing blanks using concatenation
+No truncation and hence no error.
+===> testing(using setAsciiStream) extin/char32675.data length = 32675
+expected exception for data > 32672 in length
+===> testing(using setCharacterStream) extin/char32675.data length = 32675
+expected exception for data > 32672 in length
+===> testing trailing non-blanks(using setString) length = 32675
+expected exception for data > 32672 in length
+===> testing trailing non-blanks(using setObject) length = 32675
+expected exception for data > 32672 in length
+===> testing trailing non-blank characters using concatenation
+expected exception for data > 32672 in length
+===> verified length 32672
+===> verified length 32672
+===> verified length 32672
+===> verified length 32672
+===> verified length 32672
+Test 12 - varchar truncation tests end in here
+Test 13 - long varchar truncation tests start from here
+===> testing(using setAsciiStream) extin/char32703trailingblanks.data length = 32703
+expected exception for data > 32700 in length
+===> testing(using setCharacterStream) extin/char32703trailingblanks.data length = 32703
+expected exception for data > 32700 in length
+===> testing trailing blanks(using setString) length = 32703
+expected exception for data > 32700 in length
+===> testing trailing blanks(using setObject) length = 32703
+expected exception for data > 32700 in length
+===> testing(using setAsciiStream) extin/char32703.data length = 32703
+expected exception for data > 32700 in length
+===> testing(using setCharacterStream) extin/char32703.data length = 32703
+expected exception for data > 32700 in length
+===> testing trailing non-blanks(using setString) length = 32703
+expected exception for data > 32700 in length
+===> testing trailing non-blanks(using setObject) length = 32703
+expected exception for data > 32700 in length
+Test 13 - long varchar truncation tests end in here
+Test 14 - clob truncation tests start from here
+===> testing(using setAsciiStream) extin/char32675trailingblanks.data length = 32675
+No truncation and hence no error
+===> testing(using setCharacterStream) extin/char32675trailingblanks.data length = 32675
+No truncation and hence no error
+===> testing trailing blanks(using setString) length = 32675
+No truncation and hence no error
+===> testing trailing blanks(using setObject) length = 32675
+No truncation and hence no error
+===> testing trailing blanks using concatenation
+No truncation and hence no error.
+===> testing(using setAsciiStream) extin/char32675.data length = 32675
+EXPECTED SQLSTATE(XSDA4): An unexpected exception was thrown
+EXPECTED SQLSTATE(XJ001): Java exception: 'A truncation error was encountered trying to shrink CLOB 'XXXX' to length 32672.: java.io.IOException'.
+===> testing(using setCharacterStream) extin/char32675.data length = 32675
+EXPECTED SQLSTATE(XSDA4): An unexpected exception was thrown
+EXPECTED SQLSTATE(XJ001): Java exception: 'A truncation error was encountered trying to shrink CLOB 'XXXX' to length 32672.: java.io.IOException'.
+===> testing trailing non-blanks(using setString) length = 32675
+expected exception for data > 32672 in length
+===> testing trailing non-blanks(using setObject) length = 32675
+expected exception for data > 32672 in length
+===> testing trailing non-blank characters using concatenation
+expected exception for data > 32672 in length
+===> verified length 32672
+===> verified length 32672
+===> verified length 32672
+===> verified length 32672
+===> verified length 32672
+Test 14 - clob truncation tests end in here
+======================================
+START  DERBY-500 TEST 
+Inserting rows 
+Rows inserted =10
+Rows selected =10
+Update qualifies many rows + streams
+EXPECTED EXCEPTION - streams cannot be re-used
+EXPECTED SQL Exception: (XSDA4) An unexpected exception was thrown
+EXPECTED SQL Exception: (XJ001) Java exception: 'Stream has already been read and end-of-file reached and cannot be re-used.: java.io.EOFException'.
+Rows selected =10
+DERBY500 #2 Rows updated  =1
+Rows selected =1
+DERBY500 #3 Rows deleted =10
+Rows selected =0
+DERBY500 #4 Rows deleted  =0
+Rows selected =0
+EXPECTED EXCEPTION - streams cannot be re-used
+EXPECTED SQL Exception: (XSDA4) An unexpected exception was thrown
+EXPECTED SQL Exception: (XJ001) Java exception: 'Stream has already been read and end-of-file reached and cannot be re-used.: java.io.EOFException'.
+END  DERBY-500 TEST 
+======================================
+======================================
+START  DERBY-500 TEST for varchar 
+Rows inserted =10
+Rows selected =10
+DERBY500 for varchar #1 Rows updated  =11
+Rows selected =10
+DERBY500 for varchar #2 Rows updated  =1
+Rows selected =1
+DERBY500 for varchar #3 Rows deleted =11
+Rows selected =0
+DERBY500 for varchar #4 Rows deleted  =0
+Rows selected =0
+END  DERBY-500 TEST  for varchar
+======================================
+Test streamingColumn finished



Mime
View raw message