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)
