You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@cayenne.apache.org by "Nikita Timofeev (JIRA)" <ji...@apache.org> on 2017/09/26 14:24:00 UTC
[jira] [Created] (CAY-2368) Query with Property.self() translated
into wrong SQL code
Nikita Timofeev created CAY-2368:
------------------------------------
Summary: Query with Property.self() translated into wrong SQL code
Key: CAY-2368
URL: https://issues.apache.org/jira/browse/CAY-2368
Project: Cayenne
Issue Type: Bug
Components: Core Library
Affects Versions: 4.0.B2, 4.1.M1
Reporter: Nikita Timofeev
Assignee: Nikita Timofeev
In some cases column query with "self" property can be translated into wrong SQL.
In particular following code:
{code}
ObjectSelect.columnQuery(Artist.class,
Artist.PAINTING_ARRAY.dot(Painting.PAINTING_TITLE),
Property.createSelf(Artist.class)).select(context);
{code}
Translates into this SQL:
{code}
SELECT
DISTINCT t1.PAINTING_TITLE,
t1.ARTIST_NAME, t1.DATE_OF_BIRTH, t1.ARTIST_ID
FROM ARTIST t0
JOIN PAINTING t1 ON (t0.ARTIST_ID = t1.ARTIST_ID)
{code}
Here is wrong {{t1}} alias used for {{Artist}} property. Note that changing order of columns leads to correct query.
--
This message was sent by Atlassian JIRA
(v6.4.14#64029)