You are viewing a plain text version of this content. The canonical link for it is here.
Posted to derby-dev@db.apache.org by Leo Li <li...@gmail.com> on 2006/10/10 11:00:02 UTC

[testing]Test fails

Hi, all:
     We have just run the testcase for derby but it fails on windows.
     The jdk we used is Sun 1.5.6.
     We runs:

     java org.apache.derbyTesting.functionTests.harness.RunTestlang/supersimple.sql

     Then gets:

      -- listing properties --
derby.locks.deadlockTimeout=3
derby.locks.waitTimeout=3
*** Start: supersimple jdk1.4.2_07 2006-10-10 16:32:31 ***
24 del
< SI |I |BI |R |F |D |N5_2 |DEC10_3 |CH20 |VC |LVC |BLOBCOL |CLOBCOL
25 del
<
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------

26 del
< 2 |3 |4 |5.3 |5.3 |5.3 |31.13 |123456.123 |one |one |one |01abcd |one
27 del
< -32768|-2147483648|-9223372036854775808|1.2E-37 |2.225E-307 |2.225E-307 |-
56.12 |-123456.123 |one |one |one |01abcd |one
28 del
< NULL |NULL |NULL |NULL |NULL |NULL |NULL |NULL |NULL |NULL |NULL |NULL
|NULL
29 del
< 32767 |2147483647 |9223372036854775807 |1.4 |3.4028235E38 |3.4028235E38
|999.99 |9999999.999 |one |one |one |01abcd |one
29a24,29
> SI |I |BI |R |F |D |N5_2 |DEC10_3 |CH20 |VC |LVC |BLOBCOL |CLOBCOL
>
---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------

> 2 |3 |4 |5.3 |5.3 |5.3 |31.13 |123456.123 |one |one |one |01abcd |one
> -32768|-2147483648|-9223372036854775808|1.2E-37 |2.225E-307 |2.225E-307 |-
56.12 |-123456.123 |one |one |one |01abcd |one
> NULL |NULL |NULL |NULL |NULL |NULL |NULL |NULL |NULL |NULL |NULL |NULL
|NULL
> 32767 |2147483647 |9223372036854775807 |1.4 |3.4028235E38 |3.4028235E38
|999.99 |9999999.999 |one |one |one |01abcd |one
39 del
< SI |I |BI |R |F |D |N5_2 |DEC10_3 |CH20 |VC |LVC |BLOBCOL |CLOBCOL
40 del
<
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------

41 del
< 2 |3 |4 |5.3 |5.3 |5.3 |31.13 |123456.123 |one |one |one |01abcd |one
42 del
< -32768|-2147483648|-9223372036854775808|1.2E-37 |2.225E-307 |2.225E-307 |-
56.12 |-123456.123 |one |one |one |01abcd |one
42a39,42
> SI |I |BI |R |F |D |N5_2 |DEC10_3 |CH20 |VC |LVC |BLOBCOL |CLOBCOL
>
---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------

> 2 |3 |4 |5.3 |5.3 |5.3 |31.13 |123456.123 |one |one |one |01abcd |one
> -32768|-2147483648|-9223372036854775808|1.2E-37 |2.225E-307 |2.225E-307 |-
56.12 |-123456.123 |one |one |one |01abcd |one
52 del
< 1
53 del
< -----
54 del
< 1.2
54a52,54
> 1
> ----
> 1.2
Test Failed.
*** End: supersimple jdk1.4.2_07 2006-10-10 16:32:41 ***


     Any suggestion? I am not sure of whether some arguments configuration
is required.
     Thank you.

-- 
Leo Li
China Software Development Lab, IBM

Re: [testing]Test fails

Posted by Sean Qiu <se...@gmail.com>.
This time i remove all the derby*.jar out
of the CLASSPATH and add the trunk/classes into it.
The lang/supersimple.sql test is passed and the test suite derbylang is also
successs.I will try the derbyall right now.

But i still have no idea why i failed previously.Maybe the version
difference caused the problem.
And thanks all of you anyway.

2006/10/11, Bryan Pendleton <bp...@amberpoint.com>:
>
> Sean Qiu wrote:
> > Any suggestions
> > to address issues through the infomation provided by the output files?
>
> I'm actually not sure what's going on with your test. It looks like the
> supersimple.out and supersimple.tmp files that you attached are in fact
> identical; the only exception is that your supersimple.tmp file contains
> an extra line at the beginning saying
>
>    ij version 10.2
>
> which is I think fine, and should not cause the diff that you saw.
>
> So I'm afraid I don't know what is causing the test harness to report
> the diff that you are seeing.
>
> bryan
>
>

Re: [testing]Test fails

Posted by Bryan Pendleton <bp...@amberpoint.com>.
Sean Qiu wrote:
> Any suggestions 
> to address issues through the infomation provided by the output files?

I'm actually not sure what's going on with your test. It looks like the
supersimple.out and supersimple.tmp files that you attached are in fact
identical; the only exception is that your supersimple.tmp file contains
an extra line at the beginning saying

   ij version 10.2

which is I think fine, and should not cause the diff that you saw.

