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

[Steve Ebersole (JIRA)]

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

Steve Ebersole closed HHH-1035.
-------------------------------


Closing stale resolved issues

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

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