[
https://issues.apache.org/jira/browse/OPENJPA-3076?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=18143693#comment-18143693
]
ASF subversion and git services commented on OPENJPA-3076:
----------------------------------------------------------
Commit 53cba295e13f8f6e0ee83c2a949e8162e158fd53 in openjpa's branch
refs/heads/OPENJPA-3076 from Richard Zowalla
[ https://gitbox.apache.org/repos/asf?p=openjpa.git;h=53cba295e ]
[OPENJPA-3076] Expect the Derby names of OPENJPA-3075 and test every name dump
setup next to all others
Since OPENJPA-3075 the Derby dictionary reserves WINDOW and renames a default
table name Derby rejects, so Window becomes WINDOW0 on Derby whichever
dictionary is configured first. The per dictionary tests now use RANK and
Partition, which MySQL reserves and Derby does not, for a name MySQL delimits
and Derby leaves alone, and expect WINDOW0 on Derby. A new test maps every
setup of the name dump after the dictionaries of all setups were configured,
in either order, and compares the names with those the setup gets alone.
> Delimiting of reserved words is a JVM-wide setting, so the dictionary
> configured last decides it for all persistence units
> ---------------------------------------------------------------------------------------------------------------------------
>
> Key: OPENJPA-3076
> URL: https://issues.apache.org/jira/browse/OPENJPA-3076
> Project: OpenJPA
> Issue Type: Bug
> Reporter: Richard Zowalla
> Priority: Major
> Fix For: 4.2.0
>
>
> Whether a reserved word is delimited is decided by a shared static
> IdentifierRule. MySQLDictionary (and MariaDBDictionary since OPENJPA-3074)
> switches it on, and every other dictionary resets it. With persistence units
> for different databases in one JVM, the dictionary configured last decides
> the names for all of them. For example, after Derby is configured, MySQL's
> Window table becomes WINDOW0. Delimiting should be decided per configuration.
--
This message was sent by Atlassian Jira
(v10.3.26#10030026)