[hibernate-issues] [Hibernate-JIRA] Created: (HHH-2046) ability to use dialect-registered functions in formula mappings

[Steve Ebersole (JIRA)]

ability to use dialect-registered functions in formula mappings
---------------------------------------------------------------

         Key: HHH-2046
         URL: http://opensource.atlassian.com/projects/hibernate/browse/HHH-2046
     Project: Hibernate3
        Type: Improvement

  Components: core  
    Reporter: Steve Ebersole
 Assigned to: Steve Ebersole 


Consider org.hibernate.test.compositeelement.CompositeElementTest.  Currently, those tests fail on Sybase/SQLServer because neither of those databases support a length function and the mappings map a property formula using the length function.

Both dialects do however, map the length() to len() which is valid on both.  

Perhaps a syntax like:
<property name="bioLength" formula="fn:length(bio)"/> or <property name="bioLength" formula="fn:{length(bio)}"/>

Eventually maybe even:
<property name="bioLength" formula="{length(bio)}"/>
where anything inside the {} would be treated as HQL fragment.  That, of course, relies on the redesign of the translator (if it is even doable then).


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