Richard Zowalla created OPENJPA-3029:
----------------------------------------
Summary: 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
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)
