|[eclipselink-dev] Re: Bug 300512 - Add FUNCTION support to extended JPQL|
Reworked FUNC following conversation with Peter: now the user can use any
database function they'd like and FuncNode creates FunctionExpression for it
"on the fly".
That means that the name passed to FUNC will be always used as function name
(there is no platform - based name traslation).
Also there is no type checking whatsoever.
Following conversation with James changed FunctionExpression.create method so
that it sets as a locaBase an ExpressionBuilder - in case of FunctionOperator;
public void printSQLWithoutConversion(ExpressionSQLPrinter printer) method.
Added a bunch of tests testing the standard JPA functions (ABS, MOD etc) into
Because custom functions are platform-dependent the only way to test them is
currently in Oracle tests (because the function that works on MySQL probably
will fail on some other platform; but Oracle tests run on Oracle only).
Added to Oracle JPA tests CustomJPQLTestSuite (which currently contains a
single test for NVL but will grow later) and SpatialJPQLTestSuite (sdo).