Uploaded image for project: 'Hibernate ORM'
  1. HHH-3788

FirebirdDialect: current_date() function

    Details

    • Type: Bug
    • Status: Closed
    • Priority: Major
    • Resolution: Fixed
    • Affects versions: 3.3.1
    • Fix versions: 4.2.0.CR1, 4.1.10, 4.3.0.Beta1
    • Components: query-hql
    • Labels:
      None
    • Environment:
      3.3.1, Firebird 1.5
    • Bug Testcase Reminder (view):

      Bug reports should generally be accompanied by a test case!

    • Last commented by a user?:
      true
    • Sprint:

      Description

      The FirebirdDialect does not supports current_date() function. A select like "select * from test where dt < current_date()" causes the following exception:

      Caused by: org.firebirdsql.jdbc.FBSQLException: GDS Exception. 335544569. Dynamic SQL Error
      SQL error code = -104
      Token unknown - line 1, column X
      (

      In MySQLDialect.java there is:

      registerFunction("current_date", new NoArgSQLFunction("current_date", Hibernate.DATE, false) );

      But in InterbaseDialect.java or FirebirdDialect.java there is not the current_date function.

        Attachments

          Activity

            People

            • Votes:
              0 Vote for this issue
              Watchers:
              1 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: