Mailing-List: contact dev-help@metamodel.incubator.apache.org; run by ezmlm
Precedence: bulk
Reply-To: dev@metamodel.incubator.apache.org
Date: Fri, 7 Nov 2014 14:19:42 +0000 (UTC)
From: =?utf-8?Q?Dennis_Du_Kr=C3=B8ger_=28JIRA=29?= <jira@apache.org>
To: dev@metamodel.incubator.apache.org
Message-ID: <JIRA.12748219.1413358316000.445359.1415369982332@Atlassian.JIRA>
In-Reply-To: <JIRA.12748219.1413358316000@Atlassian.JIRA>
References: <JIRA.12748219.1413358316000@Atlassian.JIRA>
 <JIRA.12748219.1413358316882@arcas>
Subject: [jira] [Commented] (METAMODEL-85) isNull() uses = instead of IS
 NULL in SQL update query
MIME-Version: 1.0
Content-Type: text/plain; charset=utf-8
Content-Transfer-Encoding: quoted-printable


    [ https://issues.apache.org/jira/browse/METAMODEL-85?page=3Dcom.atlassi=
an.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=3D14=
202082#comment-14202082 ]=20

Dennis Du Kr=C3=B8ger commented on METAMODEL-85:
-------------------------------------------

That is just my example being badly recreated. The statement was certainly =
run, as we saw the generated SQL do the "WHERE x =3D NULL".

We talked about it at the time, and I think we reached the conclusion that =
it works as it should for SELECT statements, but not for UPDATE statements.=
 The fix you remember may have been for SELECT?

> isNull() uses =3D instead of IS NULL in SQL update query=20
> -------------------------------------------------------
>
>                 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=C3=B8ger
>
> An update statement with a isNull() should with a JdbcDataContext transla=
te to WHERE hello IS NULL, but instead translates to "WHERE hello =3D NULL"=
, which does not work as intended, since NULL in SQL is never equal to anyt=
hing, even other NULLs.
> {code}
>     private void testCode(){
>         _dataContext.executeUpdate(new UpdateScript() {           =20
>             @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)