[hibernate-issues] [Hibernate-JIRA] Resolved: (HHH-5128) [regression] Columns named "to_date" no longer work

[regression] Columns named "to_date" no longer work --------------------------------------------------- Key: HHH-5128 URL: http://opensource.atlassian.com/projects/hibernate/browse/HHH-5128 Project: Hibernate Core Issue Type: Bug Affects Versions: 3.5.1 Environment: Database = Oracle 10g Reporter: Ramon Casha Assignee: Gail Badner Using Hibernate 3.2, I had columns named from_date and to_date - these worked without problems. Since upgrading to Hibernate 3.5, the column to_date no longer works. When generating SQL queries, this column is not prefixed by the table alias name. For example, Hibernate generates the following SQL: select amounts0_.from_date as from14_44_1_, to_date as to18_44_1_ --etc-- from reg_alloc_amount amounts0_ left outer join reg_alloc_amount allocamoun1_ on amounts0_.rec_link_id=allocamoun1_.alloc_amount_id This gives java.sql.SQLException: ORA-00918: column ambiguously defined I suspect that Hibernate treats to_date as an Oracle function instead of a column.