Mailing-List: contact user-help@cayenne.apache.org; run by ezmlm
Precedence: bulk
Reply-To: user@cayenne.apache.org
From: Andrus Adamchik <andrus@objectstyle.org>
Content-Type: text/plain;
	charset=utf-8
Content-Transfer-Encoding: quoted-printable
Mime-Version: 1.0 (Mac OS X Mail 11.2 \(3445.5.20\))
Subject: Re: Queries with joins and entity qualifiers are broken in
 cayenne-3.1.2
Date: Tue, 12 Dec 2017 07:04:19 -0500
References: <CAKan_KT=yqpGqytpj15C1vC4cnogOXBW3qN5FVTpftgAXf-okQ@mail.gmail.com>
 <CAKan_KR+r5P6EfyeNS-15x+4EBG7eSaVhDjVCNxp2FkUqUY-xQ@mail.gmail.com>
To: user@cayenne.apache.org
In-Reply-To: <CAKan_KR+r5P6EfyeNS-15x+4EBG7eSaVhDjVCNxp2FkUqUY-xQ@mail.gmail.com>
Message-Id: <BC827CC6-7148-497E-AEE7-3EA90527B580@objectstyle.org>
archived-at: Tue, 12 Dec 2017 12:04:26 -0000

Hi Vladimir,

This looks like a bug to me. We'll investigate.

Andrus

> On Dec 12, 2017, at 6:37 AM, =D0=92=D0=BB=D0=B0=D0=B4=D0=B8=D0=BC=D0=B8=D1=
=80 =D0=A1=D1=83=D1=85=D0=B8=D0=BD=D0=B8=D0=BD =
<suhininvladimir@gmail.com> wrote:
>=20
> I've found that if I use ExpressionFactory.matchDbExp for
> DbEntity.setQualifier,
> cayenne use wrong aliases when building join queries.
> And if I use ExpressionFactory.matchExp for DbEntity.setQualifier, =
cayenne
> build joins with correct aliases.
> Using matchExp  instead of matchDbExp  for DbEntity looks wired, but =
it
> works. So I've found a workaround, but not sure, is it a bug or a =
feature.
>=20
> 2017-12-11 17:31 GMT+03:00 =D0=92=D0=BB=D0=B0=D0=B4=D0=B8=D0=BC=D0=B8=D1=
=80 =D0=A1=D1=83=D1=85=D0=B8=D0=BD=D0=B8=D0=BD =
<suhininvladimir@gmail.com>:
>=20
>> We have a database where all entities have a qualifier for "deleted"
>> field, which is added via DbEntity.setQualifier(Expression) during
>> DataMap loading.
>> When we create a SelectQuery, this qualifiers added in join "ON" node =
with
>> wrong table alias.
>> So our query looks like this:
>> SELECT DISTINCT t0.CUSTOMERID AS c0,
>>      UPPER(t0.CUSTOMERLASTNAME)   AS c1
>>    FROM CUSTOMER t0
>>    LEFT JOIN CUSTOMER_GROUP t1
>>    ON (t0.CUSTOMERID =3D t1.CUSTOMERID
>>    AND t0.DELETED    =3D 0)
>>    JOIN GROUP t2
>>    ON (t1.GROUPID =3D t2.GROUPID
>>    AND t0.DELETED =3D 0)
>>    WHERE (t2.GROUPTYPEID =3D 101100100145)
>>    AND (t0.DELETED       =3D 0)
>>    ORDER BY UPPER(t0.CUSTOMERLASTNAME)
>>   ;
>> Earlier we've used cayenne-3.0RC3, and there queries with same =
DataMap and
>> qualifiers creates correctly
>> SELECT DISTINCT t0.CUSTOMERID,
>>      UPPER(t0.CUSTOMERLASTNAME)
>>    FROM CUSTOMER t0
>>    LEFT JOIN CUSTOMER_GROUP t1
>>    ON (t0.CUSTOMERID =3D t1.CUSTOMERID
>>    AND t1.DELETED    =3D 0)
>>    JOIN GROUP t2
>>    ON (t1.GROUPID =3D t2.GROUPID
>>    AND t2.DELETED =3D 0)
>>    WHERE (t2.GROUPTYPEID =3D 101100100145)
>>    AND (t0.DELETED       =3D 0)
>>    ORDER BY UPPER(t0.CUSTOMERLASTNAME)
>> ;
>>=20
>> --
>> Vladimir Suhinin
>>=20