db-derby-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Satheesh Bandaram <sathe...@Sourcery.Org>
Subject Re: [PATCH] (DERBY-123) Derby incorrectly rounds double values down during insert into NUMERIC
Date Wed, 09 Feb 2005 19:35:01 GMT
This patch is committed. I had to update 5 master files. Please note, in
the future, I will only commit patches when submitted along with test
cases and any updated test master files. (unless there is a strong
reason) It is very important to keep up changes to tests along with code
changes.

Satheesh

Sending        java\engine\org\apache\derby\iapi\types\SQLDecimal.java
Sending        java\engine\org\apache\derby\iapi\types\SQLDouble.java
Sending        java\engine\org\apache\derby\iapi\types\SQLReal.java
Sending        java\engine\org\apache\derby\iapi\types\UserType.java
Sending       
java\testing\org\apache\derbyTesting\functionTests\master\dml099.out
Sending       
java\testing\org\apache\derbyTesting\functionTests\master\ejbql.out
Sending       
java\testing\org\apache\derbyTesting\functionTests\master\floattypes.out
Sending       
java\testing\org\apache\derbyTesting\functionTests\master\outparams.out
Sending       
java\testing\org\apache\derbyTesting\functionTests\master\parameterMapping.out
Transmitting file data .........
Committed revision 153109.

[bandaram:satheesh]

Shreyas Kaushik wrote:

> thanks for the info Sateesh.
>
> ~ Shreyas
>
> Satheesh Bandaram wrote:
>
>> Shreyas,
>>
>> I am running tests with your changes. There appears to be at least 3
>> or 4 master files that need to be changed. In the future, it is
>> strongly recommended to submit patches along with master changes.
>> Since you seem to be running the tests, it is very trivial to update
>> masters and then submit a patch.
>>
>> Satheesh
>>
>> Shreyas Kaushik wrote:
>>
>>> Hi Sateesh,
>>>
>>>   I made changes and have some test failures. I am attaching the
>>> diffs and test results.
>>>
>>>   I did not have these failures with my previous fix.
>>>
>>>   If you feel that some of the changes might not be correct or
>>> changes may be required in
>>>   the master file, please make those chnages and submit the patch.
>>>
>>> thanks
>>> Shreyas
>>>
>>> ------------------------------------------------------------------------
>>>
>>>
>>> Index: java/engine/org/apache/derby/iapi/types/SQLReal.java
>>> ===================================================================
>>> --- java/engine/org/apache/derby/iapi/types/SQLReal.java   
>>> (revision 151674)
>>> +++ java/engine/org/apache/derby/iapi/types/SQLReal.java    (working
>>> copy)
>>> @@ -161,7 +161,7 @@
>>>     public BigDecimal    getBigDecimal()
>>>     {
>>>         if (isNull()) return null;
>>> -        return new BigDecimal(value);
>>> +        return new BigDecimal(Float.toString(value));
>>>     }
>>>
>>>     // for lack of a specification: 0 or null is false,
>>> Index: java/engine/org/apache/derby/iapi/types/SQLDecimal.java
>>> ===================================================================
>>> --- java/engine/org/apache/derby/iapi/types/SQLDecimal.java   
>>> (revision 151674)
>>> +++ java/engine/org/apache/derby/iapi/types/SQLDecimal.java   
>>> (working copy)
>>> @@ -371,7 +371,7 @@
>>>         }
>>>         else if (theValue instanceof Number)
>>>         {
>>> -            value = new BigDecimal(((Number)theValue).doubleValue());
>>> +            value = new
>>> BigDecimal(Double.toString(((Number)theValue).doubleValue()));
>>>         }
>>>         else
>>>         {
>>> @@ -720,7 +720,7 @@
>>>     }
>>>
>>>     private void setCoreValue(double theValue) {
>>> -        value = new BigDecimal(theValue);
>>> +        value = new BigDecimal(Double.toString(theValue));
>>>         rawData = null;
>>>     }
>>>
>>> Index: java/engine/org/apache/derby/iapi/types/UserType.java
>>> ===================================================================
>>> --- java/engine/org/apache/derby/iapi/types/UserType.java   
>>> (revision 151674)
>>> +++ java/engine/org/apache/derby/iapi/types/UserType.java   
>>> (working copy)
>>> @@ -195,7 +195,7 @@
>>>             if (value instanceof BigDecimal) return
>>> ((BigDecimal)value);
>>>
>>>             if (value instanceof Number)
>>> -                return new BigDecimal(((Number) value).doubleValue());
>>> +                return new BigDecimal(Double.toString(((Number)
>>> value).doubleValue()));
>>>         }
>>>         return super.getBigDecimal();
>>>     }
>>> Index: java/engine/org/apache/derby/iapi/types/SQLDouble.java
>>> ===================================================================
>>> --- java/engine/org/apache/derby/iapi/types/SQLDouble.java   
>>> (revision 151674)
>>> +++ java/engine/org/apache/derby/iapi/types/SQLDouble.java   
>>> (working copy)
>>> @@ -153,7 +153,7 @@
>>>     public BigDecimal    getBigDecimal()
>>>     {
>>>         if (isNull()) return null;
>>> -        return new BigDecimal(value);
>>> +        return new BigDecimal(Double.toString(value));
>>>     }
>>>
>>>     // for lack of a specification: getDouble()==0 gives true
>>>  
>>>
>>> ------------------------------------------------------------------------
>>>
>>>
>>> Generating report for RunSuite derbyall  null null null true
>>> ------------------ Java Information ------------------
>>> Java Version:    1.4.2
>>> Java Vendor:     Sun Microsystems Inc.
>>> Java home:       /java/j2sdk1.4.2/jre
>>> Java classpath: 
>>> /drivers/derby/trunk/tools/java/jakarta-oro-2.0.8.jar:/drivers/derby/trunk/classes
>>>
>>> OS name:         SunOS
>>> OS architecture: sparc
>>> OS version:      5.9
>>> Java user name:  sk149173
>>> Java user home:  /home/sk149173
>>> Java user dir:   /drivers/derby/trunk
>>> java.specification.name: Java Platform API Specification
>>> java.specification.version: 1.4
>>> --------- Derby Information --------
>>> JRE - JDBC: J2SE 1.4.2 - JDBC 3.0
>>> [/drivers/derby/trunk/classes] 10.1.0.0 alpha - (1)
>>> ------------------------------------------------------
>>> ----------------- Locale Information -----------------
>>> Current Locale :  [English/ [en]]
>>> Found support for locale: [de_DE]
>>>      version: 10.1.0.0 alpha - (1)
>>> Found support for locale: [es]
>>>      version: 10.1.0.0 alpha - (1)
>>> Found support for locale: [fr]
>>>      version: 10.1.0.0 alpha - (1)
>>> Found support for locale: [it]
>>>      version: 10.1.0.0 alpha - (1)
>>> Found support for locale: [ja_JP]
>>>      version: 10.1.0.0 alpha - (1)
>>> Found support for locale: [ko_KR]
>>>      version: 10.1.0.0 alpha - (1)
>>> Found support for locale: [pt_BR]
>>>      version: 10.1.0.0 alpha - (1)
>>> Found support for locale: [zh_CN]
>>>      version: 10.1.0.0 alpha - (1)
>>> Found support for locale: [zh_TW]
>>>      version: 10.1.0.0 alpha - (1)
>>> ------------------------------------------------------
>>> Test environment information:
>>> COMMAND LINE STYLE: jdk13
>>> TEST CANONS: master
>>> ------------------------------------------------------
>>> ------------------------------------------------------
>>> Summary results:
>>>
>>> Test Run Started: 2005-02-07 11:04:42.0
>>> Test Run Duration: 02:16:40
>>>
>>> 364 Tests Run
>>> 96% Pass (349 tests passed)
>>> 4% Fail (15 tests failed)
>>> 3 Suites skipped
>>> ------------------------------------------------------
>>> Failed tests in: derbyall_fail.txt
>>> ------------------------------------------------------
>>> Passed tests in: derbyall_pass.txt
>>> ------------------------------------------------------
>>> Skipped suites in: derbyall_skip.txt
>>> ------------------------------------------------------
>>> System properties in: derbyall_prop.txt
>>> ------------------------------------------------------
>>> ------------------------------------------------------
>>> Failure Details:
>>> ********* Diff file derbyall/derbylang/LOB.diff
>>> *** Start: LOB jdk1.4.2 derbyall:derbylang 2005-02-07 11:07:11 ***
>>> 69 del
>>> < ERROR 42X04: Column 'B.NCLOB' is not in any table in the FROM list
>>> or it appears within a join specification and is outside the scope
>>> of the join specification or it appears in a HAVING clause and is
>>> not in the GROUP BY list.  If this is a CREATE or ALTER TABLE
>>> statement then 'B.NCLOB' is not a column in the target table.
>>> 69a69
>>>  
>>>
>>>> ERROR 42X04: Column 'APP.B.NCLOB' is not in any table in the FROM
>>>> list or it appears within a join specification and is outside the
>>>> scope of the join specification or it appears in a HAVING clause
>>>> and is not in the GROUP BY list.  If this is a CREATE or ALTER
>>>> TABLE statement then 'APP.B.NCLOB' is not a column in the target
>>>> table.
>>>>   
>>>
>>> 120 del
>>> < ERROR 42X04: Column 'B.NCLOB' is not in any table in the FROM list
>>> or it appears within a join specification and is outside the scope
>>> of the join specification or it appears in a HAVING clause and is
>>> not in the GROUP BY list.  If this is a CREATE or ALTER TABLE
>>> statement then 'B.NCLOB' is not a column in the target table.
>>> 120a120
>>>  
>>>
>>>> ERROR 42X04: Column 'APP.B.NCLOB' is not in any table in the FROM
>>>> list or it appears within a join specification and is outside the
>>>> scope of the join specification or it appears in a HAVING clause
>>>> and is not in the GROUP BY list.  If this is a CREATE or ALTER
>>>> TABLE statement then 'APP.B.NCLOB' is not a column in the target
>>>> table.
>>>>   
>>>
>>> 127 del
>>> < ERROR 42X04: Column 'B.NCLOB' is not in any table in the FROM list
>>> or it appears within a join specification and is outside the scope
>>> of the join specification or it appears in a HAVING clause and is
>>> not in the GROUP BY list.  If this is a CREATE or ALTER TABLE
>>> statement then 'B.NCLOB' is not a column in the target table.
>>> 127a127
>>>  
>>>
>>>> ERROR 42X04: Column 'APP.B.NCLOB' is not in any table in the FROM
>>>> list or it appears within a join specification and is outside the
>>>> scope of the join specification or it appears in a HAVING clause
>>>> and is not in the GROUP BY list.  If this is a CREATE or ALTER
>>>> TABLE statement then 'APP.B.NCLOB' is not a column in the target
>>>> table.
>>>>   
>>>
>>> Test Failed.
>>> *** End:   LOB jdk1.4.2 derbyall:derbylang 2005-02-07 11:07:42 ***
>>> ********* Diff file derbyall/derbylang/ejbql.diff
>>> *** Start: ejbql jdk1.4.2 derbyall:derbylang 2005-02-07 11:29:16 ***
>>> 871 del
>>> < 1000000000000000019884624838656 872 del
>>> < -1000000000000000019884624838656
>>> 872a871,872
>>>  
>>>
>>>> 1000000000000000000000000000000 -1000000000000000000000000000000
>>>>   
>>>
>>> 884 del
>>> < -1000000000000000019884624838656
>>> 885 del
>>> < 1000000000000000019884624838656 885a884,885
>>>  
>>>
>>>> -1000000000000000000000000000000
>>>> 1000000000000000000000000000000   
>>>
>>> 894 del
>>> < 0.1000000000000000055511151231257 895 del
>>> < -0.1000000000000000055511151231257
>>> 895a894,895
>>>  
>>>
>>>> 0.1000000000000000000000000000000 -0.1000000000000000000000000000000
>>>>   
>>>
>>> 907 del
>>> < -0.1000000000000000055511151231257
>>> 908 del
>>> < 0.1000000000000000055511151231257 908a907,908
>>>  
>>>
>>>> -0.1000000000000000000000000000000
>>>> 0.1000000000000000000000000000000   
>>>
>>> 923 del
>>> < 1000000000000000019884624838656 924 del
>>> < 1000000000000000019884624838656 924a923,924
>>>  
>>>
>>>> 1000000000000000000000000000000 1000000000000000000000000000000   
>>>
>>> 936 del
>>> < 1000000000000000019884624838656 937 del
>>> < 1000000000000000019884624838656 937a936,937
>>>  
>>>
>>>> 1000000000000000000000000000000 1000000000000000000000000000000   
>>>
>>> 949 del
>>> < -1000000000000000019884624838656
>>> 950 del
>>> < -1000000000000000019884624838656
>>> 950a949,950
>>>  
>>>
>>>> -1000000000000000000000000000000
>>>> -1000000000000000000000000000000
>>>>   
>>>
>>> 962 del
>>> < 1000000000000000019884624838656 963 del
>>> < 1000000000000000019884624838656 963a962,963
>>>  
>>>
>>>> 1000000000000000000000000000000 1000000000000000000000000000000   
>>>
>>> 975 del
>>> < 1000000000000000019884624838656 976 del
>>> < 1000000000000000019884624838656 976a975,976
>>>  
>>>
>>>> 1000000000000000000000000000000 1000000000000000000000000000000   
>>>
>>> 983 del
>>> < 1000000000000000019884624838656 983a983
>>>  
>>>
>>>> 1000000000000000000000000000000   
>>>
>>> 993 del
>>> < 0.1000000000000000055511151231257 994 del
>>> < 0.1000000000000000055511151231257 994a993,994
>>>  
>>>
>>>> 0.1000000000000000000000000000000 0.1000000000000000000000000000000   
>>>
>>> 1006 del
>>> < 0.1000000000000000055511151231257 1007 del
>>> < 0.1000000000000000055511151231257 1007a1006,1007
>>>  
>>>
>>>> 0.1000000000000000000000000000000 0.1000000000000000000000000000000   
>>>
>>> 1019 del
>>> < -0.1000000000000000055511151231257
>>> 1020 del
>>> < -0.1000000000000000055511151231257
>>> 1020a1019,1020
>>>  
>>>
>>>> -0.1000000000000000000000000000000
>>>> -0.1000000000000000000000000000000
>>>>   
>>>
>>> 1032 del
>>> < 0.1000000000000000055511151231257 1033 del
>>> < 0.1000000000000000055511151231257 1033a1032,1033
>>>  
>>>
>>>> 0.1000000000000000000000000000000 0.1000000000000000000000000000000   
>>>
>>> 1045 del
>>> < 0.1000000000000000055511151231257 1046 del
>>> < 0.1000000000000000055511151231257 1046a1045,1046
>>>  
>>>
>>>> 0.1000000000000000000000000000000 0.1000000000000000000000000000000   
>>>
>>> 1055 del
>>> < 0.1000000000000000055511151231257 1055a1055
>>>  
>>>
>>>> 0.1000000000000000000000000000000   
>>>
>>> 1069 del
>>> < 1000000000000000019884624838657 1070 del
>>> < 1000000000000000019884624838657 1070a1069,1070
>>>  
>>>
>>>> 1000000000000000000000000000001 1000000000000000000000000000001   
>>>
>>> Test Failed.
>>> *** End:   ejbql jdk1.4.2 derbyall:derbylang 2005-02-07 11:30:06 ***
>>> ********* Diff file derbyall/derbylang/floattypes.diff
>>> *** Start: floattypes jdk1.4.2 derbyall:derbylang 2005-02-07
>>> 11:31:28 ***
>>> 609 del
>>> < 1700000000000000118246355238912 609a609
>>>  
>>>
>>>> 1700000000000000000000000000000   
>>>
>>> Test Failed.
>>> *** End:   floattypes jdk1.4.2 derbyall:derbylang 2005-02-07
>>> 11:32:08 ***
>>> ********* Diff file derbyall/derbylang/groupBy.diff
>>> *** Start: groupBy jdk1.4.2 derbyall:derbylang 2005-02-07 11:33:19 ***
>>> 40 del
>>> < ERROR 42X04: Column 'B.O' is not in any table in the FROM list or
>>> it appears within a join specification and is outside the scope of
>>> the join specification or it appears in a HAVING clause and is not
>>> in the GROUP BY list.  If this is a CREATE or ALTER TABLE statement
>>> then 'B.O' is not a column in the target table.
>>> 40a40
>>>  
>>>
>>>> ERROR 42X04: Column 'APP.B.O' is not in any table in the FROM list
>>>> or it appears within a join specification and is outside the scope
>>>> of the join specification or it appears in a HAVING clause and is
>>>> not in the GROUP BY list.  If this is a CREATE or ALTER TABLE
>>>> statement then 'APP.B.O' is not a column in the target table.
>>>>   
>>>
>>> 565 del
>>> < ERROR 42Y35: Column reference 'T1.C1' is invalid. When the SELECT
>>> list contains at least 1 aggregate then all entries must be valid
>>> aggregate expressions.
>>> 565a565
>>>  
>>>
>>>> ERROR 42Y35: Column reference 'APP.T1.C1' is invalid. When the
>>>> SELECT list contains at least 1 aggregate then all entries must be
>>>> valid aggregate expressions.
>>>>   
>>>
>>> 591 del
>>> < ERROR 42Y35: Column reference 'T1.C1' is invalid. When the SELECT
>>> list contains at least 1 aggregate then all entries must be valid
>>> aggregate expressions.
>>> 591a591
>>>  
>>>
>>>> ERROR 42Y35: Column reference 'APP.T1.C1' is invalid. When the
>>>> SELECT list contains at least 1 aggregate then all entries must be
>>>> valid aggregate expressions.
>>>>   
>>>
>>> 600 del
>>> < ERROR 42Y35: Column reference 'T1.C1' is invalid. When the SELECT
>>> list contains at least 1 aggregate then all entries must be valid
>>> aggregate expressions.
>>> 600a600
>>>  
>>>
>>>> ERROR 42Y35: Column reference 'APP.T1.C1' is invalid. When the
>>>> SELECT list contains at least 1 aggregate then all entries must be
>>>> valid aggregate expressions.
>>>>   
>>>
>>> 606 del
>>> < ERROR 42Y35: Column reference 'T1.C1' is invalid. When the SELECT
>>> list contains at least 1 aggregate then all entries must be valid
>>> aggregate expressions.
>>> 606a606
>>>  
>>>
>>>> ERROR 42Y35: Column reference 'APP.T1.C1' is invalid. When the
>>>> SELECT list contains at least 1 aggregate then all entries must be
>>>> valid aggregate expressions.
>>>>   
>>>
>>> Test Failed.
>>> *** End:   groupBy jdk1.4.2 derbyall:derbylang 2005-02-07 11:33:42 ***
>>> ********* Diff file derbyall/derbylang/innerjoin.diff
>>> *** Start: innerjoin jdk1.4.2 derbyall:derbylang 2005-02-07 11:36:57
>>> ***
>>> 36 del
>>> < ERROR 42X03: Column name 'T1.C1' is in more than one table in the
>>> FROM list.
>>> 36a36
>>>  
>>>
>>>> ERROR 42X03: Column name 'APP.T1.C1' is in more than one table in
>>>> the FROM list.
>>>>   
>>>
>>> 39 del
>>> < ERROR 42X03: Column name 'T1.C1' is in more than one table in the
>>> FROM list.
>>> 39a39
>>>  
>>>
>>>> ERROR 42X03: Column name 'APP.T1.C1' is in more than one table in
>>>> the FROM list.
>>>>   
>>>
>>> 41 del
>>> < ERROR 42X03: Column name 'T1.C1' is in more than one table in the
>>> FROM list.
>>> 41a41
>>>  
>>>
>>>> ERROR 42X03: Column name 'APP.T1.C1' is in more than one table in
>>>> the FROM list.
>>>>   
>>>
>>> Test Failed.
>>> *** End:   innerjoin jdk1.4.2 derbyall:derbylang 2005-02-07 11:37:13
>>> ***
>>> ********* Diff file derbyall/derbylang/orderby.diff
>>> *** Start: orderby jdk1.4.2 derbyall:derbylang 2005-02-07 11:47:32 ***
>>> 463,464d462
>>> < ERROR 42X10: 'SYS.T1' is not an exposed table name in the scope in
>>> which it appears.
>>> < ij> select c1 from app.t1 order by sys.t1.c1;
>>> 465a464,465
>>>  
>>>
>>>> ij> select c1 from app.t1 order by sys.t1.c1;
>>>> ERROR 42X04: Column 'SYS.T1.C1' is not in any table in the FROM
>>>> list or it appears within a join specification and is outside the
>>>> scope of the join specification or it appears in a HAVING clause
>>>> and is not in the GROUP BY list.  If this is a CREATE or ALTER
>>>> TABLE statement then 'SYS.T1.C1' is not a column in the target table.
>>>>   
>>>
>>> 472 del
>>> < ERROR 42X04: Column 'T1.A' is not in any table in the FROM list or
>>> it appears within a join specification and is outside the scope of
>>> the join specification or it appears in a HAVING clause and is not
>>> in the GROUP BY list.  If this is a CREATE or ALTER TABLE statement
>>> then 'T1.A' is not a column in the target table.
>>> 472a472
>>>  
>>>
>>>> ERROR 42X04: Column 'APP.T1.A' is not in any table in the FROM list
>>>> or it appears within a join specification and is outside the scope
>>>> of the join specification or it appears in a HAVING clause and is
>>>> not in the GROUP BY list.  If this is a CREATE or ALTER TABLE
>>>> statement then 'APP.T1.A' is not a column in the target table.
>>>>   
>>>
>>> 475 del
>>> < ERROR 42X04: Column 'T3.C1' is not in any table in the FROM list
>>> or it appears within a join specification and is outside the scope
>>> of the join specification or it appears in a HAVING clause and is
>>> not in the GROUP BY list.  If this is a CREATE or ALTER TABLE
>>> statement then 'T3.C1' is not a column in the target table.
>>> 475a475
>>>  
>>>
>>>> ERROR 42X04: Column 'APP.T3.C1' is not in any table in the FROM
>>>> list or it appears within a join specification and is outside the
>>>> scope of the join specification or it appears in a HAVING clause
>>>> and is not in the GROUP BY list.  If this is a CREATE or ALTER
>>>> TABLE statement then 'APP.T3.C1' is not a column in the target table.
>>>>   
>>>
>>> 872 del
>>> < ERROR 42X04: Column 'T.D' is not in any table in the FROM list or
>>> it appears within a join specification and is outside the scope of
>>> the join specification or it appears in a HAVING clause and is not
>>> in the GROUP BY list.  If this is a CREATE or ALTER TABLE statement
>>> then 'T.D' is not a column in the target table.
>>> 872a872
>>>  
>>>
>>>> ERROR 42X04: Column 'APP.T.D' is not in any table in the FROM list
>>>> or it appears within a join specification and is outside the scope
>>>> of the join specification or it appears in a HAVING clause and is
>>>> not in the GROUP BY list.  If this is a CREATE or ALTER TABLE
>>>> statement then 'APP.T.D' is not a column in the target table.
>>>>   
>>>
>>> 886 del
>>> < ERROR 42X04: Column 'T.D' is not in any table in the FROM list or
>>> it appears within a join specification and is outside the scope of
>>> the join specification or it appears in a HAVING clause and is not
>>> in the GROUP BY list.  If this is a CREATE or ALTER TABLE statement
>>> then 'T.D' is not a column in the target table.
>>> 886a886
>>>  
>>>
>>>> ERROR 42X04: Column 'APP.T.D' is not in any table in the FROM list
>>>> or it appears within a join specification and is outside the scope
>>>> of the join specification or it appears in a HAVING clause and is
>>>> not in the GROUP BY list.  If this is a CREATE or ALTER TABLE
>>>> statement then 'APP.T.D' is not a column in the target table.
>>>>   
>>>
>>> 894 del
>>> < ERROR 42X04: Column 'T.D' is not in any table in the FROM list or
>>> it appears within a join specification and is outside the scope of
>>> the join specification or it appears in a HAVING clause and is not
>>> in the GROUP BY list.  If this is a CREATE or ALTER TABLE statement
>>> then 'T.D' is not a column in the target table.
>>> 894a894
>>>  
>>>
>>>> ERROR 42X04: Column 'APP.T.D' is not in any table in the FROM list
>>>> or it appears within a join specification and is outside the scope
>>>> of the join specification or it appears in a HAVING clause and is
>>>> not in the GROUP BY list.  If this is a CREATE or ALTER TABLE
>>>> statement then 'APP.T.D' is not a column in the target table.
>>>>   
>>>
>>> Test Failed.
>>> *** End:   orderby jdk1.4.2 derbyall:derbylang 2005-02-07 11:47:58 ***
>>> ********* Diff file derbyall/derbylang/outerjoin.diff
>>> *** Start: outerjoin jdk1.4.2 derbyall:derbylang 2005-02-07 11:48:28
>>> ***
>>> 1878 del
>>> < ERROR 42X03: Column name 'TTAB1.A' is in more than one table in
>>> the FROM list.
>>> 1878a1878
>>>  
>>>
>>>> ERROR 42X03: Column name 'APP.TTAB1.A' is in more than one table in
>>>> the FROM list.
>>>>   
>>>
>>> Test Failed.
>>> *** End:   outerjoin jdk1.4.2 derbyall:derbylang 2005-02-07 11:49:05
>>> ***
>>> ********* Diff file derbyall/derbylang/outparams.diff
>>> *** Start: outparams jdk1.4.2 derbyall:derbylang 2005-02-07 11:49:07
>>> ***
>>> 949 del
>>> <             getBigDecimal(1) = 2
>>> 950 del
>>> <             getBigDecimal(1) = 2
>>> 950a949,950
>>>  
>>>
>>>>             getBigDecimal(1) = 2.0
>>>>             getBigDecimal(1) = 2.0
>>>>   
>>>
>>> 973 del
>>> <             getBigDecimal(1) = 2
>>> 974 del
>>> <             getBigDecimal(1) = 2
>>> 974a973,974
>>>  
>>>
>>>>             getBigDecimal(1) = 2.0
>>>>             getBigDecimal(1) = 2.0
>>>>   
>>>
>>> 997 del
>>> <             getBigDecimal(1) = 12
>>> 998 del
>>> <             getBigDecimal(1) = 12
>>> 998a997,998
>>>  
>>>
>>>>             getBigDecimal(1) = 12.0
>>>>             getBigDecimal(1) = 12.0
>>>>   
>>>
>>> 1021 del
>>> <             getBigDecimal(1) = 132
>>> 1022 del
>>> <             getBigDecimal(1) = 132
>>> 1022a1021,1022
>>>  
>>>
>>>>             getBigDecimal(1) = 132.0
>>>>             getBigDecimal(1) = 132.0
>>>>   
>>>
>>> 1045 del
>>> <             getBigDecimal(1) = 1332
>>> 1046 del
>>> <             getBigDecimal(1) = 1332
>>> 1046a1045,1046
>>>  
>>>
>>>>             getBigDecimal(1) = 1332.0
>>>>             getBigDecimal(1) = 1332.0
>>>>   
>>>
>>> 1069 del
>>> <             getBigDecimal(1) = 1332
>>> 1070 del
>>> <             getBigDecimal(1) = 1332
>>> 1070a1069,1070
>>>  
>>>
>>>>             getBigDecimal(1) = 1332.0
>>>>             getBigDecimal(1) = 1332.0
>>>>   
>>>
>>> 1093 del
>>> <             getBigDecimal(1) = 1332
>>> 1094 del
>>> <             getBigDecimal(1) = 1332
>>> 1094a1093,1094
>>>  
>>>
>>>>             getBigDecimal(1) = 1332.0
>>>>             getBigDecimal(1) = 1332.0
>>>>   
>>>
>>> 1117 del
>>> <             getBigDecimal(1) = 1332
>>> 1118 del
>>> <             getBigDecimal(1) = 1332
>>> 1118a1117,1118
>>>  
>>>
>>>>             getBigDecimal(1) = 1332.0
>>>>             getBigDecimal(1) = 1332.0
>>>>   
>>>
>>> 1141 del
>>> <             getBigDecimal(1) = 1332
>>> 1142 del
>>> <             getBigDecimal(1) = 1332
>>> 1142a1141,1142
>>>  
>>>
>>>>             getBigDecimal(1) = 1332.0
>>>>             getBigDecimal(1) = 1332.0
>>>>   
>>>
>>> 1165 del
>>> <             getBigDecimal(1) = 1333.33203125
>>> 1166 del
>>> <             getBigDecimal(1) = 1333.33203125
>>> 1166a1165,1166
>>>  
>>>
>>>>             getBigDecimal(1) = 1333.332
>>>>             getBigDecimal(1) = 1333.332
>>>>   
>>>
>>> 1189 del
>>> <             getBigDecimal(1) = 1333.33203125
>>> 1190 del
>>> <             getBigDecimal(1) = 1333.33203125
>>> 1190a1189,1190
>>>  
>>>
>>>>             getBigDecimal(1) = 1333.332
>>>>             getBigDecimal(1) = 1333.332
>>>>   
>>>
>>> 1238 del
>>> <             getBigDecimal(1) = 2
>>> 1239 del
>>> <             getBigDecimal(1) = 2
>>> 1239a1238,1239
>>>  
>>>
>>>>             getBigDecimal(1) = 2.0
>>>>             getBigDecimal(1) = 2.0
>>>>   
>>>
>>> 1262 del
>>> <             getBigDecimal(1) = 2
>>> 1263 del
>>> <             getBigDecimal(1) = 2
>>> 1263a1262,1263
>>>  
>>>
>>>>             getBigDecimal(1) = 2.0
>>>>             getBigDecimal(1) = 2.0
>>>>   
>>>
>>> 1286 del
>>> <             getBigDecimal(1) = 12
>>> 1287 del
>>> <             getBigDecimal(1) = 12
>>> 1287a1286,1287
>>>  
>>>
>>>>             getBigDecimal(1) = 12.0
>>>>             getBigDecimal(1) = 12.0
>>>>   
>>>
>>> 1310 del
>>> <             getBigDecimal(1) = 132
>>> 1311 del
>>> <             getBigDecimal(1) = 132
>>> 1311a1310,1311
>>>  
>>>
>>>>             getBigDecimal(1) = 132.0
>>>>             getBigDecimal(1) = 132.0
>>>>   
>>>
>>> 1334 del
>>> <             getBigDecimal(1) = 1332
>>> 1335 del
>>> <             getBigDecimal(1) = 1332
>>> 1335a1334,1335
>>>  
>>>
>>>>             getBigDecimal(1) = 1332.0
>>>>             getBigDecimal(1) = 1332.0
>>>>   
>>>
>>> 1358 del
>>> <             getBigDecimal(1) = 1332
>>> 1359 del
>>> <             getBigDecimal(1) = 1332
>>> 1359a1358,1359
>>>  
>>>
>>>>             getBigDecimal(1) = 1332.0
>>>>             getBigDecimal(1) = 1332.0
>>>>   
>>>
>>> 1382 del
>>> <             getBigDecimal(1) = 1332
>>> 1383 del
>>> <             getBigDecimal(1) = 1332
>>> 1383a1382,1383
>>>  
>>>
>>>>             getBigDecimal(1) = 1332.0
>>>>             getBigDecimal(1) = 1332.0
>>>>   
>>>
>>> 1406 del
>>> <             getBigDecimal(1) = 1332
>>> 1407 del
>>> <             getBigDecimal(1) = 1332
>>> 1407a1406,1407
>>>  
>>>
>>>>             getBigDecimal(1) = 1332.0
>>>>             getBigDecimal(1) = 1332.0
>>>>   
>>>
>>> 1430 del
>>> <             getBigDecimal(1) = 1332
>>> 1431 del
>>> <             getBigDecimal(1) = 1332
>>> 1431a1430,1431
>>>  
>>>
>>>>             getBigDecimal(1) = 1332.0
>>>>             getBigDecimal(1) = 1332.0
>>>>   
>>>
>>> 1454 del
>>> <             getBigDecimal(1) =
>>> 1333.332000000000107320374809205532073974609375
>>> 1455 del
>>> <             getBigDecimal(1) =
>>> 1333.332000000000107320374809205532073974609375
>>> 1455a1454,1455
>>>  
>>>
>>>>             getBigDecimal(1) = 1333.332
>>>>             getBigDecimal(1) = 1333.332
>>>>   
>>>
>>> 1478 del
>>> <             getBigDecimal(1) =
>>> 1333.332000000000107320374809205532073974609375
>>> 1479 del
>>> <             getBigDecimal(1) =
>>> 1333.332000000000107320374809205532073974609375
>>> 1479a1478,1479
>>>  
>>>
>>>>             getBigDecimal(1) = 1333.332
>>>>             getBigDecimal(1) = 1333.332
>>>>   
>>>
>>> 3509 del
>>> <             getBigDecimal(1) = 2
>>> 3510 del
>>> <             getBigDecimal(1) = 2
>>> 3510a3509,3510
>>>  
>>>
>>>>             getBigDecimal(1) = 2.0
>>>>             getBigDecimal(1) = 2.0
>>>>   
>>>
>>> 3533 del
>>> <             getBigDecimal(1) = 2
>>> 3534 del
>>> <             getBigDecimal(1) = 2
>>> 3534a3533,3534
>>>  
>>>
>>>>             getBigDecimal(1) = 2.0
>>>>             getBigDecimal(1) = 2.0
>>>>   
>>>
>>> 3557 del
>>> <             getBigDecimal(1) = 12
>>> 3558 del
>>> <             getBigDecimal(1) = 12
>>> 3558a3557,3558
>>>  
>>>
>>>>             getBigDecimal(1) = 12.0
>>>>             getBigDecimal(1) = 12.0
>>>>   
>>>
>>> 3581 del
>>> <             getBigDecimal(1) = 132
>>> 3582 del
>>> <             getBigDecimal(1) = 132
>>> 3582a3581,3582
>>>  
>>>
>>>>             getBigDecimal(1) = 132.0
>>>>             getBigDecimal(1) = 132.0
>>>>   
>>>
>>> 3605 del
>>> <             getBigDecimal(1) = 1332
>>> 3606 del
>>> <             getBigDecimal(1) = 1332
>>> 3606a3605,3606
>>>  
>>>
>>>>             getBigDecimal(1) = 1332.0
>>>>             getBigDecimal(1) = 1332.0
>>>>   
>>>
>>> 3629 del
>>> <             getBigDecimal(1) = 1332
>>> 3630 del
>>> <             getBigDecimal(1) = 1332
>>> 3630a3629,3630
>>>  
>>>
>>>>             getBigDecimal(1) = 1332.0
>>>>             getBigDecimal(1) = 1332.0
>>>>   
>>>
>>> 3653 del
>>> <             getBigDecimal(1) = 1332
>>> 3654 del
>>> <             getBigDecimal(1) = 1332
>>> 3654a3653,3654
>>>  
>>>
>>>>             getBigDecimal(1) = 1332.0
>>>>             getBigDecimal(1) = 1332.0
>>>>   
>>>
>>> 3677 del
>>> <             getBigDecimal(1) = 1332
>>> 3678 del
>>> <             getBigDecimal(1) = 1332
>>> 3678a3677,3678
>>>  
>>>
>>>>             getBigDecimal(1) = 1332.0
>>>>             getBigDecimal(1) = 1332.0
>>>>   
>>>
>>> 3701 del
>>> <             getBigDecimal(1) = 1332
>>> 3702 del
>>> <             getBigDecimal(1) = 1332
>>> 3702a3701,3702
>>>  
>>>
>>>>             getBigDecimal(1) = 1332.0
>>>>             getBigDecimal(1) = 1332.0
>>>>   
>>>
>>> 3725 del
>>> <             getBigDecimal(1) = 1333.33203125
>>> 3726 del
>>> <             getBigDecimal(1) = 1333.33203125
>>> 3726a3725,3726
>>>  
>>>
>>>>             getBigDecimal(1) = 1333.332
>>>>             getBigDecimal(1) = 1333.332
>>>>   
>>>
>>> 3749 del
>>> <             getBigDecimal(1) = 1333.33203125
>>> 3750 del
>>> <             getBigDecimal(1) = 1333.33203125
>>> 3750a3749,3750
>>>  
>>>
>>>>             getBigDecimal(1) = 1333.332
>>>>             getBigDecimal(1) = 1333.332
>>>>   
>>>
>>> 3798 del
>>> <             getBigDecimal(1) = 2
>>> 3799 del
>>> <             getBigDecimal(1) = 2
>>> 3799a3798,3799
>>>  
>>>
>>>>             getBigDecimal(1) = 2.0
>>>>             getBigDecimal(1) = 2.0
>>>>   
>>>
>>> 3822 del
>>> <             getBigDecimal(1) = 2
>>> 3823 del
>>> <             getBigDecimal(1) = 2
>>> 3823a3822,3823
>>>  
>>>
>>>>             getBigDecimal(1) = 2.0
>>>>             getBigDecimal(1) = 2.0
>>>>   
>>>
>>> 3846 del
>>> <             getBigDecimal(1) = 12
>>> 3847 del
>>> <             getBigDecimal(1) = 12
>>> 3847a3846,3847
>>>  
>>>
>>>>             getBigDecimal(1) = 12.0
>>>>             getBigDecimal(1) = 12.0
>>>>   
>>>
>>> 3870 del
>>> <             getBigDecimal(1) = 132
>>> 3871 del
>>> <             getBigDecimal(1) = 132
>>> 3871a3870,3871
>>>  
>>>
>>>>             getBigDecimal(1) = 132.0
>>>>             getBigDecimal(1) = 132.0
>>>>   
>>>
>>> 3894 del
>>> <             getBigDecimal(1) = 1332
>>> 3895 del
>>> <             getBigDecimal(1) = 1332
>>> 3895a3894,3895
>>>  
>>>
>>>>             getBigDecimal(1) = 1332.0
>>>>             getBigDecimal(1) = 1332.0
>>>>   
>>>
>>> 3918 del
>>> <             getBigDecimal(1) = 1332
>>> 3919 del
>>> <             getBigDecimal(1) = 1332
>>> 3919a3918,3919
>>>  
>>>
>>>>             getBigDecimal(1) = 1332.0
>>>>             getBigDecimal(1) = 1332.0
>>>>   
>>>
>>> 3942 del
>>> <             getBigDecimal(1) = 1332
>>> 3943 del
>>> <             getBigDecimal(1) = 1332
>>> 3943a3942,3943
>>>  
>>>
>>>>             getBigDecimal(1) = 1332.0
>>>>             getBigDecimal(1) = 1332.0
>>>>   
>>>
>>> 3966 del
>>> <             getBigDecimal(1) = 1332
>>> 3967 del
>>> <             getBigDecimal(1) = 1332
>>> 3967a3966,3967
>>>  
>>>
>>>>             getBigDecimal(1) = 1332.0
>>>>             getBigDecimal(1) = 1332.0
>>>>   
>>>
>>> 3990 del
>>> <             getBigDecimal(1) = 1332
>>> 3991 del
>>> <             getBigDecimal(1) = 1332
>>> 3991a3990,3991
>>>  
>>>
>>>>             getBigDecimal(1) = 1332.0
>>>>             getBigDecimal(1) = 1332.0
>>>>   
>>>
>>> 4014 del
>>> <             getBigDecimal(1) =
>>> 1333.332000000000107320374809205532073974609375
>>> 4015 del
>>> <             getBigDecimal(1) =
>>> 1333.332000000000107320374809205532073974609375
>>> 4015a4014,4015
>>>  
>>>
>>>>             getBigDecimal(1) = 1333.332
>>>>             getBigDecimal(1) = 1333.332
>>>>   
>>>
>>> 4038 del
>>> <             getBigDecimal(1) =
>>> 1333.332000000000107320374809205532073974609375
>>> 4039 del
>>> <             getBigDecimal(1) =
>>> 1333.332000000000107320374809205532073974609375
>>> 4039a4038,4039
>>>  
>>>
>>>>             getBigDecimal(1) = 1333.332
>>>>             getBigDecimal(1) = 1333.332
>>>>   
>>>
>>> 6429 del
>>> <             getBigDecimal(1) = 666
>>> 6430 del
>>> <             getBigDecimal(1) = 666
>>> 6430a6429,6430
>>>  
>>>
>>>>             getBigDecimal(1) = 666.0
>>>>             getBigDecimal(1) = 666.0
>>>>   
>>>
>>> 6452 del
>>> <             getBigDecimal(1) = 666
>>> 6453 del
>>> <             getBigDecimal(1) = 666
>>> 6453a6452,6453
>>>  
>>>
>>>>             getBigDecimal(1) = 666.0
>>>>             getBigDecimal(1) = 666.0
>>>>   
>>>
>>> 6475 del
>>> <             getBigDecimal(1) = 666
>>> 6476 del
>>> <             getBigDecimal(1) = 666
>>> 6476a6475,6476
>>>  
>>>
>>>>             getBigDecimal(1) = 666.0
>>>>             getBigDecimal(1) = 666.0
>>>>   
>>>
>>> 6498 del
>>> <             getBigDecimal(1) = 666
>>> 6499 del
>>> <             getBigDecimal(1) = 666
>>> 6499a6498,6499
>>>  
>>>
>>>>             getBigDecimal(1) = 666.0
>>>>             getBigDecimal(1) = 666.0
>>>>   
>>>
>>> 6521 del
>>> <             getBigDecimal(1) = 666
>>> 6522 del
>>> <             getBigDecimal(1) = 666
>>> 6522a6521,6522
>>>  
>>>
>>>>             getBigDecimal(1) = 666.0
>>>>             getBigDecimal(1) = 666.0
>>>>   
>>>
>>> 6544 del
>>> <             getBigDecimal(1) = 666
>>> 6545 del
>>> <             getBigDecimal(1) = 666
>>> 6545a6544,6545
>>>  
>>>
>>>>             getBigDecimal(1) = 666.0
>>>>             getBigDecimal(1) = 666.0
>>>>   
>>>
>>> 6567 del
>>> <             getBigDecimal(1) = 666
>>> 6568 del
>>> <             getBigDecimal(1) = 666
>>> 6568a6567,6568
>>>  
>>>
>>>>             getBigDecimal(1) = 666.0
>>>>             getBigDecimal(1) = 666.0
>>>>   
>>>
>>> 6590 del
>>> <             getBigDecimal(1) = 666
>>> 6591 del
>>> <             getBigDecimal(1) = 666
>>> 6591a6590,6591
>>>  
>>>
>>>>             getBigDecimal(1) = 666.0
>>>>             getBigDecimal(1) = 666.0
>>>>   
>>>
>>> 6613 del
>>> <             getBigDecimal(1) = 666
>>> 6614 del
>>> <             getBigDecimal(1) = 666
>>> 6614a6613,6614
>>>  
>>>
>>>>             getBigDecimal(1) = 666.0
>>>>             getBigDecimal(1) = 666.0
>>>>   
>>>
>>> 6636 del
>>> <             getBigDecimal(1) = 666
>>> 6637 del
>>> <             getBigDecimal(1) = 666
>>> 6637a6636,6637
>>>  
>>>
>>>>             getBigDecimal(1) = 666.0
>>>>             getBigDecimal(1) = 666.0
>>>>   
>>>
>>> 6659 del
>>> <             getBigDecimal(1) = 666
>>> 6660 del
>>> <             getBigDecimal(1) = 666
>>> 6660a6659,6660
>>>  
>>>
>>>>             getBigDecimal(1) = 666.0
>>>>             getBigDecimal(1) = 666.0
>>>>   
>>>
>>> 6682 del
>>> <             getBigDecimal(1) = 666
>>> 6683 del
>>> <             getBigDecimal(1) = 666
>>> 6683a6682,6683
>>>  
>>>
>>>>             getBigDecimal(1) = 666.0
>>>>             getBigDecimal(1) = 666.0
>>>>   
>>>
>>> 6705 del
>>> <             getBigDecimal(1) = 666
>>> 6706 del
>>> <             getBigDecimal(1) = 666
>>> 6706a6705,6706
>>>  
>>>
>>>>             getBigDecimal(1) = 666.0
>>>>             getBigDecimal(1) = 666.0
>>>>   
>>>
>>> 6728 del
>>> <             getBigDecimal(1) = 666
>>> 6729 del
>>> <             getBigDecimal(1) = 666
>>> 6729a6728,6729
>>>  
>>>
>>>>             getBigDecimal(1) = 666.0
>>>>             getBigDecimal(1) = 666.0
>>>>   
>>>
>>> 6767 del
>>> <             getBigDecimal(1) = 666
>>> 6768 del
>>> <             getBigDecimal(1) = 666
>>> 6768a6767,6768
>>>  
>>>
>>>>             getBigDecimal(1) = 666.0
>>>>             getBigDecimal(1) = 666.0
>>>>   
>>>
>>> 6790 del
>>> <             getBigDecimal(1) = 666
>>> 6791 del
>>> <             getBigDecimal(1) = 666
>>> 6791a6790,6791
>>>  
>>>
>>>>             getBigDecimal(1) = 666.0
>>>>             getBigDecimal(1) = 666.0
>>>>   
>>>
>>> 6813 del
>>> <             getBigDecimal(1) = 666
>>> 6814 del
>>> <             getBigDecimal(1) = 666
>>> 6814a6813,6814
>>>  
>>>
>>>>             getBigDecimal(1) = 666.0
>>>>             getBigDecimal(1) = 666.0
>>>>   
>>>
>>> 6836 del
>>> <             getBigDecimal(1) = 666
>>> 6837 del
>>> <             getBigDecimal(1) = 666
>>> 6837a6836,6837
>>>  
>>>
>>>>             getBigDecimal(1) = 666.0
>>>>             getBigDecimal(1) = 666.0
>>>>   
>>>
>>> 6859 del
>>> <             getBigDecimal(1) = 666
>>> 6860 del
>>> <             getBigDecimal(1) = 666
>>> 6860a6859,6860
>>>  
>>>
>>>>             getBigDecimal(1) = 666.0
>>>>             getBigDecimal(1) = 666.0
>>>>   
>>>
>>> 6882 del
>>> <             getBigDecimal(1) = 666
>>> 6883 del
>>> <             getBigDecimal(1) = 666
>>> 6883a6882,6883
>>>  
>>>
>>>>             getBigDecimal(1) = 666.0
>>>>             getBigDecimal(1) = 666.0
>>>>   
>>>
>>> 6905 del
>>> <             getBigDecimal(1) = 666
>>> 6906 del
>>> <             getBigDecimal(1) = 666
>>> 6906a6905,6906
>>>  
>>>
>>>>             getBigDecimal(1) = 666.0
>>>>             getBigDecimal(1) = 666.0
>>>>   
>>>
>>> 6928 del
>>> <             getBigDecimal(1) = 666
>>> 6929 del
>>> <             getBigDecimal(1) = 666
>>> 6929a6928,6929
>>>  
>>>
>>>>             getBigDecimal(1) = 666.0
>>>>             getBigDecimal(1) = 666.0
>>>>   
>>>
>>> 6951 del
>>> <             getBigDecimal(1) = 666
>>> 6952 del
>>> <             getBigDecimal(1) = 666
>>> 6952a6951,6952
>>>  
>>>
>>>>             getBigDecimal(1) = 666.0
>>>>             getBigDecimal(1) = 666.0
>>>>   
>>>
>>> 6974 del
>>> <             getBigDecimal(1) = 666
>>> 6975 del
>>> <             getBigDecimal(1) = 666
>>> 6975a6974,6975
>>>  
>>>
>>>>             getBigDecimal(1) = 666.0
>>>>             getBigDecimal(1) = 666.0
>>>>   
>>>
>>> 6997 del
>>> <             getBigDecimal(1) = 666
>>> 6998 del
>>> <             getBigDecimal(1) = 666
>>> 6998a6997,6998
>>>  
>>>
>>>>             getBigDecimal(1) = 666.0
>>>>             getBigDecimal(1) = 666.0
>>>>   
>>>
>>> 7020 del
>>> <             getBigDecimal(1) = 666
>>> 7021 del
>>> <             getBigDecimal(1) = 666
>>> 7021a7020,7021
>>>  
>>>
>>>>             getBigDecimal(1) = 666.0
>>>>             getBigDecimal(1) = 666.0
>>>>   
>>>
>>> 7043 del
>>> <             getBigDecimal(1) = 666
>>> 7044 del
>>> <             getBigDecimal(1) = 666
>>> 7044a7043,7044
>>>  
>>>
>>>>             getBigDecimal(1) = 666.0
>>>>             getBigDecimal(1) = 666.0
>>>>   
>>>
>>> 7066 del
>>> <             getBigDecimal(1) = 666
>>> 7067 del
>>> <             getBigDecimal(1) = 666
>>> 7067a7066,7067
>>>  
>>>
>>>>             getBigDecimal(1) = 666.0
>>>>             getBigDecimal(1) = 666.0
>>>>   
>>>
>>> Test Failed.
>>> *** End:   outparams jdk1.4.2 derbyall:derbylang 2005-02-07 11:49:35
>>> ***
>>> ********* Diff file derbyall/derbylang/procedure.diff
>>> *** Start: procedure jdk1.4.2 derbyall:derbylang 2005-02-07 11:52:44
>>> ***
>>> 0a1
>>>  
>>>
>>>> Exception in thread "main" java.lang.NullPointerException
>>>>   
>>>
>>> 2 del
>>> < 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 dot
>>> separated list. 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 dot
>>> separated list. 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: MISSING ELEMENT.
>>> < create procedure missing03() language java parameter style java
>>> < EXPECTED SQL Exception: (42X01) Syntax error: MISSING ELEMENT.
>>> < create procedure missing04() language java external name 'foo.bar'
>>> < EXPECTED SQL Exception: (42X01) Syntax error: MISSING ELEMENT.
>>> < create procedure missing05() parameter style java
>>> < EXPECTED SQL Exception: (42X01) Syntax error: MISSING ELEMENT.
>>> < create procedure missing06() parameter style java external name
>>> 'foo.bar'
>>> < EXPECTED SQL Exception: (42X01) Syntax error: MISSING ELEMENT.
>>> < create procedure missing07() external name 'goo.bar'
>>> < EXPECTED SQL Exception: (42X01) Syntax error: MISSING ELEMENT.
>>> < create procedure missing08() dynamic result sets 1
>>> < EXPECTED SQL Exception: (42X01) Syntax error: MISSING ELEMENT.
>>> < 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.
>>> < 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 to be able to
>>> match method call java.lang.Integer.asdf(), even tried all
>>> combinations of object and primitive types and any possible type
>>> conversion for any parameters the method call may have.  It may be
>>> that the method exists, but it is not public and/or static, or that
>>> the parameter types are not method invocation convertible.
>>> < call notstatic()
>>> < EXPECTED SQL Exception: (42X50) No method was found to be able to
>>> match method call java.lang.Integer.equals(), even tried all
>>> combinations of object and primitive types and any possible type
>>> conversion for any parameters the method call may have.  It may be
>>> that the method exists, but it is not public and/or static, or that
>>> the parameter types are not method invocation convertible.
>>> < call notvoid()
>>> < EXPECTED SQL Exception: (42X50) No method was found to be able to
>>> match method call void java.lang.Runtime.getRuntime(), even tried
>>> all combinations of object and primitive types and any possible type
>>> conversion for any parameters the method call may have.  It may be
>>> that the method exists, but it is not public and/or static, or that
>>> 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 to be able to
>>> match method call
>>> org.apache.derbyTesting.functionTests.util.ProcedureTest.ambigious2(int,
>>> int, java.sql.ResultSet[]), even tried all combinations of object
>>> and primitive types and any possible type conversion for any
>>> parameters the method call may have.  It may be that the method
>>> exists, but it is not public and/or static, or that 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 'SQL Exception: 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 'SQL Exception: 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 to be able to
>>> match method call
>>> org.apache.derbyTesting.functionTests.util.ProcedureTest.missingDynamicParameter(int,
>>> java.sql.ResultSet[]), even tried all combinations of object and
>>> primitive types and any possible type conversion for any parameters
>>> the method call may have.  It may be that the method exists, but it
>>> is not public and/or static, or that the parameter types are not
>>> method invocation convertible.
>>> < CALL rsi(?)
>>> < EXPECTED SQL Exception: (42X50) No method was found to be able to
>>> match method call
>>> org.apache.derbyTesting.functionTests.util.ProcedureTest.badDynamicParameter(int,
>>> java.sql.ResultSet[]), even tried all combinations of object and
>>> primitive types and any possible type conversion for any parameters
>>> the method call may have.  It may be that the method exists, but it
>>> is not public and/or static, or that 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 Attepmt 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<
>>> Test Failed.
>>> *** End:   procedure jdk1.4.2 derbyall:derbylang 2005-02-07 11:52:45
>>> ***
>>> ********* Diff file derbyall/derbylang/schemas.diff
>>> *** Start: schemas jdk1.4.2 derbyall:derbylang 2005-02-07 12:02:50 ***
>>> 732 del
>>> < ERROR 42X04: Column 'SS.I' is not in any table in the FROM list or
>>> it appears within a join specification and is outside the scope of
>>> the join specification or it appears in a HAVING clause and is not
>>> in the GROUP BY list.  If this is a CREATE or ALTER TABLE statement
>>> then 'SS.I' is not a column in the target table.
>>> 732a732
>>>  
>>>
>>>> ERROR 42X04: Column 'APP.SS.I' is not in any table in the FROM list
>>>> or it appears within a join specification and is outside the scope
>>>> of the join specification or it appears in a HAVING clause and is
>>>> not in the GROUP BY list.  If this is a CREATE or ALTER TABLE
>>>> statement then 'APP.SS.I' is not a column in the target table.
>>>>   
>>>
>>> Test Failed.
>>> *** End:   schemas jdk1.4.2 derbyall:derbylang 2005-02-07 12:03:16 ***
>>> ********* Diff file derbyall/derbylang/subquery.diff
>>> *** Start: subquery jdk1.4.2 derbyall:derbylang 2005-02-07 12:07:20 ***
>>> 525 del
>>> < ERROR 42X04: Column 'SS.I' is not in any table in the FROM list or
>>> it appears within a join specification and is outside the scope of
>>> the join specification or it appears in a HAVING clause and is not
>>> in the GROUP BY list.  If this is a CREATE or ALTER TABLE statement
>>> then 'SS.I' is not a column in the target table.
>>> 525a525
>>>  
>>>
>>>> ERROR 42X04: Column 'APP.SS.I' is not in any table in the FROM list
>>>> or it appears within a join specification and is outside the scope
>>>> of the join specification or it appears in a HAVING clause and is
>>>> not in the GROUP BY list.  If this is a CREATE or ALTER TABLE
>>>> statement then 'APP.SS.I' is not a column in the target table.
>>>>   
>>>
>>> 534 del
>>> < ERROR 42X04: Column 'TT.II' is not in any table in the FROM list
>>> or it appears within a join specification and is outside the scope
>>> of the join specification or it appears in a HAVING clause and is
>>> not in the GROUP BY list.  If this is a CREATE or ALTER TABLE
>>> statement then 'TT.II' is not a column in the target table.
>>> 534a534
>>>  
>>>
>>>> ERROR 42X04: Column 'APP.TT.II' is not in any table in the FROM
>>>> list or it appears within a join specification and is outside the
>>>> scope of the join specification or it appears in a HAVING clause
>>>> and is not in the GROUP BY list.  If this is a CREATE or ALTER
>>>> TABLE statement then 'APP.TT.II' is not a column in the target table.
>>>>   
>>>
>>> 539 del
>>> < ERROR 42X04: Column 'S.I' is not in any table in the FROM list or
>>> it appears within a join specification and is outside the scope of
>>> the join specification or it appears in a HAVING clause and is not
>>> in the GROUP BY list.  If this is a CREATE or ALTER TABLE statement
>>> then 'S.I' is not a column in the target table.
>>> 539a539
>>>  
>>>
>>>> ERROR 42X04: Column 'APP.S.I' is not in any table in the FROM list
>>>> or it appears within a join specification and is outside the scope
>>>> of the join specification or it appears in a HAVING clause and is
>>>> not in the GROUP BY list.  If this is a CREATE or ALTER TABLE
>>>> statement then 'APP.S.I' is not a column in the target table.
>>>>   
>>>
>>> Test Failed.
>>> *** End:   subquery jdk1.4.2 derbyall:derbylang 2005-02-07 12:07:45 ***
>>> ********* Diff file derbyall/derbytools/dblook_test.diff
>>> *** Start: dblook_test jdk1.4.2 derbyall:derbytools 2005-02-07
>>> 12:47:31 ***
>>> 4861d4860
>>> < java.io.FileNotFoundException: <filePath>
>>> Test Failed.
>>> *** End:   dblook_test jdk1.4.2 derbyall:derbytools 2005-02-07
>>> 12:48:44 ***
>>> ********* Diff file derbyall/jdbcapi/parameterMapping.diff
>>> *** Start: parameterMapping jdk1.4.2 derbyall:jdbcapi 2005-02-07
>>> 13:07:38 ***
>>> 560 del
>>> <   getBigDecimal=32 was null false JDBC MATCH(OK)
>>> 560a560
>>>  
>>>
>>>>  getBigDecimal=32.0 was null false JDBC MATCH(OK)
>>>>   
>>>
>>> 674 del
>>> < P2=cs.getBigDecimal=41.90000152587890625 was null false
>>> 675 del
>>> < P3=cs.getBigDecimal=88.8000030517578125 was null false
>>> 675a674,675
>>>  
>>>
>>>> P2=cs.getBigDecimal=41.9 was null false
>>>> P3=cs.getBigDecimal=88.8 was null false
>>>>   
>>>
>>> 736 del
>>> <   getBigDecimal=32 was null false JDBC MATCH(OK)
>>> 736a736
>>>  
>>>
>>>>  getBigDecimal=32.0 was null false JDBC MATCH(OK)
>>>>   
>>>
>>> 850 del
>>> <
>>> P2=cs.getBigDecimal=35.89999999999999857891452847979962825775146484375
>>> was null false
>>> 851 del
>>> <
>>> P3=cs.getBigDecimal=66.7999999999999971578290569595992565155029296875
>>> was null false
>>> 851a850,851
>>>  
>>>
>>>> P2=cs.getBigDecimal=35.9 was null false
>>>> P3=cs.getBigDecimal=66.8 was null false
>>>>   
>>>
>>> 911 del
>>> <   getBigDecimal=32 was null false JDBC MATCH(OK)
>>> 911a911
>>>  
>>>
>>>>  getBigDecimal=32.0 was null false JDBC MATCH(OK)
>>>>   
>>>
>>> 1025 del
>>> <
>>> P2=cs.getBigDecimal=35.89999999999999857891452847979962825775146484375
>>> was null false
>>> 1026 del
>>> <
>>> P3=cs.getBigDecimal=66.7999999999999971578290569595992565155029296875
>>> was null false
>>> 1026a1025,1026
>>>  
>>>
>>>> P2=cs.getBigDecimal=35.9 was null false
>>>> P3=cs.getBigDecimal=66.8 was null false
>>>>   
>>>
>>> Test Failed.
>>> *** End:   parameterMapping jdk1.4.2 derbyall:jdbcapi 2005-02-07
>>> 13:08:34 ***
>>> ********* Diff file /dml162.diff
>>> *** Start: dml162 jdk1.4.2 derbyall:nist 2005-02-07 13:19:19 ***
>>> 24 del
>>> < 0 rows inserted/updated/deleted
>>> 24a24
>>>  
>>>
>>>> ERROR 42X04: Column 'FLATER.PROJ.CITY' is not in any table in the
>>>> FROM list or it appears within a join specification and is outside
>>>> the scope of the join specification or it appears in a HAVING
>>>> clause and is not in the GROUP BY list.  If this is a CREATE or
>>>> ALTER TABLE statement then 'FLATER.PROJ.CITY' is not a column in
>>>> the target table.
>>>>   
>>>
>>> 29 del
>>> < 1          30 del
>>> < -----------
>>> 31 del
>>> < 3          31a29
>>>  
>>>
>>>> ERROR 42X05: Table 'BLIVET' does not exist.
>>>>   
>>>
>>> 35 del
>>> < 1          36 del
>>> < -----------
>>> 37 del
>>> < 3          37a33
>>>  
>>>
>>>> ERROR 42X05: Table 'BLIVET' does not exist.
>>>>   
>>>
>>> 60 del
>>> < 0 rows inserted/updated/deleted
>>> 60a56
>>>  
>>>
>>>> ERROR X0X05: Table 'BLIVET' does not exist.
>>>>   
>>>
>>> Test Failed.
>>> *** End:   dml162 jdk1.4.2 derbyall:nist 2005-02-07 13:19:20 ***
>>> ********* Diff file /dml099.diff
>>> *** Start: dml099 jdk1.4.2 derbyall:nist 2005-02-07 13:20:06 ***
>>> 50 del
>>> < 2          |2.1                   |9.099   50a50
>>>  
>>>
>>>> 2          |2.1                   |9.100     
>>>
>>> Test Failed.
>>> *** End:   dml099 jdk1.4.2 derbyall:nist 2005-02-07 13:20:07 ***
>>> ------------------------------------------------------
>>>  
>>>
>
>

Mime
View raw message