I build per build page
<http://svn.apache.org/repos/asf/db/derby/code/trunk/BUILDING.html>.
http://svn.apache.org/repos/asf/db/derby/code/trunk/BUILDING.html
The jardriftcheck step fails (see error below), but the jars are built (see
listing below).
Then, I run RunOptimizerTest.java within netbeans by right clicking on the file and
selecting "Run File".
This gives the output shown in my first mail.
It seems like some setup is missing;
Hi Colm,
Thanks for the additional background.
I'm not sure how important the jardriftcheck issues are; it
may depend on whether your CLASSPATH is pointing to the jars
that you built, or to the classes that you built.
I'm not that familiar with RunOptimizerTest, and I don't run it
regularly myself, so this may take some digging.
I did the following:
(cd to a new fresh empty directory)
java -cp /home/bpendleton/derby/trunk/classes
org.apache.derbyTesting.system.optimizer.RunOptimizerTest
And I got the following results that I have pasted below.
I'm not sure what this means. It certainly looks like the test
failed for me, but it also looks like it failed for me with a
different error than the one you saw.
I see an error message about BOOLEAN, which is a relatively
recent change to Derby (though it's been a few releases now).
Perhaps this test has not been updated to account for this
new feature?
Anyway, maybe a useful next step for you would be to try
running the test from a command line by directly invoking
the java interpreter, using a command line similar to the
one I pasted above, in a fresh clean empty directory.
And try it both with a CLASSPATH of "classes", and a CLASSPATH
of "jars", to see if the jars-vs-classes distinction is
relevant.
Hope this helps; let's keep digging into the failure you
see; I'm sure we can sort it out.
thanks,
bryan
Running test with url jdbc:derby:testdb;create=true
Initializing db ...
Starting tests ...
SQL Exception :java.sql.SQLException: Failed query:
select sum_view_8bc1,avg_view_8bc1,max_view_8bc1 from sum_view_8b,avg_view_8b,max_view_8b where (sum_view_8bc1>avg_view_8bc1 and avg_view_8bc1<max_view_8bc1) union all select count_view_8bc1,min_view_8bc1,max_view_8bc1 from
count_view_8b,min_view_8b,max_view_8b where (count_view_8bc1=min_view_8bc1=max_view_8bc1)
SQLState= 42818
ErrorCode= 30000
Message= Comparisons between 'BOOLEAN' and 'INTEGER' are not supported. Types must be comparable. String types must also have matching collation. If collation does not match, a possible solution is to cast operands to force them to the default collation
(e.g. SELECT tablename FROM sys.systables WHERE CAST(tablename AS VARCHAR(128)) = 'T1')
java.sql.SQLException: Failed query:
select sum_view_8bc1,avg_view_8bc1,max_view_8bc1 from sum_view_8b,avg_view_8b,max_view_8b where (sum_view_8bc1>avg_view_8bc1 and avg_view_8bc1<max_view_8bc1) union all select count_view_8bc1,min_view_8bc1,max_view_8bc1 from
count_view_8b,min_view_8b,max_view_8b where (count_view_8bc1=min_view_8bc1=max_view_8bc1)
SQLState= 42818
ErrorCode= 30000
Message= Comparisons between 'BOOLEAN' and 'INTEGER' are not supported. Types must be comparable. String types must also have matching collation. If collation does not match, a possible solution is to cast operands to force them to the default collation
(e.g. SELECT tablename FROM sys.systables WHERE CAST(tablename AS VARCHAR(128)) = 'T1')
at
org.apache.derbyTesting.system.optimizer.query.GenericQuery.executeQueries(GenericQuery.java:139)
at
org.apache.derbyTesting.system.optimizer.RunOptimizerTest.main(RunOptimizerTest.java:114)
========================= R E S U L T S =========================
________________________________________________________________________________________________
Timings for Query type: Select from single view
QueryName Using PreparedStatment Using Statement Rows Expected
------------------------------------------------------------------------------
Query size: 4
QUERY # 1 0.022 secs 0.587 secs 3
QUERY # 1 0.022 secs 0.040 secs 3
*************************************************************************
QUERY # 2 0.039 secs 0.455 secs 6
QUERY # 2 0.044 secs 0.051 secs 6
*************************************************************************
QUERY # 3 0.074 secs 0.866 secs 10
QUERY # 3 0.104 secs 0.079 secs 10
*************************************************************************
QUERY # 4 0.059 secs 1.143 secs 10
QUERY # 4 0.100 secs 0.094 secs 10
*************************************************************************
________________________________________________________________________________________________
________________________________________________________________________________________________
Timings for Query type: Select from multiple views using joins
QueryName Using PreparedStatment Using Statement Rows Expected
------------------------------------------------------------------------------
Query size: 4
QUERY # 1 0.011 secs 0.536 secs 3
QUERY # 1 0.027 secs 0.024 secs 3
*************************************************************************
QUERY # 2 0.051 secs 0.798 secs 6
QUERY # 2 0.047 secs 0.035 secs 6
*************************************************************************
QUERY # 3 0.093 secs 1.479 secs 10
QUERY # 3 0.118 secs 0.098 secs 10
*************************************************************************
QUERY # 4 0.088 secs 1.803 secs 10
QUERY # 4 0.158 secs 0.177 secs 10
*************************************************************************
________________________________________________________________________________________________
________________________________________________________________________________________________
Timings for Query type: Select from multiple views with joins on columns having
indexes
QueryName Using PreparedStatment Using Statement Rows Expected
------------------------------------------------------------------------------
Query size: 4
QUERY # 1 0.039 secs 0.740 secs 144
QUERY # 1 0.040 secs 0.190 secs 144
*************************************************************************
QUERY # 2 0.099 secs 1.366 secs 288
QUERY # 2 0.066 secs 0.589 secs 288
*************************************************************************
QUERY # 3 0.194 secs 4.031 secs 576
QUERY # 3 0.259 secs 0.615 secs 576
*************************************************************************
QUERY # 4 0.389 secs 2.023 secs 756
QUERY # 4 0.358 secs 0.696 secs 756
*************************************************************************
________________________________________________________________________________________________
________________________________________________________________________________________________
Timings for Query type: Select from multiple views with joins on columns having
no indexes
QueryName Using PreparedStatment Using Statement Rows Expected
------------------------------------------------------------------------------
Query size: 4
QUERY # 1 1.389 secs 2.099 secs 144
QUERY # 1 1.409 secs 1.408 secs 144
*************************************************************************
QUERY # 2 9.135 secs 10.549 secs 288
QUERY # 2 9.186 secs 9.420 secs 288
*************************************************************************
QUERY # 3 36.788 secs 37.960 secs 576
QUERY # 3 36.828 secs 36.764 secs 576
*************************************************************************
QUERY # 4 1 min 4.119 secs 1 min 4.881 secs 756
QUERY # 4 1 min 3.643 secs 1 min 4.051 secs 756
*************************************************************************
________________________________________________________________________________________________
________________________________________________________________________________________________
Timings for Query type: Select from multiple views with joins on columns, one
with index and one without index
QueryName Using PreparedStatment Using Statement Rows Expected
------------------------------------------------------------------------------
Query size: 4
QUERY # 1 0.723 secs 0.877 secs 144
QUERY # 1 0.718 secs 0.705 secs 144
*************************************************************************
QUERY # 2 4.543 secs 4.511 secs 288
QUERY # 2 4.644 secs 4.716 secs 288
*************************************************************************
QUERY # 3 18.489 secs 19.202 secs 576
QUERY # 3 18.376 secs 18.451 secs 576
*************************************************************************
QUERY # 4 31.793 secs 33.070 secs 756
QUERY # 4 31.822 secs 31.777 secs 756
*************************************************************************
________________________________________________________________________________________________
________________________________________________________________________________________________
Queries didn't run