So I'm afraid I don't know what is causing the test harness to report
the diff that you are seeing.

bryan

Re: [testing]Test fails

Posted by Sean Qiu <se...@gmail.com>.
Any suggestions
to address issues through the infomation provided by the output files?
So i can figure out the problem next time by myself :)
Thanks for your help*
**
supersimple.out*
===============================
ij> -- by default, holdability of ResultSet objects created using this
Connection object is true. Following will set it to false for this
connection.
NoHoldForConnection;
ij> create table a (a int);
0 rows inserted/updated/deleted

ij> insert into a values (1);
1 row inserted/updated/deleted
ij> select * from a;
A
-----------
1
ij> drop table a;
0 rows inserted/updated/deleted
ij> create table b (si smallint,i int, bi bigint, r real, f float, d double
precision, n5_2 numeric(5,2), dec10_3 decimal(10,3), ch20 char(20),vc
varchar(20), lvc long varchar, blobCol blob(1000), clobCol clob(1000));
0 rows inserted/updated/deleted
ij> insert into b values(2,3,4,5.3,5.3,5.3,31.13,123456.123,
'one','one','one',cast(X'01ABCD' as blob(1000)),'one');
1 row inserted/updated/deleted
ij> insert into b values(-32768,-2147483648, -9223372036854775808 ,1.2E-37,
2.225E-307, +2.225E-307,-56.12, -123456.123,'one','one','one',
cast(X'01ABCD' as blob(1000)),'one');
1 row inserted/updated/deleted
ij> insert into b
values(null,null,null,null,null,null,null,null,null,null,null,null,null);
1 row inserted/updated/deleted
ij> insert into b values(32767,2147483647, 9223372036854775807 ,1.4 ,
3.4028235E38 ,3.4028235E38 ,999.99,
9999999.999,'one','one','one',cast(X'01ABCD'
as blob(1000)), 'one');
1 row inserted/updated/deleted
ij> select * from b;
SI |I |BI |R |F |D |N5_2 |DEC10_3 |CH20 |VC |LVC |BLOBCOL |CLOBCOL
---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
2 |3 |4 |5.3 |5.3 |5.3 |31.13 |123456.123 |one |one |one |01abcd |one
-32768|-2147483648|-9223372036854775808|1.2E-37 |2.225E-307 |2.225E-307 |-
56.12 |-123456.123 |one |one |one |01abcd |one
NULL |NULL |NULL |NULL |NULL |NULL |NULL |NULL |NULL |NULL |NULL |NULL |NULL

