[
https://issues.apache.org/jira/browse/OPENJPA-3029?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Richard Zowalla updated OPENJPA-3029:
-------------------------------------
Fix Version/s: 4.2.0
> 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
> Fix For: 4.2.0
>
>
> 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)
