Generated SUBSTRING SQL is ugly and inefficient
-----------------------------------------------
Key: OPENJPA-487
URL: https://issues.apache.org/jira/browse/OPENJPA-487
Project: OpenJPA
Issue Type: Improvement
Components: sql
Affects Versions: 1.0.1, 1.0.0, 0.9.7, 0.9.6, 0.9.0, 1.0.2, 1.1.0
Reporter: Patrick Linskey
Priority: Minor
When performing a JPQL query with a SUBSTRING clause, OpenJPA converts from
one-based index + length parameters to zero-based index + end index for
internal handling, and then re-converts back to one-based + length when
generating SQL. This conversion is entirely performed in query values, so the
generated SQL has a lot of math in it. This extra math is never necessary.
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
