There is a problem with the parameter binding of dynamic filter parameters in case you use a dynamic filter definition on a OneToMany child collection, and add the elements() expression to the WHERE clause.
The filter parameter does not get bound at all.
I have a root entity with a filter definition for the deletion timestamp column, and I also apply this filter on its child entities for their deletion timestamp columns:
This is one of the child entites:
Now if I enable the filter in the session:
and execute the following query:
the query will result in the following SQL:
As you can see the dynamic filter parameter does not get bound.
Please advise if I am doing something wrong, or point me to the proper class where I can start debugging.