[eclipselink-dev] isDynamicSQLRequiredForFunctions used in select list

[Dies Koper <diesk@xxxxxxxxxxxxxxxxxxx>]

Hi James,

I noticed your addition of isDynamicSQLRequiredForFunctions to some of
the database platforms.
As Symfoware also has a number of functions which do not allow
parameters, I've been looking at using this so I don't need to disable
primitive binding completely.

Is my understanding correctly that when I use that, I need to call
operator.setIsBindingSupported(false); on each of the operators that do
not allow parameters as arguments?

That's what I did, and all but the following test pass:
 org.eclipse.persistence.testing.tests.jpa.criteria.JUnitCriteriaSimpleTestSuite.simpleCoalesceInSelectTest

This particular test has COALESCE in the select list, and Symfoware
complains about the input parameter used as argument:

COALESCE(t0.F_NAME,t0.L_NAME,? ) FROM CMP3_EMPLOYEE t0, CMP3_SALARY t1
WHERE ((t0.F_NAME = ?) AND (t1.EMP_ID = t0.EMP_ID)) bind => [Bobby, Bob]

I call setIsBindingSupported on ExpressionOperator.coalesce() before I
add the Symfoware platform operator, but the third parameter became an
input parameter.
Is this as expected?

Thanks,
Dies