metamodel-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Kasper Sørensen (JIRA) <j...@apache.org>
Subject [jira] [Updated] (METAMODEL-85) isNull() uses = instead of IS NULL in SQL update query
Date Fri, 07 Nov 2014 18:53:35 GMT

     [ https://issues.apache.org/jira/browse/METAMODEL-85?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]

Kasper Sørensen updated METAMODEL-85:
-------------------------------------
    Priority: Critical  (was: Major)

> 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
>            Priority: Critical
>
> 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)

Mime
View raw message