[
https://issues.apache.org/jira/browse/OPENJPA-3037?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=18134620#comment-18134620
]
ASF subversion and git services commented on OPENJPA-3037:
----------------------------------------------------------
Commit ead321648648cef2e314582112726ac7edc497fa in openjpa's branch
refs/heads/OPENJPA-3044 from Richard Zowalla
[ https://gitbox.apache.org/repos/asf?p=openjpa.git;h=ead321648 ]
[OPENJPA-3029][OPENJPA-3037] Fix EXTRACT on Derby and EXTRACT(WEEK) on MySQL
and MariaDB (#236)
* [OPENJPA-3029] Render EXTRACT on Derby with its per-field date and time
functions
* [OPENJPA-3037] Extract the ISO week on MySQL and MariaDB
* [OPENJPA-3037] Extract the ISO week on H2 whatever the JVM locale
* [OPENJPA-3029] Use try-with-resources in the test
* [OPENJPA-3029] Use pattern matching for the cast of the extract operand
> MySQL: EXTRACT(WEEK) returns a different week
> ---------------------------------------------
>
> Key: OPENJPA-3037
> URL: https://issues.apache.org/jira/browse/OPENJPA-3037
> Project: OpenJPA
> Issue Type: Sub-task
> Reporter: Richard Zowalla
> Priority: Major
> Fix For: 4.2.0
>
>
> {{Client9.testExtractWeekFromDate}} fails with {{IndexOutOfBoundsException:
> Index 0 out of bounds for length 0}}, so the query finds no row. MySQL
> {{WEEK(d)}} uses mode 0 by default (weeks start on Sunday), while the
> expected value is the ISO week ({{WEEK(d, 3)}}).
--
This message was sent by Atlassian Jira
(v10.3.26#10030026)
