[
https://issues.apache.org/jira/browse/OPENJPA-3074?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=18143504#comment-18143504
]
ASF subversion and git services commented on OPENJPA-3074:
----------------------------------------------------------
Commit ff0c0d22d9e6349f69722615a24d94c3fc0ef2d2 in openjpa's branch
refs/heads/OPENJPA-3076 from Richard Zowalla
[ https://gitbox.apache.org/repos/asf?p=openjpa.git;h=ff0c0d22d ]
[OPENJPA-3074] Test tables and columns named after words that MySQL or MariaDB
reserve
TestMySQLReservedWordColumns gets the entities Linear, Dual and Ntile, whose
table and column names are words that MySQL and MariaDB, only MariaDB or only
MySQL reserve. It runs on MySQL and MariaDB only, since Derby rejects a table
named Window.
> Share the common code of MySQLDictionary and MariaDBDictionary in a
> superclass and add the MySQL 8 reserved words
> -----------------------------------------------------------------------------------------------------------------
>
> Key: OPENJPA-3074
> URL: https://issues.apache.org/jira/browse/OPENJPA-3074
> Project: OpenJPA
> Issue Type: Improvement
> Reporter: Richard Zowalla
> Assignee: Richard Zowalla
> Priority: Major
> Fix For: 4.2.0
>
>
> MySQLDictionary and MariaDBDictionary both extend DBDictionary and duplicate
> most of their code, as noted in the review of #297 (OPENJPA-2943). Move the
> shared code into a common abstract superclass and keep the per-database
> differences and defaults in the two subclasses. All public configuration
> fields stay as they are.
> MySQLDictionary also lacks the reserved words MySQL 8.0 added, such as RANK,
> ROW_NUMBER, WINDOW and LATERAL. An entity attribute named rank therefore
> produces a CREATE TABLE statement that fails on MySQL 8.4 and 9.x.
--
This message was sent by Atlassian Jira
(v10.3.26#10030026)
