Message Title

Marius K commented on

Hi Jan,

thank you for looking into this. I attached a new example based on the hibernate-test-case-templates.

Using <property name="hibernate.dialect" value="org.hibernate.dialect.H2Dialect"/> or <property name="hibernate.dialect" value="org.hibernate.dialect.SybaseDialect"/>

results in

                              Hibernate: 
    select
        m1_0.MY_USER_ID,
        m1_0.FIRSTNAME,
        m1_0.LASTNAME 
    from
        MY_USER m1_0 
    where
        m1_0.FIRSTNAME=? 
        and m1_0.LASTNAME=?
                              

which is fine

But <property name="hibernate.dialect" value="org.hibernate.dialect.SybaseASEDialect"/> results in

                              Hibernate: 
    select
        m1_0.MY_USER_ID,
        m1_0.FIRSTNAME,
        m1_0.LASTNAME 
    from
        MY_USER m1_0 
    where
        m1_0.FIRSTNAME=? 
        and m1_0.FIRSTNAME is not null 
        and m1_0.LASTNAME=? 
        and m1_0.LASTNAME is not null
                              

which has additionall null checks

Add Comment

Get Jira notifications on your phone! Download the Jira Cloud app for Android or iOS

This message was sent by Atlassian Jira