[jira] [Created] (METAMODEL-85) isNull() uses = instead of IS NULL in SQL update query

["Dennis Du Krøger (JIRA)" <ji...@apache.org>]

Dennis Du Krøger created METAMODEL-85:
-----------------------------------------

             Summary: isNull() uses = instead of IS NULL in SQL update query 
                 Key: METAMODEL-85
                 URL: https://issues.apache.org/jira/browse/METAMODEL-85
             Project: Metamodel
          Issue Type: Bug
    Affects Versions: 4.2.0-incubating
         Environment: JDK 8 on Windows 7
            Reporter: Dennis Du Krøger


An update statement with a isNull() should with a JdbcDataContext translate to WHERE hello IS NULL, but instead translates to "WHERE hello = NULL", which does not work as intended, since NULL in SQL is never equal to anything, even other NULLs.

{code}
    private void testCode(){
        _dataContext.executeUpdate(new UpdateScript() {            
            @Override
            public void run(UpdateCallback callback) {
                callback.update("foo").value("bar", 1).where("baz").eq(2).where("hello").isNull();
            }
        });
    }
{code}




--
This message was sent by Atlassian JIRA
(v6.3.4#6332)