[Hibernate-issues] [Hibernate-JIRA] Commented: (HB-117) Support for more SQL functions in SELECT

[<leg...@at...>]

The following comment has been added to this issue:

     Author: David Channon
    Created: Mon, 2 Jun 2003 7:29 AM
       Body:
I accept the issue. I can see it has a high priority. See how we go - I cannot say that it will be done for v2.0 release.
---------------------------------------------------------------------
View the issue:

  http://opensource.atlassian.com/projects/hibernate/secure/ViewIssue.jspa?key=HB-117


Here is an overview of the issue:
---------------------------------------------------------------------
        Key: HB-117
    Summary: Support for more SQL functions in SELECT
       Type: Improvement

     Status: Assigned
   Priority: Major

    Project: Hibernate2
 Components: 
             core

   Assignee: David Channon
   Reporter: Gavin King

    Created: Sun, 1 Jun 2003 7:58 PM
    Updated: Sun, 1 Jun 2003 7:59 PM

Description:
Currently, Hibernate supports exactly five (hardcoded) SQL functions in the HQL SELECT clause. They are the aggregate functions COUNT(), AVG(), SUM(), MIN(), MAX()

A number of users would like to be able to specify an arbitrary SQL function in the SELECT. The problem here is that we need to know the return type of the function to be able to read it from the result set.

I propose that the Dialect classes include a collection of mappings from function names to Hibernate types (eg. CURRENT_DATE -> Hibernate.DATE). That way, we can support the most commonly used SQL functions, and others can be easily added by users providing extensions to the Dialect.


So, we would like to allow:

SELECT CURRENT_DATE(), TRUNC(foo.amount), ......


---------------------------------------------------------------------
JIRA INFORMATION:
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/Administrators.jspa

If you want more information on JIRA, or have a bug to report see:
   http://www.atlassian.com/software/jira