[
https://issues.apache.org/jira/browse/OPENJPA-3030?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=18134598#comment-18134598
]
ASF subversion and git services commented on OPENJPA-3030:
----------------------------------------------------------
Commit a0ac2307e8a5f17f24b6015caca7cfd12ff7387f in openjpa's branch
refs/heads/OPENJPA-3003 from Richard Zowalla
[ https://gitbox.apache.org/repos/asf?p=openjpa.git;h=a0ac2307e ]
[OPENJPA-3030] Render LEFT and RIGHT with SUBSTR on Derby
> Derby: LEFT and RIGHT are not supported
> ---------------------------------------
>
> Key: OPENJPA-3030
> URL: https://issues.apache.org/jira/browse/OPENJPA-3030
> Project: OpenJPA
> Issue Type: Sub-task
> Reporter: Richard Zowalla
> Priority: Major
> Fix For: 4.2.0
>
>
> Derby has no {{LEFT}} and {{RIGHT}} functions:
> {noformat}42X01 : Encountered "LEFT" ... WHERE (t0.STR_VAL_1 = LEFT(?,
> 4)){noformat}
> {{DerbyDictionary}} should render them with {{SUBSTR}} ({{RIGHT(s, n)}} as
> {{SUBSTR(s, LENGTH(s) - n + 1)}}).
> Failing tests: {{Client9.testLeftExprLen}}, {{testLeftIntLen}},
> {{testRightExprLen}}, {{testRightIntLen}},
> {{Client3.test_leftStringExpression}}, {{test_rightStringExpression}}.
--
This message was sent by Atlassian Jira
(v10.3.26#10030026)
