[CAY-1935] EJBQL; Handling Collection as Parameter in IN Expression

• Type: Improvement
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 3.2.M1
• Fix Version/s: 4.0.M2
• Assignee: Unassigned
• Reporter: Andrew Ponsonby Lindesay
• Created: 17/May/14 05:47
• Updated: 01/Aug/14 09:45
• Resolved: 01/Aug/14 09:45

Description

Consider an EJBQL expression fragment...

... p.toArtist IN (:artists)

...where :artists may be bound to a Collection such as List or Set. Cayenne presently takes the named or positional parameter bound to the collection to be a member of the set of elements to which the lvar should be a member rather than the set itself. Obviously this doesn't process correctly.

This patch will mean that in this situation above, the parameter bound to the Collection is expanded to actually be the set of elements to which the LVAR should be a member.

There is some discussion of this here and here.

Because some query systems support an unbracketed collection-parameter for IN, "EJBQLParser.jjt" has been modified in this patch to allow for either approach; hence a query of the following form would also be supported;

... p.toArtist IN :artists

Note that this new functionality only applies if there is a single unbracketed parameter or if there is a single bracketed parameter - it does not take effect if there are multiple parameters in play. If there is a single unbracketed parameter that is not a collection then it will function as if that parameter were bracketed.