[hibernate-issues] [Hibernate-JIRA] Commented: (HHH-2409) Oracle incorrect SQL causes ORA-00907: missing right parenthesis

[ http://opensource.atlassian.com/projects/hibernate/browse/HHH-2409?page=c... ] Yajun Shi commented on HHH-2409: -------------------------------- We just did some research on whether the databases that Hibernate currently supports accept keyword "AS" in front of a defined correlation name in the "FROM ... WHERE" clause. The databases assessed include DB2 PostgresSQL MySQL Oracle 9i/10g Sybase Sybase Anywhere Microsoft SQL Server SAP DB Informix HypersonicSQL Ingres Progress-92 Mckoi SQL Interbase Pointbase FrontBase Firebird Oracle 9i/10g doesn't accept keyword "AS" in this case. Others accept it as an optional term. As a result, we'd like to suggest the patch be applied. Yajun Shi SourceLabs - http://www.sourcelabs.com Dependable Open Source Systems -- 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.... - For more information on JIRA, see: http://www.atlassian.com/software/jira