Wrong SQL is generated with a little bit complex logic containing 'OR' condition about datanucleus-rdbms HOT 1 OPEN

SELECT FROM A
WHERE a.b == :param1
&&
(
a.coll1.contains(:param2)
||
(
a.coll2.contains(var1)
&&
:param2.coll3.contains(var1)
)
)

Specifically the problem with this query is firstly that it uses OR, which means that any use of "contains" has to use "EXISTS (subquery)" currently. This in itself is not a major problem, it's just a problem dependent on what the
element of this contains is needed for.

In your case you want to link the element of one of these "contains" to one of the other "contains". Since we are using "EXISTS(subquery)" we cannot do that correctly (SQL doesn't work like that, whilst Java does). If you had wanted to link the "var1" to some fixed constraint then that would have been ok, and would fit within the subquery
of the EXISTS. BUT you want to link outside of the EXISTS.

Workarounds

1. Split the query into 2 and run individually and sum the results
   SELECT FROM A WHERE a.b == :param1 && a.coll1.contains(:param2)
   SELECT FROM A WHERE a.b == :param1 && a.coll2.contains(var1) && :param2.coll3.contains(var1)
2. Don't pass in your second parameter as it is now, and instead generate the single query based on the values that are in
   "myMainStrategy.downlineMarketStrategies". So you then would have a query like
   SELECT FROM A
   WHERE a.b == :param1
   &&
   (
   a.coll1.contains(:param2)
   ||
   (
   a.coll2.contains(:param3a)
   ||
   a.coll2.contains(:param3b)
   ||
   a.coll2.contains(:param3c)
   ... etc
   )
   )

Or just propose what SQL you think could be generated to do it in one query with the current input.

from datanucleus-rdbms.