32767 |2147483647 |9223372036854775807 |1.4 |3.4028235E38 |3.4028235E38
|999.99 |9999999.999 |one |one |one |01abcd |one
ij> drop table b;
0 rows inserted/updated/deleted
ij> create table c (si smallint not null,i int not null , bi bigint not
null, r real not null, f float not null, d double precision not null, n5_2
numeric(5,2) not null , dec10_3 decimal(10,3) not null, ch20 char(20) not
null ,vc varchar(20) not null, lvc long varchar not null, blobCol blob(1000)
not null, clobCol clob(1000) not null);
0 rows inserted/updated/deleted
ij> insert into c values(2,3,4,5.3,5.3,5.3,31.13,123456.123,
'one','one','one', cast(X'01ABCD' as blob(1000)), 'one');
1 row inserted/updated/deleted
ij> insert into c values(-32768,-2147483648, -9223372036854775808 ,1.2E-37,
2.225E-307, +2.225E-307,-56.12, -123456.123,'one','one','one',
cast(X'01ABCD' as blob(1000)),'one');
1 row inserted/updated/deleted
ij> select * from c;
SI |I |BI |R |F |D |N5_2 |DEC10_3 |CH20 |VC |LVC |BLOBCOL |CLOBCOL
---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
2 |3 |4 |5.3 |5.3 |5.3 |31.13 |123456.123 |one |one |one |01abcd |one
-32768|-2147483648|-9223372036854775808|1.2E-37 |2.225E-307 |2.225E-307 |-
56.12 |-123456.123 |one |one |one |01abcd |one
ij> values(10);
1
-----------
10
ij> values('hello');
1
-----
hello
ij> values(1.2);
1
----
1.2
ij> drop table c;
0 rows inserted/updated/deleted
ij> -- bug 4430 aliasinfo nullability problem
select aliasinfo from sys.sysaliases where aliasinfo is null;
ALIASINFO
---------------
ij> -- test commit and rollback
autocommit off;
ij> create table a(a int);
0 rows inserted/updated/deleted
ij> insert into a values (1);
1 row inserted/updated/deleted
ij> select * from a;
A
-----------
1
ij> commit;
ij> drop table a;
0 rows inserted/updated/deleted
ij> rollback;
ij> select * from a;
A
-----------
1
ij> drop table a;
0 rows inserted/updated/deleted
ij> commit;
ij> autocommit on;
ij> maximumdisplaywidth 5000;
ij> --test 84 columns
values(1, 2, 3, 4, 5, 6, 7, 8, 9, 10,
11, 12, 13, 14, 15, 16, 17, 18, 19, 20,
21, 22, 23, 24, 25, 26, 27, 28, 29, 30,
31, 32, 33, 34, 35, 36, 37, 38, 39, 40,
41, 42, 43, 44, 45, 46, 47, 48, 49, 50,
51, 52, 53, 54, 55, 56, 57, 58, 59, 60,
61, 62, 63, 64, 65, 66, 67, 68, 69, 70,
71, 72, 73, 74, 75, 76, 77, 78, 79, 80,
81, 82, 83, 84);
1 |2 |3 |4 |5 |6 |7 |8 |9 |10 |11 |12 |13 |14 |15 |16 |17 |18 |19 |20 |21
|22 |23 |24 |25 |26 |27 |28 |29 |30 |31 |32 |33 |34 |35 |36 |37 |38 |39 |40
|41 |42 |43 |44 |45 |46 |47 |48 |49 |50 |51 |52 |53 |54 |55 |56 |57 |58 |59
|60 |61 |62 |63 |64 |65 |66 |67 |68 |69 |70 |71 |72 |73 |74 |75 |76 |77 |78
|79 |80 |81 |82 |83 |84
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
1 |2 |3 |4 |5 |6 |7 |8 |9 |10 |11 |12 |13 |14 |15 |16 |17 |18 |19 |20 |21
|22 |23 |24 |25 |26 |27 |28 |29 |30 |31 |32 |33 |34 |35 |36 |37 |38 |39 |40
|41 |42 |43 |44 |45 |46 |47 |48 |49 |50 |51 |52 |53 |54 |55 |56 |57 |58 |59
|60 |61 |62 |63 |64 |65 |66 |67 |68 |69 |70 |71 |72 |73 |74 |75 |76 |77 |78
|79 |80 |81 |82 |83 |84
ij> values(1, 2, 3, 4, 5, 6, 7, 8, 9, 10,
11, 12, 13, 14, 15, 16, 17, 18, 19, 20,
21, 22, 23, 24, 25, 26, 27, 28, 29, 30,
31, 32, 33, 34, 35, 36, 37, 38, 39, 40,
41, 42, 43, 44, 45, 46, 47, 48, 49, 50,
51, 52, 53, 54, 55, 56, 57, 58, 59, 60,
61, 62, 63, 64, 65, 66, 67, 68, 69, 70,
71, 72, 73, 74, 75, 76, 77, 78, 79, 80,
81, 82, 83, 84, 85, 86, 87, 88, 89, 90,
91, 92, 93, 94, 95, 96, 97, 98, 99, 100);
1 |2 |3 |4 |5 |6 |7 |8 |9 |10 |11 |12 |13 |14 |15 |16 |17 |18 |19 |20 |21
|22 |23 |24 |25 |26 |27 |28 |29 |30 |31 |32 |33 |34 |35 |36 |37 |38 |39 |40
|41 |42 |43 |44 |45 |46 |47 |48 |49 |50 |51 |52 |53 |54 |55 |56 |57 |58 |59
|60 |61 |62 |63 |64 |65 |66 |67 |68 |69 |70 |71 |72 |73 |74 |75 |76 |77 |78
|79 |80 |81 |82 |83 |84 |85 |86
----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
1 |2 |3 |4 |5 |6 |7 |8 |9 |10 |11 |12 |13 |14 |15 |16 |17 |18 |19 |20 |21
|22 |23 |24 |25 |26 |27 |28 |29 |30 |31 |32 |33 |34 |35 |36 |37 |38 |39 |40
|41 |42 |43 |44 |45 |46 |47 |48 |49 |50 |51 |52 |53 |54 |55 |56 |57 |58 |59
|60 |61 |62 |63 |64 |65 |66 |67 |68 |69 |70 |71 |72 |73 |74 |75 |76 |77 |78
|79 |80 |81 |82 |83 |84 |85 |86 |87 |88 |89 |90 |91 |92 |93 |94 |95 |96 |97
|98 |99 |100
ij> -- test SQL Error with non-string arguments
-- Make sure connection still ok (Bug 4657)
create table a (a int);
0 rows inserted/updated/deleted
ij> insert into a values(2342323423) ;
ERROR 22003: The resulting value is outside the range for the data type
INTEGER.
ij> insert into a values(1);
1 row inserted/updated/deleted
ij> select * from a;
A
-----------
1
ij> drop table a;
0 rows inserted/updated/deleted
ij> -- Bug 4694 Test automatic rollback with close of connection
-- in ij
autocommit off;
ij> create table a (a int);
0 rows inserted/updated/deleted
ij> -- Bug 4758 - Store error does not return properly to client
autocommit off;
ij> create table t (i int);
0 rows inserted/updated/deleted
ij> insert into t values(1);
1 row inserted/updated/deleted
ij> commit;
ij> insert into t values(2);
1 row inserted/updated/deleted
ij> connect 'wombat';
ij(CONNECTION1)> -- by default, holdability of ResultSet objects created
using this Connection object is true. Following will set it to false for
this connection.
NoHoldForConnection;
ij(CONNECTION1)> prepare s1 as 'select * from t';
ij(CONNECTION1)> execute s1;
I
-----------
ERROR 40XL1: A lock could not be obtained within the time requested
ij(CONNECTION1)> execute s1;
I
-----------
ERROR 40XL1: A lock could not be obtained within the time requested
ij(CONNECTION1)> -- Bug 5967 - Selecting from 2 lob columns w/ the first one
having data of length 0
create table t1 (c1 clob(10), c2 clob(10));
0 rows inserted/updated/deleted
ij(CONNECTION1)> insert into t1 values ('', 'some clob');
1 row inserted/updated/deleted
ij(CONNECTION1)> select * from t1;
C1 |C2
---------------------
|some clob
ij(CONNECTION1)> select c2 from t1;
C2
----------
some clob
ij(CONNECTION1)> insert into t1 values ('', '');
1 row inserted/updated/deleted
ij(CONNECTION1)> insert into t1 values ('some clob', '');
1 row inserted/updated/deleted
ij(CONNECTION1)> select * from t1;
C1 |C2
---------------------
|some clob
|
some clob |
ij(CONNECTION1)> select c2 from t1;
C2
----------
some clob
ij(CONNECTION1)> drop table t1;
0 rows inserted/updated/deleted
ij(CONNECTION1)>

