[ 
https://issues.apache.org/jira/browse/OPENJPA-3075?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=18142846#comment-18142846
 ] 

ASF subversion and git services commented on OPENJPA-3075:
----------------------------------------------------------

Commit ba4d1b6b583a32beea74a0a533b8a6a1cd1d32f0 in openjpa's branch 
refs/heads/OPENJPA-3075 from Richard Zowalla
[ https://gitbox.apache.org/repos/asf?p=openjpa.git;h=ba4d1b6b5 ]

[OPENJPA-3075] Use the words Derby rejects as unquoted identifiers as reserved 
words of the Derby dictionary

Derby 10.16 rejects BIGINT, CURRENT_ROLE, CURSORS, DEFINER, DETERMINISTIC,
GETCURRENTCONNECTION, INVOKER, WINDOW and XMLQUERY as unquoted table,
sequence, index, constraint and schema names, and CURSORS also as a column
name, but the dictionary did not know them, so the names generated from them
were used as they are and the DDL failed. The words were found by trying every
token of the Derby grammar and the SQL keywords known to OpenJPA as an unquoted
table and column name. Only names Derby rejects change.


>  DerbyDictionary does not know WINDOW and other words Derby reserves
> --------------------------------------------------------------------
>
>                 Key: OPENJPA-3075
>                 URL: https://issues.apache.org/jira/browse/OPENJPA-3075
>             Project: OpenJPA
>          Issue Type: Bug
>            Reporter: Richard Zowalla
>            Priority: Major
>             Fix For: 4.2.0
>
>
> DerbyDictionary's reserved words are missing words that Derby rejects as 
> unquoted identifiers, such as WINDOW. An entity named Window therefore 
> produces CREATE TABLE Window, which fails on Derby. Add the missing words, 
> taken from Derby itself.



--
This message was sent by Atlassian Jira
(v10.3.26#10030026)

Reply via email to