Return-Path: Delivered-To: apmail-db-derby-commits-archive@www.apache.org Received: (qmail 48439 invoked from network); 1 Sep 2006 06:38:05 -0000 Received: from hermes.apache.org (HELO mail.apache.org) (209.237.227.199) by minotaur.apache.org with SMTP; 1 Sep 2006 06:38:05 -0000 Received: (qmail 2571 invoked by uid 500); 1 Sep 2006 06:38:05 -0000 Delivered-To: apmail-db-derby-commits-archive@db.apache.org Received: (qmail 2510 invoked by uid 500); 1 Sep 2006 06:38:05 -0000 Mailing-List: contact derby-commits-help@db.apache.org; run by ezmlm Precedence: bulk list-help: list-unsubscribe: List-Post: Reply-To: "Derby Development" List-Id: Delivered-To: mailing list derby-commits@db.apache.org Received: (qmail 2499 invoked by uid 99); 1 Sep 2006 06:38:05 -0000 Received: from asf.osuosl.org (HELO asf.osuosl.org) (140.211.166.49) by apache.org (qpsmtpd/0.29) with ESMTP; Thu, 31 Aug 2006 23:38:04 -0700 X-ASF-Spam-Status: No, hits=-8.9 required=10.0 tests=ALL_TRUSTED,INTERRUPTUS,NO_REAL_NAME X-Spam-Check-By: apache.org Received-SPF: pass (asf.osuosl.org: local policy) Received: from [140.211.166.113] (HELO eris.apache.org) (140.211.166.113) by apache.org (qpsmtpd/0.29) with ESMTP; Thu, 31 Aug 2006 23:38:02 -0700 Received: by eris.apache.org (Postfix, from userid 65534) id 123F61A981A; Thu, 31 Aug 2006 23:37:42 -0700 (PDT) Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: 7bit Subject: svn commit: r439209 - in /db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests: master/j9_13/ master/j9_foundation/ tests/lang/ Date: Fri, 01 Sep 2006 06:37:40 -0000 To: derby-commits@db.apache.org From: fuzzylogic@apache.org X-Mailer: svnmailer-1.0.8 Message-Id: <20060901063742.123F61A981A@eris.apache.org> X-Virus-Checked: Checked by ClamAV on apache.org X-Spam-Rating: minotaur.apache.org 1.6.2 0/1000/N Author: fuzzylogic Date: Thu Aug 31 23:37:39 2006 New Revision: 439209 URL: http://svn.apache.org/viewvc?rev=439209&view=rev Log: Update j9 master due to recent changes for issues DERBY-836, DERBY-1554, DERBY-1702, and add a comment regarding why floattypes is skipped on 1.3.1-level VMs including wsdd5.6/wctme5.7. Committed for Myrna Van Lunteren Modified: db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/j9_13/floattypes.out db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/j9_foundation/autoGeneratedJdbc30.out db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/j9_foundation/floattypes.out db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/j9_foundation/iepnegativetests_ES.out db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/j9_foundation/resultset.out db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/tests/lang/floattypes_app.properties Modified: db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/j9_13/floattypes.out URL: http://svn.apache.org/viewvc/db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/j9_13/floattypes.out?rev=439209&r1=439208&r2=439209&view=diff ============================================================================== --- db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/j9_13/floattypes.out (original) +++ db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/j9_13/floattypes.out Thu Aug 31 23:37:39 2006 @@ -50,13 +50,13 @@ ------ 1 ij> values cast (1.1 as dec(5,3)); -1 --------- -1.100 +1 +------- +1.100 ij> values cast (1.1 as numeric(5,3)); -1 --------- -1.100 +1 +------- +1.100 ij> -- cast to all valid types values cast (1.1 as int); 1 @@ -393,15 +393,15 @@ 1.0 1.0 ij> select cast(d as dec(10,2)) from tmp; -1 -------------- -1.00 -1.00 +1 +------------ +1.00 +1.00 ij> select cast(d as dec(10,8)) from tmp; -1 -------------- -1.00000000 -1.00000000 +1 +------------ +1.00000000 +1.00000000 ij> drop table tmp; 0 rows inserted/updated/deleted ij> drop table t; @@ -440,12 +440,12 @@ ); 1 row inserted/updated/deleted ij> select dc from t; -DC -------------- -NULL -10.00 --10.00 -0.00 +DC +------------ +NULL +10.00 +-10.00 +0.00 ij> select dc + i, dc + s, dc + r, dc + dc from t; 1 |2 |3 |4 ------------------------------------------------------------ @@ -484,11 +484,11 @@ 0.0 |0.0 ij> -- test null/null, constant/null, null/constant select dc, i / dc, 10 / dc, dc / 10e0 from t; -DC |2 |3 |4 ----------------------------------------------------------------------------------------------------------- -NULL |NULL |NULL |NULL -10.00 |1.0000000000000000000 |1.0000000000000000000 |1.0 --10.00 |1.0000000000000000000 |-1.0000000000000000000 |-1.0 +DC |2 |3 |4 +--------------------------------------------------------------------------------------------------------- +NULL |NULL |NULL |NULL +10.00 |1.0000000000000000000 |1.0000000000000000000 |1.0 +-10.00 |1.0000000000000000000 |-1.0000000000000000000 |-1.0 ERROR 22012: Attempt to divide by zero. ij> -- test for divide by 0 select dc / i from t; @@ -507,20 +507,20 @@ 1.0 |1.0 ij> -- test positive/negative, negative/positive and negative/negative select dc, dc / -dc, (-dc) / dc, (-dc) / -dc from t; -DC |2 |3 |4 ----------------------------------------------------------------------------------------------------------------------- -NULL |NULL |NULL |NULL -10.00 |-1.000000000000000000000 |-1.000000000000000000000 |1.000000000000000000000 --10.00 |-1.000000000000000000000 |-1.000000000000000000000 |1.000000000000000000000 +DC |2 |3 |4 +--------------------------------------------------------------------------------------------------------------------- +NULL |NULL |NULL |NULL +10.00 |-1.000000000000000000000 |-1.000000000000000000000 |1.000000000000000000000 +-10.00 |-1.000000000000000000000 |-1.000000000000000000000 |1.000000000000000000000 ERROR 22012: Attempt to divide by zero. ij> -- test some "more complex" expressions select dc, dc + 10e0, dc - (10 - 20e0), dc - 10, dc - (20 - 10) from t; -DC |2 |3 |4 |5 ---------------------------------------------------------------------------------------------- -NULL |NULL |NULL |NULL |NULL -10.00 |20.0 |20.0 |0.00 |0.00 --10.00 |0.0 |0.0 |-20.00 |-20.00 -0.00 |10.0 |10.0 |-10.00 |-10.00 +DC |2 |3 |4 |5 +-------------------------------------------------------------------------------------------- +NULL |NULL |NULL |NULL |NULL +10.00 |20.0 |20.0 |0.00 |0.00 +-10.00 |0.0 |0.0 |-20.00 |-20.00 +0.00 |10.0 |10.0 |-10.00 |-10.00 ij> -- make sure we get the right scale/precision during arithmetic values (9.0 + 9.0); 1 @@ -621,9 +621,9 @@ -- cast(1.7e308 as dec(2147483647)))); -- values cast(1 as dec(31, 20)); -1 ----------------------------------- -1.00000000000000000000 +1 +--------------------------------- +1.00000000000000000000 ij> -- test the arithmetic operators on a type we know they don't work on create table w (x dec, y long varchar); 0 rows inserted/updated/deleted @@ -651,314 +651,314 @@ 1 row inserted/updated/deleted ij> -- test = select dc from t where dc is null; -DC -------------- -NULL +DC +------------ +NULL ij> select dc from t where dc = 10; -DC -------------- -10.00 +DC +------------ +10.00 ij> select dc from t where dc = -10; -DC -------------- --10.00 +DC +------------ +-10.00 ij> select dc from t where dc = 0; -DC -------------- -0.00 +DC +------------ +0.00 ij> select dc from t where dc = 1234.45; -DC -------------- +DC +------------ ij> select dc from t where dc = i; -DC -------------- -10.00 --10.00 -0.00 +DC +------------ +10.00 +-10.00 +0.00 ij> select dc from t where dc = l; -DC -------------- -10.00 --10.00 -0.00 +DC +------------ +10.00 +-10.00 +0.00 ij> select dc from t where dc = s; -DC -------------- -10.00 --10.00 -0.00 +DC +------------ +10.00 +-10.00 +0.00 ij> select dc from t where dc = r; -DC -------------- -10.00 --10.00 -0.00 -1234.56 +DC +------------ +10.00 +-10.00 +0.00 +1234.56 ij> select dc from t where dc = d; -DC -------------- -10.00 --10.00 -0.00 -1234.56 +DC +------------ +10.00 +-10.00 +0.00 +1234.56 ij> select dc from t where dc = dc; -DC -------------- -10.00 --10.00 -0.00 -1234.56 +DC +------------ +10.00 +-10.00 +0.00 +1234.56 ij> -- test > select dc from t where dc > 10; -DC -------------- -1234.56 +DC +------------ +1234.56 ij> select dc from t where dc > -10; -DC -------------- -10.00 -0.00 -1234.56 +DC +------------ +10.00 +0.00 +1234.56 ij> select dc from t where dc > 0; -DC -------------- -10.00 -1234.56 +DC +------------ +10.00 +1234.56 ij> select dc from t where dc > 1234.45; -DC -------------- -1234.56 +DC +------------ +1234.56 ij> select dc from t where dc > i; -DC -------------- -1234.56 +DC +------------ +1234.56 ij> select dc from t where dc > l; -DC -------------- -1234.56 +DC +------------ +1234.56 ij> select dc from t where dc > s; -DC -------------- -1234.56 +DC +------------ +1234.56 ij> select dc from t where dc > r; -DC -------------- +DC +------------ ij> select dc from t where dc > d; -DC -------------- +DC +------------ ij> select dc from t where dc > dc; -DC -------------- +DC +------------ ij> -- test >= select dc from t where dc >= 10; -DC -------------- -10.00 -1234.56 +DC +------------ +10.00 +1234.56 ij> select dc from t where dc >= -10; -DC -------------- -10.00 --10.00 -0.00 -1234.56 +DC +------------ +10.00 +-10.00 +0.00 +1234.56 ij> select dc from t where dc >= 0; -DC -------------- -10.00 -0.00 -1234.56 +DC +------------ +10.00 +0.00 +1234.56 ij> select dc from t where dc >= 1234.45; -DC -------------- -1234.56 +DC +------------ +1234.56 ij> select dc from t where dc >= i; -DC -------------- -10.00 --10.00 -0.00 -1234.56 +DC +------------ +10.00 +-10.00 +0.00 +1234.56 ij> select dc from t where dc >= l; -DC -------------- -10.00 --10.00 -0.00 -1234.56 +DC +------------ +10.00 +-10.00 +0.00 +1234.56 ij> select dc from t where dc >= s; -DC -------------- -10.00 --10.00 -0.00 -1234.56 +DC +------------ +10.00 +-10.00 +0.00 +1234.56 ij> select dc from t where dc >= r; -DC -------------- -10.00 --10.00 -0.00 -1234.56 +DC +------------ +10.00 +-10.00 +0.00 +1234.56 ij> select dc from t where dc >= d; -DC -------------- -10.00 --10.00 -0.00 -1234.56 +DC +------------ +10.00 +-10.00 +0.00 +1234.56 ij> select dc from t where dc >= dc; -DC -------------- -10.00 --10.00 -0.00 -1234.56 +DC +------------ +10.00 +-10.00 +0.00 +1234.56 ij> -- test < select dc from t where dc < 10; -DC -------------- --10.00 -0.00 +DC +------------ +-10.00 +0.00 ij> select dc from t where dc < -10; -DC -------------- +DC +------------ ij> select dc from t where dc < 0; -DC -------------- --10.00 +DC +------------ +-10.00 ij> select dc from t where dc < 1234.45; -DC -------------- -10.00 --10.00 -0.00 +DC +------------ +10.00 +-10.00 +0.00 ij> select dc from t where dc < i; -DC -------------- +DC +------------ ij> select dc from t where dc < l; -DC -------------- +DC +------------ ij> select dc from t where dc < s; -DC -------------- +DC +------------ ij> select dc from t where dc < r; -DC -------------- +DC +------------ ij> select dc from t where dc < d; -DC -------------- +DC +------------ ij> select dc from t where dc < dc; -DC -------------- +DC +------------ ij> -- test <= select dc from t where dc <= 10; -DC -------------- -10.00 --10.00 -0.00 +DC +------------ +10.00 +-10.00 +0.00 ij> select dc from t where dc <= -10; -DC -------------- --10.00 +DC +------------ +-10.00 ij> select dc from t where dc <= 0; -DC -------------- --10.00 -0.00 +DC +------------ +-10.00 +0.00 ij> select dc from t where dc <= 1234.45; -DC -------------- -10.00 --10.00 -0.00 +DC +------------ +10.00 +-10.00 +0.00 ij> select dc from t where dc <= i; -DC -------------- -10.00 --10.00 -0.00 +DC +------------ +10.00 +-10.00 +0.00 ij> select dc from t where dc <= l; -DC -------------- -10.00 --10.00 -0.00 +DC +------------ +10.00 +-10.00 +0.00 ij> select dc from t where dc <= s; -DC -------------- -10.00 --10.00 -0.00 +DC +------------ +10.00 +-10.00 +0.00 ij> select dc from t where dc <= r; -DC -------------- -10.00 --10.00 -0.00 -1234.56 +DC +------------ +10.00 +-10.00 +0.00 +1234.56 ij> select dc from t where dc <= d; -DC -------------- -10.00 --10.00 -0.00 -1234.56 +DC +------------ +10.00 +-10.00 +0.00 +1234.56 ij> select dc from t where dc <= dc; -DC -------------- -10.00 --10.00 -0.00 -1234.56 +DC +------------ +10.00 +-10.00 +0.00 +1234.56 ij> -- test <> select dc from t where dc <> 10; -DC -------------- --10.00 -0.00 -1234.56 +DC +------------ +-10.00 +0.00 +1234.56 ij> select dc from t where dc <> -10; -DC -------------- -10.00 -0.00 -1234.56 +DC +------------ +10.00 +0.00 +1234.56 ij> select dc from t where dc <> 0; -DC -------------- -10.00 --10.00 -1234.56 +DC +------------ +10.00 +-10.00 +1234.56 ij> select dc from t where dc <> 1234.45; -DC -------------- -10.00 --10.00 -0.00 -1234.56 +DC +------------ +10.00 +-10.00 +0.00 +1234.56 ij> select dc from t where dc <> i; -DC -------------- -1234.56 +DC +------------ +1234.56 ij> select dc from t where dc <> l; -DC -------------- -1234.56 +DC +------------ +1234.56 ij> select dc from t where dc <> s; -DC -------------- -1234.56 +DC +------------ +1234.56 ij> select dc from t where dc <> r; -DC -------------- +DC +------------ ij> select dc from t where dc <> d; -DC -------------- +DC +------------ ij> select dc from t where dc <> dc; -DC -------------- +DC +------------ ij> -- -- test a variety of inserts and updates -- @@ -982,65 +982,65 @@ update t2 set dc = dc + 1.1; 5 rows inserted/updated/deleted ij> select dc from t2; -DC -------------- --8.90 -1.10 -11.10 -1235.66 -NULL +DC +------------ +-8.90 +1.10 +11.10 +1235.66 +NULL ij> update t2 set dc = dc - 1.1; 5 rows inserted/updated/deleted ij> select dc from t2; -DC -------------- --10.00 -0.00 -10.00 -1234.56 -NULL +DC +------------ +-10.00 +0.00 +10.00 +1234.56 +NULL ij> update t2 set dc = dc / 1.1; 5 rows inserted/updated/deleted ij> select dc from t2; -DC -------------- --9.09 -0.00 -9.09 -1122.32 -NULL +DC +------------ +-9.09 +0.00 +9.09 +1122.32 +NULL ij> update t2 set dc = dc * 1.1; 5 rows inserted/updated/deleted ij> select dc from t2; -DC -------------- --9.99 -0.00 -9.99 -1234.55 -NULL +DC +------------ +-9.99 +0.00 +9.99 +1234.55 +NULL ij> -- try some deletes delete from t2 where dc > 0; 2 rows inserted/updated/deleted ij> select dc from t2; -DC -------------- --9.99 -0.00 -NULL +DC +------------ +-9.99 +0.00 +NULL ij> delete from t2 where dc = 0; 1 row inserted/updated/deleted ij> select dc from t2; -DC -------------- --9.99 -NULL +DC +------------ +-9.99 +NULL ij> delete from t2 where dc < 0; 1 row inserted/updated/deleted ij> select dc from t2; -DC -------------- -NULL +DC +------------ +NULL ij> drop table t2; 0 rows inserted/updated/deleted ij> drop table t; @@ -1074,33 +1074,33 @@ ij> insert into t values ('a', 9.123, 'Z'); 1 row inserted/updated/deleted ij> select * from t; -C1 |D |C2 ---------------------------------- -a |1.1230 |Z -a |11111.1230 |Z -a |11111111.1230 |Z -a |6.1230 |Z -a |666.1230 |Z -a |0.6000 |Z -a |0.0000 |Z -a |666666.1230 |Z -a |99999999999999.1230 |Z -a |9.1230 |Z +C1 |D |C2 +-------------------------------- +a |1.1230 |Z +a |11111.1230 |Z +a |11111111.1230 |Z +a |6.1230 |Z +a |666.1230 |Z +a |0.6000 |Z +a |0.0000 |Z +a |666666.1230 |Z +a |99999999999999.1230 |Z +a |9.1230 |Z ij> update t set d = d + .0007; 10 rows inserted/updated/deleted ij> select * from t; -C1 |D |C2 ---------------------------------- -a |1.1237 |Z -a |11111.1237 |Z -a |11111111.1237 |Z -a |6.1237 |Z -a |666.1237 |Z -a |0.6007 |Z -a |0.0007 |Z -a |666666.1237 |Z -a |99999999999999.1237 |Z -a |9.1237 |Z +C1 |D |C2 +-------------------------------- +a |1.1237 |Z +a |11111.1237 |Z +a |11111111.1237 |Z +a |6.1237 |Z +a |666.1237 |Z +a |0.6007 |Z +a |0.0007 |Z +a |666666.1237 |Z +a |99999999999999.1237 |Z +a |9.1237 |Z ij> drop table tmp; ERROR 42Y55: 'DROP TABLE' cannot be performed on 'TMP' because it does not exist. ij> drop table bad; @@ -2444,87 +2444,87 @@ ij> insert into tiger values (0.00000001234); 1 row inserted/updated/deleted ij> select d from tiger order by 1; -D ---------------- -0.00000001234 -0.00000001234 -0.00000012340 -0.00000123400 -0.00001234000 -0.00012340000 -0.00123400000 -0.00123400000 -0.01234000000 -0.12340000000 -1.23400000000 +D +-------------- +0.00000001234 +0.00000001234 +0.00000012340 +0.00000123400 +0.00001234000 +0.00012340000 +0.00123400000 +0.00123400000 +0.01234000000 +0.12340000000 +1.23400000000 ij> -- ===================================================== -- some formatting tests values cast ('1e+0' as DECIMAL(6,2)); -1 ---------- -ERROR 22018: Invalid character string format for type DECIMAL. +1 +-------- +1.00 ij> values cast ('+-1e+1' as DECIMAL(6,2)); -1 ---------- +1 +-------- ERROR 22018: Invalid character string format for type DECIMAL. ij> values cast ('-1e+1' as DECIMAL(6,2)); -1 ---------- -ERROR 22018: Invalid character string format for type DECIMAL. +1 +-------- +-10.00 ij> values cast ('-1e-1' as DECIMAL(6,2)); -1 ---------- --0.10 +1 +-------- +-0.10 ij> values cast ('-1e-+1' as DECIMAL(6,2)); -1 ---------- +1 +-------- ERROR 22018: Invalid character string format for type DECIMAL. ij> values cast ('-1e--1' as DECIMAL(6,2)); -1 ---------- +1 +-------- ERROR 22018: Invalid character string format for type DECIMAL. ij> values cast ('-1e+-1' as DECIMAL(6,2)); -1 ---------- +1 +-------- ERROR 22018: Invalid character string format for type DECIMAL. ij> values cast ('-1e+-1' as DECIMAL(6,2)); -1 ---------- +1 +-------- ERROR 22018: Invalid character string format for type DECIMAL. ij> values cast ('1.0e' as DECIMAL(6,2)); -1 ---------- +1 +-------- ERROR 22018: Invalid character string format for type DECIMAL. ij> values cast ('1.0e+' as DECIMAL(6,2)); -1 ---------- +1 +-------- ERROR 22018: Invalid character string format for type DECIMAL. ij> values cast ('1.0e-' as DECIMAL(6,2)); -1 ---------- +1 +-------- ERROR 22018: Invalid character string format for type DECIMAL. ij> values cast ('1.0ee' as DECIMAL(6,2)); -1 ---------- +1 +-------- ERROR 22018: Invalid character string format for type DECIMAL. ij> values cast ('123.' as DECIMAL(6,2)); -1 ---------- -123.00 +1 +-------- +123.00 ij> values cast ('1e' as DECIMAL(6,2)); -1 ---------- +1 +-------- ERROR 22018: Invalid character string format for type DECIMAL. ij> values cast ('1e1.0' as DECIMAL(6,2)); -1 ---------- +1 +-------- ERROR 22018: Invalid character string format for type DECIMAL. ij> values cast ('.3' as DECIMAL(6,2)); -1 ---------- -0.30 +1 +-------- +0.30 ij> values cast ('' as DECIMAL(6,2)); -1 ---------- +1 +-------- ERROR 22018: Invalid character string format for type DECIMAL. ij> Modified: db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/j9_foundation/autoGeneratedJdbc30.out URL: http://svn.apache.org/viewvc/db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/j9_foundation/autoGeneratedJdbc30.out?rev=439209&r1=439208&r2=439209&view=diff ============================================================================== --- db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/j9_foundation/autoGeneratedJdbc30.out (original) +++ db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/j9_foundation/autoGeneratedJdbc30.out Thu Aug 31 23:37:39 2006 @@ -12,88 +12,88 @@ there was no prior one-row insert into a table with autogenerated key 1 - - {3} + {null} Now try the same test again but this time with Statement.executeUpdate. It should behave the same 1 - - {6} + {null} Now try the same test again but this time with PreparedStatement.execute. It should behave the same 1 - - {9} + {null} Now try the same test again but this time with PreparedStatement.executeUpdate. It should behave the same 1 - - {12} + {null} Test 4 - request for generated keys after doing an insert into a table with no auto generated keys And there has been no one-row insert into a table with auto-generated keys yet. We should get a resultset with one row of NULL value from getGeneratedKeys 1 - - {12} + {null} Now try the same test again but this time with Statement.executeUpdate. It should behave the same 1 - - {12} + {null} Now try the same test again but this time with PreparedStatement.execute. It should behave the same 1 - - {12} + {null} Now try the same test again but this time with PreparedStatement.executeUpdate. It should behave the same 1 - - {12} + {null} Test 5a - request for generated keys after doing a one-row insert(using a subquery) into a table with autogenerated key using a subquery with auto generated keys Even though this is a one-row insert but since insert has a sub-select, get generated keys will return one row of NULL value 1 - - {6} + {null} Now try the same test again but this time with Statement.executeUpdate. It should behave the same 1 - - {12} + {null} Now try the same test again but this time with PreparedStatement.execute. It should behave the same 1 - - {18} + {null} Now try the same test again but this time with PreparedStatement.executeUpdate. It should behave the same 1 - - {24} + {null} Test 5b - request for generated keys after doing a one-row insert(using a subquery) into a table with autogenerated key using a subquery with auto generated keys Even though this is a one-row insert but since insert has a sub-select, get generated keys will return one row of NULL value 1 - - {0} + {null} Now try the same test again but this time with Statement.executeUpdate. It should behave the same 1 - - {0} + {null} Now try the same test again but this time with PreparedStatement.execute. It should behave the same 1 - - {0} + {null} Now try the same test again but this time with PreparedStatement.executeUpdate. It should behave the same 1 - - {0} + {null} Test 5c - request for generated keys after doing a one-row insert(using a subquery) into a table with autogenerated key using a subquery with auto generated keys Even though this is a one-row insert but since insert has a sub-select, get generated keys will return one row of NULL value 1 - - {25} + {null} Now try the same test again but this time with Statement.executeUpdate. It should behave the same 1 - - {26} + {null} Now try the same test again but this time with PreparedStatement.execute. It should behave the same 1 - - {27} + {null} Now try the same test again but this time with PreparedStatement.executeUpdate. It should behave the same 1 - - {28} + {null} Test 6 - request for generated keys after doing a one-row insert into a table with auto generated keys We should get a resultset with one row of non-NULL value 1 @@ -115,37 +115,37 @@ This time we will get a row of non-NULL value because there has been a prior one-row insert into table with auto-generated key 1 - - {15} + {32} Now try the same test again but this time with Statement.executeUpdate. It should behave the same 1 - - {18} + {32} Now try the same test again but this time with PreparedStatement.execute. It should behave the same 1 - - {21} + {32} Now try the same test again but this time with PreparedStatement.executeUpdate. It should behave the same 1 - - {24} + {32} Test 8 - create a new statement and request for generated keys on it after doing an insert into a table with no auto generated keys We should get a resultset with one row of non-NULL value 1 - - {24} + {32} Now try the same test again but this time with Statement.executeUpdate. It should behave the same 1 - - {24} + {32} Now try the same test again but this time with PreparedStatement.execute. It should behave the same 1 - - {24} + {32} Now try the same test again but this time with PreparedStatement.executeUpdate. It should behave the same 1 - - {24} + {32} Test 9 - request for generated keys on a statement which does a update We should get a resultset with no rows from getGeneratedKeys because we executed a non-insert sql @@ -169,37 +169,37 @@ expected to see resultset with one row of NULL value but instead get one row of non-NULL value from getGeneratedKeys 1 - - {24} + {32} Now try the same test again but this time with Statement.executeUpdate. It should behave the same 1 - - {24} + {32} Now try the same test again but this time with PreparedStatement.execute. It should behave the same 1 - - {24} + {32} Now try the same test again but this time with PreparedStatement.executeUpdate. It should behave the same 1 - - {24} + {32} Test 12 - do a rollback and request for generated keys on a statement which does insert into a table with no auto generated keys (previous transaction had a one-row insert on a table with auto-generated keys) had expected to see resultset with one row of NULL value but instead get one row of non-NULL value from getGeneratedKeys 1 - - {24} + {32} Now try the same test again but this time with Statement.executeUpdate. It should behave the same 1 - - {24} + {32} Now try the same test again but this time with PreparedStatement.execute. It should behave the same 1 - - {24} + {32} Now try the same test again but this time with PreparedStatement.executeUpdate. It should behave the same 1 - - {24} + {32} Test 13 - try savepoint rollback and see what happens to auto generated keys resultset Inside the savepoint unit, issue a one-row insert into a table with auto generated keys We should get a resultset with one row of non-NULL value Modified: db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/j9_foundation/floattypes.out URL: http://svn.apache.org/viewvc/db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/j9_foundation/floattypes.out?rev=439209&r1=439208&r2=439209&view=diff ============================================================================== --- db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/j9_foundation/floattypes.out (original) +++ db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/j9_foundation/floattypes.out Thu Aug 31 23:37:39 2006 @@ -50,13 +50,13 @@ ------ 1 ij> values cast (1.1 as dec(5,3)); -1 --------- -1.100 +1 +------- +1.100 ij> values cast (1.1 as numeric(5,3)); -1 --------- -1.100 +1 +------- +1.100 ij> -- cast to all valid types values cast (1.1 as int); 1 @@ -393,15 +393,15 @@ 1.0 1.0 ij> select cast(d as dec(10,2)) from tmp; -1 -------------- -1.00 -1.00 +1 +------------ +1.00 +1.00 ij> select cast(d as dec(10,8)) from tmp; -1 -------------- -1.00000000 -1.00000000 +1 +------------ +1.00000000 +1.00000000 ij> drop table tmp; 0 rows inserted/updated/deleted ij> drop table t; @@ -440,12 +440,12 @@ ); 1 row inserted/updated/deleted ij> select dc from t; -DC -------------- -NULL -10.00 --10.00 -0.00 +DC +------------ +NULL +10.00 +-10.00 +0.00 ij> select dc + i, dc + s, dc + r, dc + dc from t; 1 |2 |3 |4 ------------------------------------------------------------ @@ -484,11 +484,11 @@ 0.0 |0.0 ij> -- test null/null, constant/null, null/constant select dc, i / dc, 10 / dc, dc / 10e0 from t; -DC |2 |3 |4 ----------------------------------------------------------------------------------------------------------- -NULL |NULL |NULL |NULL -10.00 |1.0000000000000000000 |1.0000000000000000000 |1.0 --10.00 |1.0000000000000000000 |-1.0000000000000000000 |-1.0 +DC |2 |3 |4 +--------------------------------------------------------------------------------------------------------- +NULL |NULL |NULL |NULL +10.00 |1.0000000000000000000 |1.0000000000000000000 |1.0 +-10.00 |1.0000000000000000000 |-1.0000000000000000000 |-1.0 ERROR 22012: Attempt to divide by zero. ij> -- test for divide by 0 select dc / i from t; @@ -507,20 +507,20 @@ 1.0 |1.0 ij> -- test positive/negative, negative/positive and negative/negative select dc, dc / -dc, (-dc) / dc, (-dc) / -dc from t; -DC |2 |3 |4 ----------------------------------------------------------------------------------------------------------------------- -NULL |NULL |NULL |NULL -10.00 |-1.000000000000000000000 |-1.000000000000000000000 |1.000000000000000000000 --10.00 |-1.000000000000000000000 |-1.000000000000000000000 |1.000000000000000000000 +DC |2 |3 |4 +--------------------------------------------------------------------------------------------------------------------- +NULL |NULL |NULL |NULL +10.00 |-1.000000000000000000000 |-1.000000000000000000000 |1.000000000000000000000 +-10.00 |-1.000000000000000000000 |-1.000000000000000000000 |1.000000000000000000000 ERROR 22012: Attempt to divide by zero. ij> -- test some "more complex" expressions select dc, dc + 10e0, dc - (10 - 20e0), dc - 10, dc - (20 - 10) from t; -DC |2 |3 |4 |5 ---------------------------------------------------------------------------------------------- -NULL |NULL |NULL |NULL |NULL -10.00 |20.0 |20.0 |0.00 |0.00 --10.00 |0.0 |0.0 |-20.00 |-20.00 -0.00 |10.0 |10.0 |-10.00 |-10.00 +DC |2 |3 |4 |5 +-------------------------------------------------------------------------------------------- +NULL |NULL |NULL |NULL |NULL +10.00 |20.0 |20.0 |0.00 |0.00 +-10.00 |0.0 |0.0 |-20.00 |-20.00 +0.00 |10.0 |10.0 |-10.00 |-10.00 ij> -- make sure we get the right scale/precision during arithmetic values (9.0 + 9.0); 1 @@ -621,9 +621,9 @@ -- cast(1.7e308 as dec(2147483647)))); -- values cast(1 as dec(31, 20)); -1 ----------------------------------- -1.00000000000000000000 +1 +--------------------------------- +1.00000000000000000000 ij> -- test the arithmetic operators on a type we know they don't work on create table w (x dec, y long varchar); 0 rows inserted/updated/deleted @@ -651,314 +651,314 @@ 1 row inserted/updated/deleted ij> -- test = select dc from t where dc is null; -DC -------------- -NULL +DC +------------ +NULL ij> select dc from t where dc = 10; -DC -------------- -10.00 +DC +------------ +10.00 ij> select dc from t where dc = -10; -DC -------------- --10.00 +DC +------------ +-10.00 ij> select dc from t where dc = 0; -DC -------------- -0.00 +DC +------------ +0.00 ij> select dc from t where dc = 1234.45; -DC -------------- +DC +------------ ij> select dc from t where dc = i; -DC -------------- -10.00 --10.00 -0.00 +DC +------------ +10.00 +-10.00 +0.00 ij> select dc from t where dc = l; -DC -------------- -10.00 --10.00 -0.00 +DC +------------ +10.00 +-10.00 +0.00 ij> select dc from t where dc = s; -DC -------------- -10.00 --10.00 -0.00 +DC +------------ +10.00 +-10.00 +0.00 ij> select dc from t where dc = r; -DC -------------- -10.00 --10.00 -0.00 -1234.56 +DC +------------ +10.00 +-10.00 +0.00 +1234.56 ij> select dc from t where dc = d; -DC -------------- -10.00 --10.00 -0.00 -1234.56 +DC +------------ +10.00 +-10.00 +0.00 +1234.56 ij> select dc from t where dc = dc; -DC -------------- -10.00 --10.00 -0.00 -1234.56 +DC +------------ +10.00 +-10.00 +0.00 +1234.56 ij> -- test > select dc from t where dc > 10; -DC -------------- -1234.56 +DC +------------ +1234.56 ij> select dc from t where dc > -10; -DC -------------- -10.00 -0.00 -1234.56 +DC +------------ +10.00 +0.00 +1234.56 ij> select dc from t where dc > 0; -DC -------------- -10.00 -1234.56 +DC +------------ +10.00 +1234.56 ij> select dc from t where dc > 1234.45; -DC -------------- -1234.56 +DC +------------ +1234.56 ij> select dc from t where dc > i; -DC -------------- -1234.56 +DC +------------ +1234.56 ij> select dc from t where dc > l; -DC -------------- -1234.56 +DC +------------ +1234.56 ij> select dc from t where dc > s; -DC -------------- -1234.56 +DC +------------ +1234.56 ij> select dc from t where dc > r; -DC -------------- +DC +------------ ij> select dc from t where dc > d; -DC -------------- +DC +------------ ij> select dc from t where dc > dc; -DC -------------- +DC +------------ ij> -- test >= select dc from t where dc >= 10; -DC -------------- -10.00 -1234.56 +DC +------------ +10.00 +1234.56 ij> select dc from t where dc >= -10; -DC -------------- -10.00 --10.00 -0.00 -1234.56 +DC +------------ +10.00 +-10.00 +0.00 +1234.56 ij> select dc from t where dc >= 0; -DC -------------- -10.00 -0.00 -1234.56 +DC +------------ +10.00 +0.00 +1234.56 ij> select dc from t where dc >= 1234.45; -DC -------------- -1234.56 +DC +------------ +1234.56 ij> select dc from t where dc >= i; -DC -------------- -10.00 --10.00 -0.00 -1234.56 +DC +------------ +10.00 +-10.00 +0.00 +1234.56 ij> select dc from t where dc >= l; -DC -------------- -10.00 --10.00 -0.00 -1234.56 +DC +------------ +10.00 +-10.00 +0.00 +1234.56 ij> select dc from t where dc >= s; -DC -------------- -10.00 --10.00 -0.00 -1234.56 +DC +------------ +10.00 +-10.00 +0.00 +1234.56 ij> select dc from t where dc >= r; -DC -------------- -10.00 --10.00 -0.00 -1234.56 +DC +------------ +10.00 +-10.00 +0.00 +1234.56 ij> select dc from t where dc >= d; -DC -------------- -10.00 --10.00 -0.00 -1234.56 +DC +------------ +10.00 +-10.00 +0.00 +1234.56 ij> select dc from t where dc >= dc; -DC -------------- -10.00 --10.00 -0.00 -1234.56 +DC +------------ +10.00 +-10.00 +0.00 +1234.56 ij> -- test < select dc from t where dc < 10; -DC -------------- --10.00 -0.00 +DC +------------ +-10.00 +0.00 ij> select dc from t where dc < -10; -DC -------------- +DC +------------ ij> select dc from t where dc < 0; -DC -------------- --10.00 +DC +------------ +-10.00 ij> select dc from t where dc < 1234.45; -DC -------------- -10.00 --10.00 -0.00 +DC +------------ +10.00 +-10.00 +0.00 ij> select dc from t where dc < i; -DC -------------- +DC +------------ ij> select dc from t where dc < l; -DC -------------- +DC +------------ ij> select dc from t where dc < s; -DC -------------- +DC +------------ ij> select dc from t where dc < r; -DC -------------- +DC +------------ ij> select dc from t where dc < d; -DC -------------- +DC +------------ ij> select dc from t where dc < dc; -DC -------------- +DC +------------ ij> -- test <= select dc from t where dc <= 10; -DC -------------- -10.00 --10.00 -0.00 +DC +------------ +10.00 +-10.00 +0.00 ij> select dc from t where dc <= -10; -DC -------------- --10.00 +DC +------------ +-10.00 ij> select dc from t where dc <= 0; -DC -------------- --10.00 -0.00 +DC +------------ +-10.00 +0.00 ij> select dc from t where dc <= 1234.45; -DC -------------- -10.00 --10.00 -0.00 +DC +------------ +10.00 +-10.00 +0.00 ij> select dc from t where dc <= i; -DC -------------- -10.00 --10.00 -0.00 +DC +------------ +10.00 +-10.00 +0.00 ij> select dc from t where dc <= l; -DC -------------- -10.00 --10.00 -0.00 +DC +------------ +10.00 +-10.00 +0.00 ij> select dc from t where dc <= s; -DC -------------- -10.00 --10.00 -0.00 +DC +------------ +10.00 +-10.00 +0.00 ij> select dc from t where dc <= r; -DC -------------- -10.00 --10.00 -0.00 -1234.56 +DC +------------ +10.00 +-10.00 +0.00 +1234.56 ij> select dc from t where dc <= d; -DC -------------- -10.00 --10.00 -0.00 -1234.56 +DC +------------ +10.00 +-10.00 +0.00 +1234.56 ij> select dc from t where dc <= dc; -DC -------------- -10.00 --10.00 -0.00 -1234.56 +DC +------------ +10.00 +-10.00 +0.00 +1234.56 ij> -- test <> select dc from t where dc <> 10; -DC -------------- --10.00 -0.00 -1234.56 +DC +------------ +-10.00 +0.00 +1234.56 ij> select dc from t where dc <> -10; -DC -------------- -10.00 -0.00 -1234.56 +DC +------------ +10.00 +0.00 +1234.56 ij> select dc from t where dc <> 0; -DC -------------- -10.00 --10.00 -1234.56 +DC +------------ +10.00 +-10.00 +1234.56 ij> select dc from t where dc <> 1234.45; -DC -------------- -10.00 --10.00 -0.00 -1234.56 +DC +------------ +10.00 +-10.00 +0.00 +1234.56 ij> select dc from t where dc <> i; -DC -------------- -1234.56 +DC +------------ +1234.56 ij> select dc from t where dc <> l; -DC -------------- -1234.56 +DC +------------ +1234.56 ij> select dc from t where dc <> s; -DC -------------- -1234.56 +DC +------------ +1234.56 ij> select dc from t where dc <> r; -DC -------------- +DC +------------ ij> select dc from t where dc <> d; -DC -------------- +DC +------------ ij> select dc from t where dc <> dc; -DC -------------- +DC +------------ ij> -- -- test a variety of inserts and updates -- @@ -982,65 +982,65 @@ update t2 set dc = dc + 1.1; 5 rows inserted/updated/deleted ij> select dc from t2; -DC -------------- --8.90 -1.10 -11.10 -1235.66 -NULL +DC +------------ +-8.90 +1.10 +11.10 +1235.66 +NULL ij> update t2 set dc = dc - 1.1; 5 rows inserted/updated/deleted ij> select dc from t2; -DC -------------- --10.00 -0.00 -10.00 -1234.56 -NULL +DC +------------ +-10.00 +0.00 +10.00 +1234.56 +NULL ij> update t2 set dc = dc / 1.1; 5 rows inserted/updated/deleted ij> select dc from t2; -DC -------------- --9.09 -0.00 -9.09 -1122.32 -NULL +DC +------------ +-9.09 +0.00 +9.09 +1122.32 +NULL ij> update t2 set dc = dc * 1.1; 5 rows inserted/updated/deleted ij> select dc from t2; -DC -------------- --9.99 -0.00 -9.99 -1234.55 -NULL +DC +------------ +-9.99 +0.00 +9.99 +1234.55 +NULL ij> -- try some deletes delete from t2 where dc > 0; 2 rows inserted/updated/deleted ij> select dc from t2; -DC -------------- --9.99 -0.00 -NULL +DC +------------ +-9.99 +0.00 +NULL ij> delete from t2 where dc = 0; 1 row inserted/updated/deleted ij> select dc from t2; -DC -------------- --9.99 -NULL +DC +------------ +-9.99 +NULL ij> delete from t2 where dc < 0; 1 row inserted/updated/deleted ij> select dc from t2; -DC -------------- -NULL +DC +------------ +NULL ij> drop table t2; 0 rows inserted/updated/deleted ij> drop table t; @@ -1074,33 +1074,33 @@ ij> insert into t values ('a', 9.123, 'Z'); 1 row inserted/updated/deleted ij> select * from t; -C1 |D |C2 ---------------------------------- -a |1.1230 |Z -a |11111.1230 |Z -a |11111111.1230 |Z -a |6.1230 |Z -a |666.1230 |Z -a |0.6000 |Z -a |0.0000 |Z -a |666666.1230 |Z -a |99999999999999.1230 |Z -a |9.1230 |Z +C1 |D |C2 +-------------------------------- +a |1.1230 |Z +a |11111.1230 |Z +a |11111111.1230 |Z +a |6.1230 |Z +a |666.1230 |Z +a |0.6000 |Z +a |0.0000 |Z +a |666666.1230 |Z +a |99999999999999.1230 |Z +a |9.1230 |Z ij> update t set d = d + .0007; 10 rows inserted/updated/deleted ij> select * from t; -C1 |D |C2 ---------------------------------- -a |1.1237 |Z -a |11111.1237 |Z -a |11111111.1237 |Z -a |6.1237 |Z -a |666.1237 |Z -a |0.6007 |Z -a |0.0007 |Z -a |666666.1237 |Z -a |99999999999999.1237 |Z -a |9.1237 |Z +C1 |D |C2 +-------------------------------- +a |1.1237 |Z +a |11111.1237 |Z +a |11111111.1237 |Z +a |6.1237 |Z +a |666.1237 |Z +a |0.6007 |Z +a |0.0007 |Z +a |666666.1237 |Z +a |99999999999999.1237 |Z +a |9.1237 |Z ij> drop table tmp; ERROR 42Y55: 'DROP TABLE' cannot be performed on 'TMP' because it does not exist. ij> drop table bad; @@ -2444,87 +2444,87 @@ ij> insert into tiger values (0.00000001234); 1 row inserted/updated/deleted ij> select d from tiger order by 1; -D ---------------- -0.00000001234 -0.00000001234 -0.00000012340 -0.00000123400 -0.00001234000 -0.00012340000 -0.00123400000 -0.00123400000 -0.01234000000 -0.12340000000 -1.23400000000 +D +-------------- +0.00000001234 +0.00000001234 +0.00000012340 +0.00000123400 +0.00001234000 +0.00012340000 +0.00123400000 +0.00123400000 +0.01234000000 +0.12340000000 +1.23400000000 ij> -- ===================================================== -- some formatting tests values cast ('1e+0' as DECIMAL(6,2)); -1 ---------- -1.00 +1 +-------- +1.00 ij> values cast ('+-1e+1' as DECIMAL(6,2)); -1 ---------- +1 +-------- ERROR 22018: Invalid character string format for type DECIMAL. ij> values cast ('-1e+1' as DECIMAL(6,2)); -1 ---------- --10.00 +1 +-------- +-10.00 ij> values cast ('-1e-1' as DECIMAL(6,2)); -1 ---------- --0.10 +1 +-------- +-0.10 ij> values cast ('-1e-+1' as DECIMAL(6,2)); -1 ---------- +1 +-------- ERROR 22018: Invalid character string format for type DECIMAL. ij> values cast ('-1e--1' as DECIMAL(6,2)); -1 ---------- +1 +-------- ERROR 22018: Invalid character string format for type DECIMAL. ij> values cast ('-1e+-1' as DECIMAL(6,2)); -1 ---------- +1 +-------- ERROR 22018: Invalid character string format for type DECIMAL. ij> values cast ('-1e+-1' as DECIMAL(6,2)); -1 ---------- +1 +-------- ERROR 22018: Invalid character string format for type DECIMAL. ij> values cast ('1.0e' as DECIMAL(6,2)); -1 ---------- +1 +-------- ERROR 22018: Invalid character string format for type DECIMAL. ij> values cast ('1.0e+' as DECIMAL(6,2)); -1 ---------- +1 +-------- ERROR 22018: Invalid character string format for type DECIMAL. ij> values cast ('1.0e-' as DECIMAL(6,2)); -1 ---------- +1 +-------- ERROR 22018: Invalid character string format for type DECIMAL. ij> values cast ('1.0ee' as DECIMAL(6,2)); -1 ---------- +1 +-------- ERROR 22018: Invalid character string format for type DECIMAL. ij> values cast ('123.' as DECIMAL(6,2)); -1 ---------- -123.00 +1 +-------- +123.00 ij> values cast ('1e' as DECIMAL(6,2)); -1 ---------- +1 +-------- ERROR 22018: Invalid character string format for type DECIMAL. ij> values cast ('1e1.0' as DECIMAL(6,2)); -1 ---------- +1 +-------- ERROR 22018: Invalid character string format for type DECIMAL. ij> values cast ('.3' as DECIMAL(6,2)); -1 ---------- -0.30 +1 +-------- +0.30 ij> values cast ('' as DECIMAL(6,2)); -1 ---------- +1 +-------- ERROR 22018: Invalid character string format for type DECIMAL. ij> Modified: db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/j9_foundation/iepnegativetests_ES.out URL: http://svn.apache.org/viewvc/db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/j9_foundation/iepnegativetests_ES.out?rev=439209&r1=439208&r2=439209&view=diff ============================================================================== --- db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/j9_foundation/iepnegativetests_ES.out (original) +++ db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/j9_foundation/iepnegativetests_ES.out Thu Aug 31 23:37:39 2006 @@ -17,17 +17,17 @@ ij> --export table not found call SYSCS_UTIL.SYSCS_EXPORT_TABLE ('IEP', 'NOTABLE' , 'extinout/t1.dat' , null, null, null) ; -ERROR 38000: Se he generado la excepci EnC:>243< n 'SQL Exception: La tabla 'IEP.NOTABLE' no existe.' al evaluar una expresi EnC:>243< n. +ERROR 38000: Se he generado la excepci EnC:>243< n 'java.sql.SQLException: La tabla 'IEP.NOTABLE' no existe.' al evaluar una expresi EnC:>243< n. ERROR 42X05: La tabla 'IEP.NOTABLE' no existe. ij> ---export schema is not valid call SYSCS_UTIL.SYSCS_EXPORT_TABLE ('XXXX', 'T1' , 'extinout/t1.dat' , null, null, null) ; -ERROR 38000: Se he generado la excepci EnC:>243< n 'SQL Exception: El esquema 'XXXX' no existe.' al evaluar una expresi EnC:>243< n. +ERROR 38000: Se he generado la excepci EnC:>243< n 'java.sql.SQLException: El esquema 'XXXX' no existe.' al evaluar una expresi EnC:>243< n. ERROR 42Y07: El esquema 'XXXX' no existe. ij> --export query is invalid (syntax error) call SYSCS_UTIL.SYSCS_EXPORT_QUERY('select from t1', 'extinout/t1.dat' , null, null, null) ; -ERROR 38000: Se he generado la excepci EnC:>243< n 'SQL Exception: Error de sintaxis: Encountered "from" at line 1, column 8.' al evaluar una expresi EnC:>243< n. +ERROR 38000: Se he generado la excepci EnC:>243< n 'java.sql.SQLException: Error de sintaxis: Encountered "from" at line 1, column 8.' al evaluar una expresi EnC:>243< n. ERROR 42X01: Error de sintaxis: Encountered "from" at line 1, column 8. ij> --export codeset is invalid call SYSCS_UTIL.SYSCS_EXPORT_QUERY('select * from iep.t1', @@ -35,7 +35,7 @@ ERROR XIE0I: Se ha producido una excepci EnC:>243< n de E/S al grabar datos en el archivo. ij> call SYSCS_UTIL.SYSCS_EXPORT_TABLE ('XXXX', 'T1' , 'extinout/t1.dat' , null, null, null) ; -ERROR 38000: Se he generado la excepci EnC:>243< n 'SQL Exception: El esquema 'XXXX' no existe.' al evaluar una expresi EnC:>243< n. +ERROR 38000: Se he generado la excepci EnC:>243< n 'java.sql.SQLException: El esquema 'XXXX' no existe.' al evaluar una expresi EnC:>243< n. ERROR 42Y07: El esquema 'XXXX' no existe. ij> --export delimiter errror cases --period can not be used as character ot column delimiter @@ -96,7 +96,7 @@ --import can not find input file call SYSCS_UTIL.SYSCS_IMPORT_TABLE('IEP', 'T1' , 'extin/nodir/t1.dat' , null, null, null, 0) ; -ERROR 38000: Se he generado la excepci EnC:>243< n 'SQL Exception: Se he generado la excepci EnC:>243< n 'java.lang.reflect.InvocationTargetException' al evaluar una expresi EnC:>243< n.' al evaluar una expresi EnC:>243< n. +ERROR 38000: Se he generado la excepci EnC:>243< n 'java.sql.SQLException: Se he generado la excepci EnC:>243< n 'java.lang.reflect.InvocationTargetException' al evaluar una expresi EnC:>243< n.' al evaluar una expresi EnC:>243< n. ERROR 38000: Se he generado la excepci EnC:>243< n 'java.lang.reflect.InvocationTargetException' al evaluar una expresi EnC:>243< n. ERROR XJ001: Excepci EnC:>243< n de Java: ': java.lang.reflect.InvocationTargetException'. ERROR XIE04: Archivo de datos no encontrado: extin/nodir/t1.dat @@ -110,7 +110,7 @@ ERROR XIE0M: La tabla 'XXXX.T1' no existe. ij> call SYSCS_UTIL.SYSCS_IMPORT_TABLE ('IEP', 'T1' , 'extinout/t1.dat' , null, null, 'INCORRECTCODESET', 0) ; -ERROR 38000: Se he generado la excepci EnC:>243< n 'SQL Exception: Se he generado la excepci EnC:>243< n 'java.lang.reflect.InvocationTargetException' al evaluar una expresi EnC:>243< n.' al evaluar una expresi EnC:>243< n. +ERROR 38000: Se he generado la excepci EnC:>243< n 'java.sql.SQLException: Se he generado la excepci EnC:>243< n 'java.lang.reflect.InvocationTargetException' al evaluar una expresi EnC:>243< n.' al evaluar una expresi EnC:>243< n. ERROR 38000: Se he generado la excepci EnC:>243< n 'java.lang.reflect.InvocationTargetException' al evaluar una expresi EnC:>243< n. ERROR XJ001: Excepci EnC:>243< n de Java: ': java.lang.reflect.InvocationTargetException'. ERROR XJ001: Excepci EnC:>243< n de Java: 'java.io.UnsupportedEncodingException: INCORRECTCODESET'. @@ -119,20 +119,20 @@ --and the that should become a invalid delimiter call SYSCS_UTIL.SYSCS_IMPORT_TABLE ('IEP', 'T1' , 'extinout/t1.dat' , '', ';', null, 0) ; -ERROR 38000: Se he generado la excepci EnC:>243< n 'SQL Exception: Se he generado la excepci EnC:>243< n 'java.lang.reflect.InvocationTargetException' al evaluar una expresi EnC:>243< n.' al evaluar una expresi EnC:>243< n. +ERROR 38000: Se he generado la excepci EnC:>243< n 'java.sql.SQLException: Se he generado la excepci EnC:>243< n 'java.lang.reflect.InvocationTargetException' al evaluar una expresi EnC:>243< n.' al evaluar una expresi EnC:>243< n. ERROR 38000: Se he generado la excepci EnC:>243< n 'java.lang.reflect.InvocationTargetException' al evaluar una expresi EnC:>243< n. ERROR XJ001: Excepci EnC:>243< n de Java: ': java.lang.reflect.InvocationTargetException'. ERROR XIE0J: Un delimitador no es v EnC:>225< lido o se ha utilizado m EnC:>225< s de una vez. ij> call SYSCS_UTIL.SYSCS_IMPORT_TABLE ('IEP', 'T1' , 'extinout/t1.dat' , null, '', null, 0) ; -ERROR 38000: Se he generado la excepci EnC:>243< n 'SQL Exception: Se he generado la excepci EnC:>243< n 'java.lang.reflect.InvocationTargetException' al evaluar una expresi EnC:>243< n.' al evaluar una expresi EnC:>243< n. +ERROR 38000: Se he generado la excepci EnC:>243< n 'java.sql.SQLException: Se he generado la excepci EnC:>243< n 'java.lang.reflect.InvocationTargetException' al evaluar una expresi EnC:>243< n.' al evaluar una expresi EnC:>243< n. ERROR 38000: Se he generado la excepci EnC:>243< n 'java.lang.reflect.InvocationTargetException' al evaluar una expresi EnC:>243< n. ERROR XJ001: Excepci EnC:>243< n de Java: ': java.lang.reflect.InvocationTargetException'. ERROR XIE0J: Un delimitador no es v EnC:>225< lido o se ha utilizado m EnC:>225< s de una vez. ij> --same delimter can not be used as character and column delimters call SYSCS_UTIL.SYSCS_IMPORT_TABLE ('IEP', 'T1' , 'extinout/t1.dat' , ';', ';', null, 1) ; -ERROR 38000: Se he generado la excepci EnC:>243< n 'SQL Exception: Se he generado la excepci EnC:>243< n 'java.lang.reflect.InvocationTargetException' al evaluar una expresi EnC:>243< n.' al evaluar una expresi EnC:>243< n. +ERROR 38000: Se he generado la excepci EnC:>243< n 'java.sql.SQLException: Se he generado la excepci EnC:>243< n 'java.lang.reflect.InvocationTargetException' al evaluar una expresi EnC:>243< n.' al evaluar una expresi EnC:>243< n. ERROR 38000: Se he generado la excepci EnC:>243< n 'java.lang.reflect.InvocationTargetException' al evaluar una expresi EnC:>243< n. ERROR XJ001: Excepci EnC:>243< n de Java: ': java.lang.reflect.InvocationTargetException'. ERROR XIE0J: Un delimitador no es v EnC:>225< lido o se ha utilizado m EnC:>225< s de una vez. @@ -241,12 +241,12 @@ call SYSCS_UTIL.SYSCS_IMPORT_DATA('IEP', 'T3' , 'C1, C2, C3,C4', '1,2', 'extinout/t3.dat' , null, null, null, 0) ; -ERROR 38000: Se he generado la excepci EnC:>243< n 'SQL Exception: El n EnC:>250< mero de valores asignado no coincide con el n EnC:>250< mero de columnas especificadas o impl EnC:>237< citas.' al evaluar una expresi EnC:>243< n. +ERROR 38000: Se he generado la excepci EnC:>243< n 'java.sql.SQLException: El n EnC:>250< mero de valores asignado no coincide con el n EnC:>250< mero de columnas especificadas o impl EnC:>237< citas.' al evaluar una expresi EnC:>243< n. ERROR 42802: El n EnC:>250< mero de valores asignado no coincide con el n EnC:>250< mero de columnas especificadas o impl EnC:>237< citas. ij> call SYSCS_UTIL.SYSCS_IMPORT_DATA('IEP', 'T3' , null, '11,22,12,24', 'extinout/t3.dat' , EnC:>9< EnC:>9< EnC:>9< EnC:>9< null, null, null, 0) ; -ERROR 38000: Se he generado la excepci EnC:>243< n 'SQL Exception: La columna 'COLUMN11' no est EnC:>225< en ninguna tabla de la lista FROM o aparece en una especificaci EnC:>243< n de uni EnC:>243< n y est EnC:>225< fuera del EnC:>225< mbito de la especificaci EnC:>243< n de uni EnC:>243< n o bien aparece en una cl EnC:>225< usula HAVING y no est EnC:>225< en la lista GROUP BY. Si se trata de una sentencia CREATE o ALTER TABLE entonces 'COLUMN11' no es una columna de la tabla destino.' al evaluar una expresi EnC:>243< n. +ERROR 38000: Se he generado la excepci EnC:>243< n 'java.sql.SQLException: La columna 'COLUMN11' no est EnC:>225< en ninguna tabla de la lista FROM o aparece en una especificaci EnC:>243< n de uni EnC:>243< n y est EnC:>225< fuera del EnC:>225< mbito de la especificaci EnC:>243< n de uni EnC:>243< n o bien aparece en una cl EnC:>225< usula HAVING y no est EnC:>225< en la lista GROUP BY. Si se trata de una sentencia CREATE o ALTER TABLE entonces 'COLUMN11' no es una columna de la tabla destino.' al evaluar una expresi EnC:>243< n. ERROR 42X04: La columna 'COLUMN11' no est EnC:>225< en ninguna tabla de la lista FROM o aparece en una especificaci EnC:>243< n de uni EnC:>243< n y est EnC:>225< fuera del EnC:>225< mbito de la especificaci EnC:>243< n de uni EnC:>243< n o bien aparece en una cl EnC:>225< usula HAVING y no est EnC:>225< en la lista GROUP BY. Si se trata de una sentencia CREATE o ALTER TABLE entonces 'COLUMN11' no es una columna de la tabla destino. ij> --repeat the above type cases with empty file and minor variation to paramters delete from t3 ; @@ -272,7 +272,7 @@ call SYSCS_UTIL.SYSCS_IMPORT_DATA('IEP', 'T3' , null, '1,2', 'extinout/t3.dat' , EnC:>9< EnC:>9< EnC:>9< EnC:>9< ';', '^', 'utf-16', 1) ; -ERROR 38000: Se he generado la excepci EnC:>243< n 'SQL Exception: El n EnC:>250< mero de valores asignado no coincide con el n EnC:>250< mero de columnas especificadas o impl EnC:>237< citas.' al evaluar una expresi EnC:>243< n. +ERROR 38000: Se he generado la excepci EnC:>243< n 'java.sql.SQLException: El n EnC:>250< mero de valores asignado no coincide con el n EnC:>250< mero de columnas especificadas o impl EnC:>237< citas.' al evaluar una expresi EnC:>243< n. ERROR 42802: El n EnC:>250< mero de valores asignado no coincide con el n EnC:>250< mero de columnas especificadas o impl EnC:>237< citas. ij> --specify column indexes that are not there in the file that is being imported call SYSCS_UTIL.SYSCS_IMPORT_DATA('IEP', 'T3' , null, '11,22,12,24', @@ -282,7 +282,7 @@ ij> --import to a system table shoud fail call SYSCS_UTIL.SYSCS_IMPORT_TABLE ('SYS', 'SYSTABLES' , 'extinout/t3.dat' , ';', '^', 'utf-16', 1) ; -ERROR 38000: Se he generado la excepci EnC:>243< n 'SQL Exception: 'SYS.SYSTABLES' es una tabla del sistema. Los usuarios no tienen permitido modificar el contenido de esta tabla.' al evaluar una expresi EnC:>243< n. +ERROR 38000: Se he generado la excepci EnC:>243< n 'java.sql.SQLException: 'SYS.SYSTABLES' es una tabla del sistema. Los usuarios no tienen permitido modificar el contenido de esta tabla.' al evaluar una expresi EnC:>243< n. ERROR 42Y25: 'SYS.SYSTABLES' es una tabla del sistema. Los usuarios no tienen permitido modificar el contenido de esta tabla. ij> ---not supported by db2 cloudscape import/export create table ntype(a int , ct CLOB(1024)); @@ -323,7 +323,7 @@ call SYSCS_UTIL.SYSCS_SET_DATABASE_PROPERTY('derby.locks.waitTimeout', '5'); 0 rows inserted/updated/deleted ij(C2)> CALL SYSCS_UTIL.SYSCS_IMPORT_TABLE('IEP', 'PARENT', 'extinout/parent.del',null, null, null,1); -ERROR 38000: Se he generado la excepci EnC:>243< n 'SQL Exception: La tabla 'IEP.PARENT' no se puede bloquear en modalidad 'EXCLUSIVE'.' al evaluar una expresi EnC:>243< n. +ERROR 38000: Se he generado la excepci EnC:>243< n 'java.sql.SQLException: La tabla 'IEP.PARENT' no se puede bloquear en modalidad 'EXCLUSIVE'.' al evaluar una expresi EnC:>243< n. ERROR X0X02: La tabla 'IEP.PARENT' no se puede bloquear en modalidad 'EXCLUSIVE'. ERROR 40XL1: No se ha podido obtener un bloqueo dentro del tiempo solicitado ij(C2)> disconnect c1; Modified: db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/j9_foundation/resultset.out URL: http://svn.apache.org/viewvc/db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/j9_foundation/resultset.out?rev=439209&r1=439208&r2=439209&view=diff ============================================================================== --- db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/j9_foundation/resultset.out (original) +++ db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/j9_foundation/resultset.out Thu Aug 31 23:37:39 2006 @@ -177,7 +177,7 @@ isCurrency(10): true isNullable(10): 1 isSigned(10): true -getColumnDisplaySize(10): 13 +getColumnDisplaySize(10): 12 getColumnLabel(10): DC getColumnName(10): DC getTableName(10): T Modified: db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/tests/lang/floattypes_app.properties URL: http://svn.apache.org/viewvc/db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/tests/lang/floattypes_app.properties?rev=439209&r1=439208&r2=439209&view=diff ============================================================================== --- db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/tests/lang/floattypes_app.properties (original) +++ db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/tests/lang/floattypes_app.properties Thu Aug 31 23:37:39 2006 @@ -1,6 +1,5 @@ # # This is the default system properties file for SQL and JAVA tests. -# but modified to prevent this test from running with jdk131 # ij.database=jdbc:derby:wombat;create=true ij.protocol=jdbc:derby: @@ -13,6 +12,10 @@ ij.dataSource.databaseName=wombat ij.dataSource.createDatabase=create +# +# But modified to prevent this test from running with jdk131-based-DriverManager-using jvms +# because of odd failures, see DERBY-804 +# runwithjdk13=false runwithibm13=false runwithj9=false