Hi Tom,
the attached jar fixes glassfish issue 742:
https://glassfish.dev.java.net/issues/show_bug.cgi?id=742
The query compiler has a bug in the handling of the LOCATE node such
that the generated SQL ignores the third LOCATE argument (the start
position).
I added a new test method to class JUnitEJBQLComplexTestSuite. It is
included in the attached jar.
Regards Michael