============================

*supersimple.tmp*
============================
ij version 10.2
ij> -- by default, holdability of ResultSet objects created using this
Connection object is true. Following will set it to false for this
connection.
NoHoldForConnection;
ij> create table a (a int);
0 rows inserted/updated/deleted
ij> insert into a values (1);
1 row inserted/updated/deleted
ij> select * from a;
A
-----------
1
ij> drop table a;
0 rows inserted/updated/deleted
ij> create table b (si smallint,i int, bi bigint, r real, f float, d double
precision, n5_2 numeric(5,2), dec10_3 decimal(10,3), ch20 char(20),vc
varchar(20), lvc long varchar, blobCol blob(1000), clobCol clob(1000));
0 rows inserted/updated/deleted
ij> insert into b values(2,3,4,5.3,5.3,5.3,31.13,123456.123,
'one','one','one',cast(X'01ABCD' as blob(1000)),'one');
1 row inserted/updated/deleted
ij> insert into b values(-32768,-2147483648, -9223372036854775808 ,1.2E-37,
2.225E-307, +2.225E-307,-56.12, -123456.123,'one','one','one',
cast(X'01ABCD' as blob(1000)),'one');
1 row inserted/updated/deleted
ij> insert into b
values(null,null,null,null,null,null,null,null,null,null,null,null,null);
1 row inserted/updated/deleted
ij> insert into b values(32767,2147483647, 9223372036854775807 ,1.4 ,
3.4028235E38 ,3.4028235E38 ,999.99,
9999999.999,'one','one','one',cast(X'01ABCD'
as blob(1000)), 'one');
1 row inserted/updated/deleted
ij> select * from b;
SI |I |BI |R |F |D |N5_2 |DEC10_3 |CH20 |VC |LVC |BLOBCOL |CLOBCOL
---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
2 |3 |4 |5.3 |5.3 |5.3 |31.13 |123456.123 |one |one |one |01abcd |one
-32768|-2147483648|-9223372036854775808|1.2E-37 |2.225E-307 |2.225E-307 |-
56.12 |-123456.123 |one |one |one |01abcd |one
NULL |NULL |NULL |NULL |NULL |NULL |NULL |NULL |NULL |NULL |NULL |NULL |NULL

