You are viewing a plain text version of this content. The canonical link for it is here.
Posted to ojb-dev@db.apache.org by Jakob Braeuchi <jb...@gmx.ch> on 2004/01/01 11:34:49 UTC
Re: 1.0 release date
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
Re: 1.0 release date
Posted by Jakob Braeuchi <jb...@gmx.ch>.
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