Okay I found the issue(
HHH-5946 Closed ) that I was looking for but it wasn't exactly about nulls but more about equality in general. Could you still try with hibernate 5 too and maybe even upload a running testcase based on this template? @steve is this expected behavior? I haven't encountered that yet because I don't do embeddable comparisons, but sounds like a serious bug that is not so easy to fix because it alters the sql query based on the parameter values or requires some more complex expressions to be generated. I dug a bit into the topic and there actually is an operator in SQL99 for this called IS DISTINCT FROM which does exactly what we want, but it's only supported by a handful of dbms and the workaround gets quite complex. Here some links
|