[
https://issues.apache.org/jira/browse/OPENJPA-3029?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=18133737#comment-18133737
]
ASF subversion and git services commented on OPENJPA-3029:
----------------------------------------------------------
Commit 3f20d3a77ab0cc813ed5dd27b47d2835ffad1dfe in openjpa's branch
refs/heads/OPENJPA-3041 from Richard Zowalla
[ https://gitbox.apache.org/repos/asf?p=openjpa.git;h=3f20d3a77 ]
[OPENJPA-3029] Use pattern matching for the cast of the extract operand
> Derby: EXTRACT is not supported
> -------------------------------
>
> Key: OPENJPA-3029
> URL: https://issues.apache.org/jira/browse/OPENJPA-3029
> Project: OpenJPA
> Issue Type: Sub-task
> Reporter: Richard Zowalla
> Priority: Major
>
> Derby has no {{EXTRACT(field FROM x)}}, so every EXTRACT in the TCK fails with
> {noformat}42X01 : Encountered "FROM" ... {SELECT EXTRACT(DAY FROM
> t0.DATATYPES2_ID) FROM DATATYPES2 t0 ...}{noformat}
> Derby has {{YEAR()}}, {{MONTH()}}, {{DAY()}}, {{HOUR()}}, {{MINUTE()}} and
> {{SECOND()}}. QUARTER and WEEK have to be computed from those.
> {{DerbyDictionary}} should render EXTRACT with these functions.
> Failing tests:
> * {{Client4.testExtractDate*}}, {{testExtractDateTime*}},
> {{testExtractTime*}} (14)
> * {{Client9.testExtract*From*}} (8, criteria API)
--
This message was sent by Atlassian Jira
(v10.3.26#10030026)
