[
https://issues.apache.org/jira/browse/OPENJPA-3038?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=18138835#comment-18138835
]
ASF subversion and git services commented on OPENJPA-3038:
----------------------------------------------------------
Commit 278c4cc5c1b56b634c397177ae9b3e642a3c39bf in openjpa's branch
refs/heads/OPENJPA-3038 from Richard Zowalla
[ https://gitbox.apache.org/repos/asf?p=openjpa.git;h=278c4cc5c ]
[OPENJPA-3038] Run the TCK against case insensitive MySQL table names
The TCK's MySQL scripts create upper case tables (PERSON, INSURANCE, ...)
while entities without @Table map to their entity name (Person,
Insurance). With case sensitive table names (lower_case_table_names=0,
the Linux default) SynchronizeMappings creates a second Person table, the
TCK cleanup (DELETE FROM PERSON) never removes its rows and later tests
fail with duplicate keys or foreign key violations against the empty
upper case tables.
A TCK run of master against MySQL 8.4 and MariaDB 12.3 started with
--lower_case_table_names=1 fixes 29 tests on MySQL and 30 on MariaDB
(relationship.defaults, relationship.annotations, orderby, ordercolumn,
mapkeyclass, mapkeyjoincolumn, assocoverride, derivedid ex1b, mappedsc,
bidirmanyxmany, jpa22.repeatable; on MariaDB also elementcollection)
with no regressions. No duplicate CREATE TABLE attempts appear with
the lower case names reported by the server.
Start the dockerized MySQL with lower_case_table_names=1 when run-tck32.sh
runs the TCK (pom property, default unchanged for the OpenJPA test suite)
and document the requirement for --no-docker setups. run-tck32.sh has no
MariaDB support, so only MySQL is configured here.
> MySQL: mapping, order column and map key tests fail
> ---------------------------------------------------
>
> Key: OPENJPA-3038
> URL: https://issues.apache.org/jira/browse/OPENJPA-3038
> Project: OpenJPA
> Issue Type: Sub-task
> Reporter: Richard Zowalla
> Priority: Major
>
> These tests fail on MySQL and only report "failed", the cause has to be found
> from the TCK logs:
> * {{Client.associationOverride}}, {{mapKeyClass}}, {{mapKeyJoinColumn}},
> {{mapKeyJoinColumnTest}}
> * {{Client1.orderByTest1}} to {{orderByTest4}}, {{orderColumn}},
> {{orderColumnTest}}
> * {{annotationMappingTest1}}, {{3}} to {{8}}, {{mappingTest1}} to {{8}},
> {{biDirMXMTest1}}
> * {{DIDTest}}, {{didTest}}, {{test1}}, {{joinTableTest}},
> {{secondaryTableTest}}, {{uniqueConstraintTest}}
> * {{Client1.setParameterParameterCalendarTemporalTypeTest}} (also on SQL
> Server)
--
This message was sent by Atlassian Jira
(v10.3.26#10030026)
