Support HQL NULLIF function

XMLWordPrintableJSON

    • Type: New Feature
    • Resolution: Unresolved
    • Priority: Unknown
    • None
    • Affects Version/s: None
    • Component/s: Query
    • None
    • 3
    • None
    • None
    • None
    • None
    • None
    • None
    • None

      Hibernate User Guide relevant section: https://docs.jboss.org/hibernate/orm/6.6/userguide/html_single/Hibernate_User_Guide.html#_nullif

      HQL example:

      select nullif(p.nickName, p.name) from Person p 

      The above select field will return NULL if nickName is equal to name; otherwise will return nickName.

      The NULLIF function can be represented in MQL using $cond.

            Assignee:
            Unassigned
            Reporter:
            Jeffrey Yemin
            None
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

              Created:
              Updated: