[jira] [Commented] (OFBIZ-563) Entity Model Reader needs reserved word check

["Adam Heath (JIRA)" <ji...@apache.org>]

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

Adam Heath commented on OFBIZ-563:
----------------------------------

Currently, in trunk, when the sql is created for a view, if a constructed aliased column name becomes too long, the name of the column is switched to one based on systemHashCode() converted to a string.  Perhaps this could be done on all fields.

If done, however, it'll make debugging the generated sql a bit more difficult.

> Entity Model Reader needs reserved word check
> ---------------------------------------------
>
>                 Key: OFBIZ-563
>                 URL: https://issues.apache.org/jira/browse/OFBIZ-563
>             Project: OFBiz
>          Issue Type: Improvement
>          Components: framework
>            Reporter: Chris Howe
>            Assignee: Adam Heath
>            Priority: Minor
>
> Entity Engine needs to check if alias for member enttity is a reserved word.  If someone could point me in the direction of a comprehensive list for most databases, I would be happy to look into implementing this. Would this be better to simply throw an error or to append the reserved word with nonsensical letters?  Is there actual usage (or could there be actual usage) of the member entity's defined alias outside of the scope of the entity engine?



--
This message was sent by Atlassian JIRA
(v6.2#6252)