Subselects are broken in the version of Hypersonic that ships with Orion. Hypersonic SQL has changed hands. Try the version at http://www.hsqldb.org/ - and please report your results back to the list.
Kirk Yarina At 01:02 PM 11/20/01 +0200, you wrote: >Hi all , >I have an application (EJBs) deployed properly. All works fine using the >Postgres databases but this is a little problem using a Hypersonic Database. > >This issue is not Orion related but rather Hypersonic. Is Hypersonic able to >do a query inside a query ? Using the DAtabaseManager I can say that it can't >but I need to know if someone had similar problems . > >My query looks like this : > >select * from journalEntry where testEntryID = 1 AND questionID IN ( SELECT >id FROM question WHERE question.moduleID = 0 ) > >I can ashure you that this query works just fine in Postgres but does not >give any result in Hypersonic!!! > >Thanks for your answers , >dovle
