[Hibernate-issues] [Hibernate-JIRA] Created: (HHH-1760) day sql-function does not exist in MySQL before 4.1.1

[Andrey G. (JIRA) <no...@at...>]

day sql-function does not exist in MySQL before 4.1.1
-----------------------------------------------------

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

  Components: core  
    Versions: 3.1.3    
 Environment: Hibernate 3.1.3, MySQL 4.0.20d
    Reporter: Andrey Grebnev


Hello

MySQLDialect.java has the following definition: 

        registerFunction("day", new StandardSQLFunction("day", Hibernate.INTEGER) ); 

but we can read in MySQL documentation that

        DAY(date) 
        DAY() is a synonym for DAYOFMONTH(). It is available as of MySQL 4.1.1. 

so before mysql 4.1.1 we does not have day function.

I offer to replace above line in Dialect with the following

        registerFunction("day", new StandardSQLFunction("dayofmonth", Hibernate.INTEGER) ); 

In this way we will have compatibility with MySql versions both before 4.1.1 and after 4.1.1.

Thanks.

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