[hibernate-issues] [Hibernate-JIRA] Closed: (HHH-1035) AS clause should be optional and asked to Dialect

AS clause should be optional and asked to Dialect ------------------------------------------------- Key: HHH-1035 URL: http://opensource.atlassian.com/projects/hibernate/browse/HHH-1035 Project: Hibernate Core Issue Type: Bug Affects Versions: 3.1 rc 1 Environment: Any version, CTSQL database Reporter: Aimar Tellitu Assignee: Steve Ebersole I'm implementing a new Dialect for a non very popular DB, CTSQL of TransTOOLs S.A. The problem is that for this Database, one SELECT like this has syntax errors: select this_.state AS state0_, this_.sname AS sname0_0_ from states this_ In this database sql syntax, AS clause isn't included and the correct SELECT should be: select this_.state state0_, this_.sname sname0_0_ from states this_ I have check the "American National Standard X3.135-1992" and I have seen that AS clause is optional. Oddly, in many other Database the AS clause is mandatory. So, I guess that this problem should be fixed adding one method in org.hibernate.dialect.Dialect to determine if the AS clause should be added or not to the SELECT. Thank you.