[hibernate-issues] [Hibernate-JIRA] Commented: (HBX-949) Column names in generated SQL should be surrounded by the backtick character

[Max Rydahl Andersen (JIRA)]

    [ http://opensource.atlassian.com/projects/hibernate/browse/HBX-949?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel#action_27178 ] 

Max Rydahl Andersen commented on HBX-949:
-----------------------------------------

tophat ?


With respect to quoting then provide patches to MetaDataDialect.needQuote(String identifier) and it will work...

> Column names in generated SQL should be surrounded by the backtick character
> ----------------------------------------------------------------------------
>
>                 Key: HBX-949
>                 URL: http://opensource.atlassian.com/projects/hibernate/browse/HBX-949
>             Project: Hibernate Tools
>          Issue Type: Bug
>          Components: reverse-engineer
>    Affects Versions: 3.2beta9
>         Environment: Any
>            Reporter: William L Baker
>   Original Estimate: 4 hours
>  Remaining Estimate: 4 hours
>
> Orinally opened as HH-2660 for Hibernate Core, and rejected since it can be specified at the mapping (annotation) level.  Revenge should thus put the backticks in the mapping file.
> The original description follows:
> Column names in generated SQL statements should be surrounded by the backtick character. This is necessary for column names that conflict with reserved words or functions. It is easily demonstrated by creating a table with a column name DIV and a column name GROUP. Hibernate currently generates invalid sql statements for accessing this table. "select DIV, GROUP from NEWTABLE" gives a syntax error. "select `DIV`, `GROUP` from NEWTABLE works as expected. It is only necessary to change two lines of code to fix this behavior.
> Though this is supposed to work, it might causes some side effects.  I tested a patch at the Core level, but have not tested revised annotations.
> Don't know how other mapping tools behave such as tophat.

-- 
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators: http://opensource.atlassian.com/projects/hibernate/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira