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

InformixDialect: add support for coalesce(), current_timestamp(), current_date()

    Details

    • Type: Improvement
    • Status: Closed
    • Priority: Minor
    • Resolution: Fixed
    • Affects Version/s: 5.0.0.Final, 5.1.0
    • Fix Version/s: 5.2.2, 5.1.1
    • Component/s: hibernate-core
    • Labels:
      None
    • Environment:
      Informix 11.70
      JDBC Driver 4.10

      Description

      I've been extending and using for some time the InformixDialect to support the following functions: coalesce(), current_timestamp() and current_date():

      registerFunction("current_timestamp", new NoArgSQLFunction("current", StandardBasicTypes.TIMESTAMP, false));
      registerFunction("current_date", new NoArgSQLFunction("today", StandardBasicTypes.DATE, false));
      registerFunction("coalesce", new NvlFunction());
      

      Tested it with:
      Informix Dynamic Server 11.70.UC7GE
      IBM Informix JDBC Driver for IBM Informix Dynamic Server 4.10.JC5DE

        Attachments

          Activity

            People

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

              Dates

              • Created:
                Updated:
                Resolved: