[
https://issues.apache.org/jira/browse/OPENJPA-3042?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Richard Zowalla updated OPENJPA-3042:
-------------------------------------
Fix Version/s: 4.2.0
> In-memory EXTRACT(WEEK) returns the day of the week
> ---------------------------------------------------
>
> Key: OPENJPA-3042
> URL: https://issues.apache.org/jira/browse/OPENJPA-3042
> Project: OpenJPA
> Issue Type: Sub-task
> Reporter: Richard Zowalla
> Assignee: Richard Zowalla
> Priority: Major
> Fix For: 4.2.0
>
>
> When EXTRACT(WEEK) is evaluated in memory, {{DateTimeExtractField.WEEK}} is
> mapped to {{ChronoField.ALIGNED_DAY_OF_WEEK_IN_YEAR}}, which is a day-of-week
> value (1 to 7), not the ISO week of the year. It should use
> {{IsoFields.WEEK_OF_WEEK_BASED_YEAR}}, matching the SQL side (OPENJPA-3037).
> Found while testing OPENJPA-3029.
--
This message was sent by Atlassian Jira
(v10.3.26#10030026)
