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/03/24 13:50:41 UTC
[jira] [Assigned] (CAY-2208) SQLTemplate: LEFT JOIN to a subset of
a table returns nulls for entries that don't have a match in the subset
[ https://issues.apache.org/jira/browse/CAY-2208?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Nikita Timofeev reassigned CAY-2208:
------------------------------------
Assignee: Nikita Timofeev
> SQLTemplate: LEFT JOIN to a subset of a table returns nulls for entries that don't have a match in the subset
> -------------------------------------------------------------------------------------------------------------
>
> Key: CAY-2208
> URL: https://issues.apache.org/jira/browse/CAY-2208
> Project: Cayenne
> Issue Type: Bug
> Affects Versions: 4.0.M3
> Reporter: Andrei Tomashpolskiy
> Assignee: Nikita Timofeev
> Fix For: 4.0.M6
>
>
> I have a query:
> {code}
> SELECT *
> FROM table1 t1
> LEFT JOIN (SELECT * FROM table2 WHERE <some condition>) t2
> ON (<join by several columns>)
> {code}
> Let's say I have:
> - 6 entries in table1
> - 4 entries in table2 that satisfy the WHERE condition
> In Java I do the following:
> {code}
> SQLTemplate query = new SQLTemplate(Table1.class, <query from above>);
> <set params for WHERE condition>
> List<Table1> rows = (List<Table1>) context.performQuery(query);
> {code}
> *rows* has 6 elements and contains 4 matching entries and 2 _nulls_
> Database is MySQL 5.6.22-log Community Server (GPL)
--
This message was sent by Atlassian JIRA
(v6.3.15#6346)