32767 |2147483647 |9223372036854775807 |1.4 |3.4028235E38 |3.4028235E38
|999.99 |9999999.999 |one |one |one |01abcd |one
ij> drop table b;
0 rows inserted/updated/deleted
ij> create table c (si smallint not null,i int not null , bi bigint not
null, r real not null, f float not null, d double precision not null, n5_2
numeric(5,2) not null , dec10_3 decimal(10,3) not null, ch20 char(20) not
null ,vc varchar(20) not null, lvc long varchar not null, blobCol blob(1000)
not null, clobCol clob(1000) not null);
0 rows inserted/updated/deleted
ij> insert into c values(2,3,4,5.3,5.3,5.3,31.13,123456.123,
'one','one','one', cast(X'01ABCD' as blob(1000)), 'one');
1 row inserted/updated/deleted
ij> insert into c values(-32768,-2147483648, -9223372036854775808 ,1.2E-37,
2.225E-307, +2.225E-307,-56.12, -123456.123,'one','one','one',
cast(X'01ABCD' as blob(1000)),'one');
1 row inserted/updated/deleted
ij> select * from c;
SI |I |BI |R |F |D |N5_2 |DEC10_3 |CH20 |VC |LVC |BLOBCOL |CLOBCOL
---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
2 |3 |4 |5.3 |5.3 |5.3 |31.13 |123456.123 |one |one |one |01abcd |one
-32768|-2147483648|-9223372036854775808|1.2E-37 |2.225E-307 |2.225E-307 |-
56.12 |-123456.123 |one |one |one |01abcd |one
ij> values(10);
1
-----------
10
ij> values('hello');
1
-----
hello
ij> values(1.2);
1
----
1.2
ij> drop table c;
0 rows inserted/updated/deleted
ij> -- bug 4430 aliasinfo nullability problem
select aliasinfo from sys.sysaliases where aliasinfo is null;
ALIASINFO
---------------
ij> -- test commit and rollback
autocommit off;
ij> create table a(a int);
0 rows inserted/updated/deleted
ij> insert into a values (1);
1 row inserted/updated/deleted
ij> select * from a;
A
-----------
1
ij> commit;
ij> drop table a;
0 rows inserted/updated/deleted
ij> rollback;
ij> select * from a;
A
-----------
1
ij> drop table a;
0 rows inserted/updated/deleted
ij> commit;
ij> autocommit on;
ij> maximumdisplaywidth 5000;
ij> --test 84 columns
values(1, 2, 3, 4, 5, 6, 7, 8, 9, 10,
11, 12, 13, 14, 15, 16, 17, 18, 19, 20,
21, 22, 23, 24, 25, 26, 27, 28, 29, 30,
31, 32, 33, 34, 35, 36, 37, 38, 39, 40,
41, 42, 43, 44, 45, 46, 47, 48, 49, 50,
51, 52, 53, 54, 55, 56, 57, 58, 59, 60,
61, 62, 63, 64, 65, 66, 67, 68, 69, 70,
71, 72, 73, 74, 75, 76, 77, 78, 79, 80,
81, 82, 83, 84);
1 |2 |3 |4 |5 |6 |7 |8 |9 |10 |11 |12 |13 |14 |15 |16 |17 |18 |19 |20 |21
|22 |23 |24 |25 |26 |27 |28 |29 |30 |31 |32 |33 |34 |35 |36 |37 |38 |39 |40
|41 |42 |43 |44 |45 |46 |47 |48 |49 |50 |51 |52 |53 |54 |55 |56 |57 |58 |59
|60 |61 |62 |63 |64 |65 |66 |67 |68 |69 |70 |71 |72 |73 |74 |75 |76 |77 |78
|79 |80 |81 |82 |83 |84
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
1 |2 |3 |4 |5 |6 |7 |8 |9 |10 |11 |12 |13 |14 |15 |16 |17 |18 |19 |20 |21
|22 |23 |24 |25 |26 |27 |28 |29 |30 |31 |32 |33 |34 |35 |36 |37 |38 |39 |40
|41 |42 |43 |44 |45 |46 |47 |48 |49 |50 |51 |52 |53 |54 |55 |56 |57 |58 |59
|60 |61 |62 |63 |64 |65 |66 |67 |68 |69 |70 |71 |72 |73 |74 |75 |76 |77 |78
|79 |80 |81 |82 |83 |84
ij> values(1, 2, 3, 4, 5, 6, 7, 8, 9, 10,
11, 12, 13, 14, 15, 16, 17, 18, 19, 20,
21, 22, 23, 24, 25, 26, 27, 28, 29, 30,
31, 32, 33, 34, 35, 36, 37, 38, 39, 40,
41, 42, 43, 44, 45, 46, 47, 48, 49, 50,
51, 52, 53, 54, 55, 56, 57, 58, 59, 60,
61, 62, 63, 64, 65, 66, 67, 68, 69, 70,
71, 72, 73, 74, 75, 76, 77, 78, 79, 80,
81, 82, 83, 84, 85, 86, 87, 88, 89, 90,
91, 92, 93, 94, 95, 96, 97, 98, 99, 100);
1 |2 |3 |4 |5 |6 |7 |8 |9 |10 |11 |12 |13 |14 |15 |16 |17 |18 |19 |20 |21
|22 |23 |24 |25 |26 |27 |28 |29 |30 |31 |32 |33 |34 |35 |36 |37 |38 |39 |40
|41 |42 |43 |44 |45 |46 |47 |48 |49 |50 |51 |52 |53 |54 |55 |56 |57 |58 |59
|60 |61 |62 |63 |64 |65 |66 |67 |68 |69 |70 |71 |72 |73 |74 |75 |76 |77 |78
|79 |80 |81 |82 |83 |84 |85 |86
----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
1 |2 |3 |4 |5 |6 |7 |8 |9 |10 |11 |12 |13 |14 |15 |16 |17 |18 |19 |20 |21
|22 |23 |24 |25 |26 |27 |28 |29 |30 |31 |32 |33 |34 |35 |36 |37 |38 |39 |40
|41 |42 |43 |44 |45 |46 |47 |48 |49 |50 |51 |52 |53 |54 |55 |56 |57 |58 |59
|60 |61 |62 |63 |64 |65 |66 |67 |68 |69 |70 |71 |72 |73 |74 |75 |76 |77 |78
|79 |80 |81 |82 |83 |84 |85 |86 |87 |88 |89 |90 |91 |92 |93 |94 |95 |96 |97
|98 |99 |100
ij> -- test SQL Error with non-string arguments
-- Make sure connection still ok (Bug 4657)
create table a (a int);
0 rows inserted/updated/deleted
ij> insert into a values(2342323423) ;
ERROR 22003: The resulting value is outside the range for the data type
INTEGER.
ij> insert into a values(1);
1 row inserted/updated/deleted
ij> select * from a;
A
-----------
1
ij> drop table a;
0 rows inserted/updated/deleted
ij> -- Bug 4694 Test automatic rollback with close of connection
-- in ij
autocommit off;
ij> create table a (a int);
0 rows inserted/updated/deleted
ij> -- Bug 4758 - Store error does not return properly to client
autocommit off;
ij> create table t (i int);
0 rows inserted/updated/deleted
ij> insert into t values(1);
1 row inserted/updated/deleted
ij> commit;
ij> insert into t values(2);
1 row inserted/updated/deleted
ij> connect 'wombat';
ij(CONNECTION1)> -- by default, holdability of ResultSet objects created
using this Connection object is true. Following will set it to false for
this connection.
NoHoldForConnection;
ij(CONNECTION1)> prepare s1 as 'select * from t';
ij(CONNECTION1)> execute s1;
I
-----------
ERROR 40XL1: A lock could not be obtained within the time requested
ij(CONNECTION1)> execute s1;
I
-----------
ERROR 40XL1: A lock could not be obtained within the time requested
ij(CONNECTION1)> -- Bug 5967 - Selecting from 2 lob columns w/ the first one
having data of length 0
create table t1 (c1 clob(10), c2 clob(10));
0 rows inserted/updated/deleted
ij(CONNECTION1)> insert into t1 values ('', 'some clob');
1 row inserted/updated/deleted
ij(CONNECTION1)> select * from t1;
C1 |C2
---------------------
|some clob
ij(CONNECTION1)> select c2 from t1;
C2
----------
some clob
ij(CONNECTION1)> insert into t1 values ('', '');
1 row inserted/updated/deleted
ij(CONNECTION1)> insert into t1 values ('some clob', '');
1 row inserted/updated/deleted
ij(CONNECTION1)> select * from t1;
C1 |C2
---------------------
|some clob
|
some clob |
ij(CONNECTION1)> select c2 from t1;
C2
----------
some clob
ij(CONNECTION1)> drop table t1;
0 rows inserted/updated/deleted
ij(CONNECTION1)>
======================================


