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

[Arnout Engelen (JIRA)]

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


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