Mailing-List: contact derby-dev-help@db.apache.org; run by ezmlm
Precedence: bulk
Reply-To: <derby-dev@db.apache.org>
Date: Wed, 2 Oct 2013 10:36:26 +0000 (UTC)
From: =?utf-8?Q?Grzegorz_=C5=BBur_=28JIRA=29?= <jira@apache.org>
To: derby-dev@db.apache.org
Message-ID: <JIRA.12671764.1380710075710.16589.1380710186242@arcas>
In-Reply-To: <JIRA.12671764.1380710075710@arcas>
References: <JIRA.12671764.1380710075710@arcas>
Subject: [jira] [Created] (DERBY-6365) Incorrect evaluation of logical
 expressions in CASE
MIME-Version: 1.0
Content-Type: text/plain; charset=utf-8
Content-Transfer-Encoding: quoted-printable

Grzegorz =C5=BBur created DERBY-6365:
-----------------------------------

             Summary: Incorrect evaluation of logical expressions in CASE
                 Key: DERBY-6365
                 URL: https://issues.apache.org/jira/browse/DERBY-6365
             Project: Derby
          Issue Type: Bug
          Components: SQL
    Affects Versions: 10.10.1.1, 10.8.3.0, 10.4.1.3
            Reporter: Grzegorz =C5=BBur


Logical expressions with AND and OR operators inside WHEN inside CASE expre=
ssion nested in SELECT part of statement are wrongly evaluated.
Evaluation results depends on position of OR subexpression. If OR is placed=
 on left side of AND it is evaluated incorrectly.

Following code shows the error.

create table t ( a int, b char );

insert into t values (1, 'a');
insert into t values (2, 'b');
insert into t values (3, 'a');
insert into t values (4, 'b');
insert into t values (5, 'a');
insert into t values (6, 'b');

select
a,
b,
case
    when (( b =3D 'a' or b =3D 'b' ) and a < 4) then 'x'
    else '-'
end,
case
    when (a < 4 and ( b =3D 'a' or b =3D 'b' )) then 'y'
    else '-'
end
from t;

Actual result:
1 a x y
2 b - y
3 a x y
4 b - -
5 a - -
6 b - -

Expected result
1 a x y
2 b x y
3 a x y
4 b - -
5 a - -
6 b - -


--
This message was sent by Atlassian JIRA
(v6.1#6144)