2006/10/11, Mike Matrigali <mi...@sbcglobal.net>:
>
> It looks like the test harness is running jdk1.4.2_07 not sun 1.5.6.
> I find it hard to do debug these things with just the diff, can
> you attach the actual output file you are getting (both the .tmp and
> the .out)
>
> Leo Li wrote:
> > Hi, all:
> >      We have just run the testcase for derby but it fails on windows.
> >      The jdk we used is Sun 1.5.6.
> >      We runs:
> >
> >      java org.apache.derbyTesting.functionTests.harness.RunTest
> > lang/supersimple.sql
> >
> >      Then gets:
> >
> >       -- listing properties --
> > derby.locks.deadlockTimeout=3
> > derby.locks.waitTimeout=3
>
> test harness reporting jvm version:
> > *** Start: supersimple jdk1.4.2_07 2006-10-10 16:32:31 ***
> > 24 del
> > < SI |I |BI |R |F |D |N5_2 |DEC10_3 |CH20 |VC |LVC |BLOBCOL |CLOBCOL
> > 25 del
> > <
>
>

Re: [testing]Test fails

Posted by Mike Matrigali <mi...@sbcglobal.net>.
It looks like the test harness is running jdk1.4.2_07 not sun 1.5.6.
I find it hard to do debug these things with just the diff, can
you attach the actual output file you are getting (both the .tmp and
the .out)

Leo Li wrote:
> Hi, all:
>      We have just run the testcase for derby but it fails on windows.
>      The jdk we used is Sun 1.5.6.
>      We runs:
>  
>      java org.apache.derbyTesting.functionTests.harness.RunTest 
> lang/supersimple.sql
>  
>      Then gets:
>  
>       -- listing properties --
> derby.locks.deadlockTimeout=3
> derby.locks.waitTimeout=3

test harness reporting jvm version:
> *** Start: supersimple jdk1.4.2_07 2006-10-10 16:32:31 ***
> 24 del
> < SI |I |BI |R |F |D |N5_2 |DEC10_3 |CH20 |VC |LVC |BLOBCOL |CLOBCOL
> 25 del
> <

Re: [testing]Test fails

Posted by Sean Qiu <se...@gmail.com>.
I happen to encounter the same problem, and i need help too.

