Re: DyadicExpression "OR" compiles into nested SQL expressions which exhausts the stack of the underlying DB


Andy
 
Edited

What SQL do you want to generate??
The JDOQL you provided has been mapped directly as you requested it.

You could try having a single parameter of type Collection that has multiple String values, and then do
:param.contains(partition.partitionName)
which will probably compile to an IN expression. Clearly you then may have a limit in your RDBMS about the number of values specifiable in an IN expression. Can't see what you would expect an ORM to do about that, you could split up your query to have fewer values in a query and aggregate multiple queries

Join main@datanucleus.groups.io to automatically receive all group messages.