[hibernate-issues] [Hibernate-JIRA] Resolved: (ANN-529) MapBinder can generate SQL statements not supported by Oracle 10g

[Emmanuel Bernard (JIRA)]

     [ http://opensource.atlassian.com/projects/hibernate/browse/ANN-529?page=all ]
     
Emmanuel Bernard resolved ANN-529:
----------------------------------

    Fix Version: 3.2.2
     Resolution: Fixed
      Assign To: Emmanuel Bernard

Done thanks

> MapBinder can generate SQL statements not supported by Oracle 10g
> -----------------------------------------------------------------
>
>          Key: ANN-529
>          URL: http://opensource.atlassian.com/projects/hibernate/browse/ANN-529
>      Project: Hibernate Annotations
>         Type: Improvement

>   Components: binder
>     Reporter: Arnout Engelen
>     Assignee: Emmanuel Bernard
>      Fix For: 3.2.2

>
>
> http://fisheye.jboss.org/browse/Hibernate/trunk/HibernateExt/metadata/src/java/org/hibernate/cfg/annotations/MapBinder.java?r=trunk#l264 uses the optional 'as' keyword in the from clause. 
> While a late draft of the sql standard suggests this should be optionally allowed (http://www.wiscorp.com/sql_2003_standard.zip, 5WD-02-Foundation-2003-09.pdf, 7.6 <table reference>), Oracle 10g does not seem to support it (http://download-uk.oracle.com/docs/cd/B14117_01/server.101/b10759/statements_10002.htm#i2126863).
> Hibernate is `right' here, but it'd be convenient if this optional keyword was left out.

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