2006/10/10, Leo Li <li...@gmail.com>:
>
> Hi, all:
>      We have just run the testcase for derby but it fails on windows.
>      The jdk we used is Sun 1.5.6.
>      We runs:
>
>      java org.apache.derbyTesting.functionTests.harness.RunTestlang/supersimple.sql
>
>      Then gets:
>
>       -- listing properties --
> derby.locks.deadlockTimeout=3
> derby.locks.waitTimeout=3
> *** Start: supersimple jdk1.4.2_07 2006-10-10 16:32:31 ***
> 24 del
> < SI |I |BI |R |F |D |N5_2 |DEC10_3 |CH20 |VC |LVC |BLOBCOL |CLOBCOL
> 25 del
> <
> -----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
>
> 26 del
> < 2 |3 |4 |5.3 |5.3 |5.3 |31.13 |123456.123 |one |one |one |01abcd |one
> 27 del
> < -32768|-2147483648|-9223372036854775808|1.2E-37 |2.225E-307 |2.225E-307
> |-56.12 |-123456.123 |one |one |one |01abcd |one
> 28 del
> < NULL |NULL |NULL |NULL |NULL |NULL |NULL |NULL |NULL |NULL |NULL |NULL
> |NULL
> 29 del
> < 32767 |2147483647 |9223372036854775807 |1.4 |3.4028235E38 |3.4028235E38
> |999.99 |9999999.999 |one |one |one |01abcd |one
> 29a24,29
> > SI |I |BI |R |F |D |N5_2 |DEC10_3 |CH20 |VC |LVC |BLOBCOL |CLOBCOL
> >
> ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
>
> > 2 |3 |4 |5.3 |5.3 |5.3 |31.13 |123456.123 |one |one |one |01abcd |one
> > -32768|-2147483648|-9223372036854775808|1.2E-37 |2.225E-307 |2.225E-307
> |-56.12 |-123456.123 |one |one |one |01abcd |one
> > NULL |NULL |NULL |NULL |NULL |NULL |NULL |NULL |NULL |NULL |NULL |NULL
> |NULL
> > 32767 |2147483647 |9223372036854775807 |1.4 |3.4028235E38 |3.4028235E38
> |999.99 |9999999.999 |one |one |one |01abcd |one
> 39 del
> < SI |I |BI |R |F |D |N5_2 |DEC10_3 |CH20 |VC |LVC |BLOBCOL |CLOBCOL
> 40 del
> <
> -----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
>
> 41 del
> < 2 |3 |4 |5.3 |5.3 |5.3 |31.13 |123456.123 |one |one |one |01abcd |one
> 42 del
> < -32768|-2147483648|-9223372036854775808|1.2E-37 |2.225E-307 |2.225E-307
> |-56.12 |-123456.123 |one |one |one |01abcd |one
> 42a39,42
> > SI |I |BI |R |F |D |N5_2 |DEC10_3 |CH20 |VC |LVC |BLOBCOL |CLOBCOL
> >
> ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
>
> > 2 |3 |4 |5.3 |5.3 |5.3 |31.13 |123456.123 |one |one |one |01abcd |one
> > -32768|-2147483648|-9223372036854775808|1.2E-37 |2.225E-307 |2.225E-307
> |-56.12 |-123456.123 |one |one |one |01abcd |one
> 52 del
> < 1
> 53 del
> < -----
> 54 del
> < 1.2
> 54a52,54
> > 1
> > ----
> > 1.2
> Test Failed.
> *** End: supersimple jdk1.4.2_07 2006-10-10 16:32:41 ***
>
>
>      Any suggestion? I am not sure of whether some arguments configuration
> is required.
>      Thank you.
>
> --
> Leo Li
> China Software Development Lab, IBM
>

Re: [testing]Test fails

Posted by Myrna van Lunteren <m....@gmail.com>.
On 10/10/06, Leo Li <li...@gmail.com> wrote:
> Hi,
>    I have another problem.
>    I have ran all test using java
> org.apache.derbyTesting.functionTests.harness.RunSuite
> derbyall.
>    But some test fails and reports the derbyall_report.txt in my attachment.
>    Is it neccessary to set some options like:
>    java -Xbootclasspath/a:%jardir%\jdbc.jar
> -Dbootcp=%jardir%\jdbc.jar
> -Dij.dataSource=org.apache.derby.jdbc.EmbeddedSimpleDataSource
> -Djvmflags="-Dij.dataSource=org.apache.derby.jdbc.EmbeddedSimpleDataSource"
> org.apache.derbyTesting.functionTests.harness.RunSuite
> derbyall
>
>    Thank you.
>
Hi,

Those errors you see are because the test harness wasn't adjusted to a
reorganization in the location of the test libraries. If you put all
derby*.jar in one place, including the derbyTesting.jar, things will
work fine. There is an outstanding bug, see DERBY-1593.

The bootcp options are only needed for the special 'j9' jvm that comes
with certain IBM products - and the dataSource option is only for j2ME
/ Jcl foundation libraries. You would know it if that's what you are
using, because the executable is j9.exe rather than java.exe...


Myrna

Re: [testing]Test fails

Posted by Leo Li <li...@gmail.com>.
Hi,
   I have another problem.
   I have ran all test using java
org.apache.derbyTesting.functionTests.harness.RunSuite derbyall.
   But some test fails and reports the derbyall_report.txt in my attachment.
   Is it neccessary to set some options like:
   java -Xbootclasspath/a:%jardir%\jdbc.jar -Dbootcp=%jardir%\jdbc.jar -
Dij.dataSource=org.apache.derby.jdbc.EmbeddedSimpleDataSource -Djvmflags="-
Dij.dataSource=org.apache.derby.jdbc.EmbeddedSimpleDataSource"
org.apache.derbyTesting.functionTests.harness.RunSuite derbyall

   Thank you.



