Description Markus KARG 2009-05-08 08:18:19 EDT

Build ID: N/A

Steps To Reproduce:
JPA QL defines the syntax "x IS NOT NULL" to check for NULL.

SQL defines the exactly same syntax "x IS NOT NULL" to check for NULL.

So one would expect that "x IS NOT NULL" gets translated into "x IS NOT NULL".

But the actually created SQL is "NOT(x IS NULL)".

This is a bit strange, because "NOT(x IS NULL)" is harder to read than "x IS NOT NULL" and in fact is more bytes than the direct translation "x IS NOT NULL".

So I rate this as a bug.

More information: