[hibernate-issues] [Hibernate-JIRA] Updated: (HHH-5135) "Ambiguous column" exception thrown with columns having the same name as a function registered with the dialect (e.g. to_date, floor)

[Gail Badner (JIRA)]

     [ http://opensource.atlassian.com/projects/hibernate/browse/HHH-5135?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Gail Badner updated HHH-5135:
-----------------------------

    Fix Version/s: 3.6

`current_date` is correctly changed to [current_date] for SQL Server, but this still fails because current_date is a reserved word.

The fix is working correctly. I'll exclude this test for SQL Server.

> "Ambiguous column" exception thrown with columns having the same name as a function registered with the dialect (e.g. to_date, floor)
> -------------------------------------------------------------------------------------------------------------------------------------
>
>                 Key: HHH-5135
>                 URL: http://opensource.atlassian.com/projects/hibernate/browse/HHH-5135
>             Project: Hibernate Core
>          Issue Type: Bug
>          Components: core
>    Affects Versions: 3.5.0-Final, 3.5.1
>         Environment: Hibernate 3.5.1, Oracle 10.2.0.1.0
>            Reporter: Vladimir Ivanov
>            Assignee: Gail Badner
>             Fix For: 3.5.2, 3.6
>
>         Attachments: test_case.zip
>
>   Original Estimate: 8h
>          Time Spent: 7h 31m
>  Remaining Estimate: 29m
>
> I have entity 'Period' with property 'toDate' mapped to database column with name 'TO_DATE' (Our database is Oracle 10g). When this entity is queried via HQL, prefix for this entity is missed. Following SQL query is produced:
> Hibernate: 
>     /* 
> from
>     Period p */ select
>         * 
>     from
>         ( select
>             period0_.ID as ID44_,
>             period0_.TXN_VER as TXN3_44_,
>             period0_.FROM_DATE as FROM4_44_,
>             TO_DATE as TO5_44_,
>             period0_.POSITION_MONTH as POSITION7_44_,
>             period0_.IS_CLOSE as IS12_44_,
>             period0_.IS_OPEN as IS13_44_,
>             period0_.DISC_TYPE as DISC2_44_ 
>         from
>             SOME_SCHEMA.T_PERIOD period0_ ) 
>     where
>         rownum <= ?
> This leads to database error in case of more advanced query (with joins etc). For example, we have following error in production: java.sql.SQLException: ORA-00918: column ambiguously defined
> Probably the reason of this behaviour is that Hibernate tries to interpret 'TO_DATE' as the name of SQL function.
> In Hibernate 3.3.2.GA prefix is added correctly.
> Domain object, DAO, Test and Hibernate configuration are in the attachment.
> I used Spring framework to configure test.

-- 
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