db-ojb-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Jakob Braeuchi <jbraeu...@gmx.ch>
Subject Re: 1.0 release date
Date Thu, 01 Jan 2004 15:32:18 GMT
hi thomas,

the new version 7.5 of sapdb/maxdb no longer fails on 
QueryTest#testSubQuery4 :)

jakob

Jakob Braeuchi wrote:
> hi thomas,
> 
> first of all: i wish you a :) 2004.
> 
> i did some tests with sapdb. there's one testcase that is not supported 
> by sapdb (QueryTest#testSubQuery4).
> 
> sapdb needs the syntax COLUMN OPERATOR SUBQUERY as in the folloing 
> sample form their website:
> 
> SELECT name, city FROM hotel X, room
> WHERE X.hno = room.hno AND room.roomtype = 'SINGLE'
>     AND room.price < (SELECT AVG(room.price) FROM hotel, room
>         WHERE hotel.hno = room.hno AND hotel.city = X.city
>         AND room.roomtype = 'SINGLE' )
> 
> this case is covered by QueryTest#testSubQuery3 and works as expected.
> 
> 
> the slightly different syntax SUBQUERY OPERATOR COLUMN
> 
> SELECT name, city FROM hotel X, room
> WHERE X.hno = room.hno AND room.roomtype = 'SINGLE'
>     AND (SELECT AVG(room.price) FROM hotel, room
>         WHERE hotel.hno = room.hno AND hotel.city = X.city
>         AND room.roomtype = 'SINGLE' ) > room.price
> 
> results in an sql-error -7056 subquery not allowed.
> 
> 
> jakob
> 
> Thomas Mahler wrote:
> 
>> hi all,
>>
>> I hope you all enjoyed your christmas holidays!
>>
>> As the proposed 1.0 release date comes closer I'd like to discuss some 
>> issues.
>>
>> In an offline email thread Armin and I agreed that that there are 
>> still some important things to do before we should finalize the 1.0 
>> release.
>>
>> As all those things need time we both think that it would be better to 
>> shift the release from Dec. 28th to Jan. 4th.
>>
>> Are there any strong reason why we should stick to the 28th? As far as 
>> I know this date was not announced to a wider audience, so there 
>> should be no bad press for this?
>>
>> Here are some open tasks. I'd prefer to share this work among 
>> developers to reduce the release workload.
>>
>> - Checking Junit test against all Major database platforms (hsql, 
>> mysql, postgresql, oracle, sapdb, mssql, db2)
>> Assigned to: thma (HSQL and MYSQL).
>>
>> - Checking Junit test against different combinations of OJB.properties 
>> settings (e.g. ObjectCache, ConnectionFactory, Pool, etc.)
>>
>> - verifying the EJB examples against Jboss, etc.
>>
>> - verifying that the tutorial apps work.
>> Assigned to: thma
>>
>> - add a known issues section to the release note.
>> Assigned to: thma
>>
>> - Use fixed SerialVersion UIDs for serializable classes to avoid 
>> serialization problems with futures builds.
>> Assigned to: thma
>>
>> Any other things that are not yet covered?
>> Please check if you can help with any of these things and assign 
>> yourself a task or two.
>>
>> cu,
>> Thomas
>>
>>
>>
>> ---------------------------------------------------------------------
>> To unsubscribe, e-mail: ojb-dev-unsubscribe@db.apache.org
>> For additional commands, e-mail: ojb-dev-help@db.apache.org
>>
>>
> 
> 
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: ojb-dev-unsubscribe@db.apache.org
> For additional commands, e-mail: ojb-dev-help@db.apache.org
> 
> 


---------------------------------------------------------------------
To unsubscribe, e-mail: ojb-dev-unsubscribe@db.apache.org
For additional commands, e-mail: ojb-dev-help@db.apache.org


Mime
View raw message