On 10/11/06, xi yanyan <xi...@gmail.com> wrote:
>
> It is something about encode
>
> On 10/11/06, Leo Li <li...@gmail.com> wrote:
> >
> >
> >
> >  On 10/10/06, Bryan Pendleton < bpendleton@amberpoint.com> wrote:
> > >
> > > >      We have just run the testcase for derby but it fails on
> > > windows.
> > >
> > > Can you tell (by inspection of the output and diff files on your
> > > machine)
> > > whether you are getting the same values in the output, but in a
> > > different order?
> > >
> > > If so, it sounds like the sort ordering is different on your machine
> > > than
> > > is expected by the test.
> > >
> > > Is your Windows environment a simple English-language configuration?
> > > Or
> > > are you using a different locale or some other sort-related
> > > configuration?
> >
> >
> > The platform is winXP with simple chinese language, I think it might be
> > related to this issue because of the sorting order?
> >
> > thanks,
> > >
> > > bryan
> > >
> > >
> > >
> >
> >
> > --
> > Leo Li
> > China Software Development Lab, IBM
> >
>
>


-- 
Leo Li
China Software Development Lab, IBM

Re: [testing]Test fails

Posted by xi yanyan <xi...@gmail.com>.
It is something about encode

On 10/11/06, Leo Li <li...@gmail.com> wrote:
>
>
>
>  On 10/10/06, Bryan Pendleton <bp...@amberpoint.com> wrote:
> >
> > >      We have just run the testcase for derby but it fails on windows.
> >
> > Can you tell (by inspection of the output and diff files on your
> > machine)
> > whether you are getting the same values in the output, but in a
> > different order?
> >
> > If so, it sounds like the sort ordering is different on your machine
> > than
> > is expected by the test.
> >
> > Is your Windows environment a simple English-language configuration? Or
> > are you using a different locale or some other sort-related
> > configuration?
>
>
> The platform is winXP with simple chinese language, I think it might be
> related to this issue because of the sorting order?
>
> thanks,
> >
> > bryan
> >
> >
> >
>
>
> --
> Leo Li
> China Software Development Lab, IBM
>

Re: [testing]Test fails

Posted by Leo Li <li...@gmail.com>.
Sorry, I made a mistake.
It passes on windows but fails on unbuntu.:)


On 10/11/06, Leo Li <li...@gmail.com> wrote:
>
>
>
>  On 10/10/06, Bryan Pendleton <bp...@amberpoint.com> wrote:
> >
> > >      We have just run the testcase for derby but it fails on windows.
> >
> > Can you tell (by inspection of the output and diff files on your
> > machine)
> > whether you are getting the same values in the output, but in a
> > different order?
> >
> > If so, it sounds like the sort ordering is different on your machine
> > than
> > is expected by the test.
> >
> > Is your Windows environment a simple English-language configuration? Or
> > are you using a different locale or some other sort-related
> > configuration?
>
>
> The platform is winXP with simple chinese language, I think it might be
> related to this issue because of the sorting order?
>
> thanks,
> >
> > bryan
> >
> >
> >
>
>
> --
> Leo Li
> China Software Development Lab, IBM
>



-- 
Leo Li
China Software Development Lab, IBM

Re: [testing]Test fails

Posted by Leo Li <li...@gmail.com>.
On 10/10/06, Bryan Pendleton <bp...@amberpoint.com> wrote:
>
> >      We have just run the testcase for derby but it fails on windows.
>
> Can you tell (by inspection of the output and diff files on your machine)
> whether you are getting the same values in the output, but in a different
> order?
>
> If so, it sounds like the sort ordering is different on your machine than
> is expected by the test.
>
> Is your Windows environment a simple English-language configuration? Or
> are you using a different locale or some other sort-related configuration?


The platform is winXP with simple chinese language, I think it might be
related to this issue because of the sorting order?

thanks,
>
> bryan
>
>
>


-- 
Leo Li
China Software Development Lab, IBM

Re: [testing]Test fails

Posted by Sean Qiu <se...@gmail.com>.
My linux distribution is ubuntu.
I am not quite sure about what is the sort-related configurations.
Could you figure it out for me?

2006/10/10, Bryan Pendleton <bp...@amberpoint.com>:
>
> >      We have just run the testcase for derby but it fails on windows.
>
> Can you tell (by inspection of the output and diff files on your machine)
> whether you are getting the same values in the output, but in a different
> order?
>
> If so, it sounds like the sort ordering is different on your machine than
> is expected by the test.
>
> Is your Windows environment a simple English-language configuration? Or
> are you using a different locale or some other sort-related configuration?
>
> thanks,
>
> bryan
>
>
>

Re: [testing]Test fails

Posted by Bryan Pendleton <bp...@amberpoint.com>.
>      We have just run the testcase for derby but it fails on windows.

Can you tell (by inspection of the output and diff files on your machine)
whether you are getting the same values in the output, but in a different order?

If so, it sounds like the sort ordering is different on your machine than
is expected by the test.

Is your Windows environment a simple English-language configuration? Or
are you using a different locale or some other sort-related configuration?

thanks,

bryan