cayenne-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From John Huss <johnth...@gmail.com>
Subject Re: [jira] [Commented] (CAY-1996) Adding a prefetch to a SelectQuery via string path doesn't work
Date Thu, 02 Apr 2015 14:29:21 GMT
Shouldn't it throw an exception with a descriptive message? Silently
ignoring it isn't especially helpful.
On Thu, Apr 2, 2015 at 8:27 AM Andrus Adamchik (JIRA) <jira@apache.org>
wrote:

>
>     [ https://issues.apache.org/jira/browse/CAY-1996?page=com.
> atlassian.jira.plugin.system.issuetabpanels:comment-
> tabpanel&focusedCommentId=14392733#comment-14392733 ]
>
> Andrus Adamchik commented on CAY-1996:
> --------------------------------------
>
> Good catch [~SavvaKolbachev]. This is data rows we are talking about.
>
> > Adding a prefetch to a SelectQuery via string path doesn't work
> > ---------------------------------------------------------------
> >
> >                 Key: CAY-1996
> >                 URL: https://issues.apache.org/jira/browse/CAY-1996
> >             Project: Cayenne
> >          Issue Type: Bug
> >          Components: Core Library
> >    Affects Versions: 4.0.M2
> >         Environment: MySQL 5.5.40-MariaDB-36.1, InnoDB, Mac OS X 10.10,
> Java 8u40 (build 1.8.0_40-b27)
> >            Reporter: Hugi Thordarson
> >            Assignee: Savva Kolbachev
> >
> > Adding a prefetch to a selectQuery via the relationship's name only
> doesn't seem to work.
> > Entity "SMReceipt" has a to-one relationship "shop" to the entity
> "SMShop". The first fetch performs a prefetch as expceted, the second fetch
> performs no prefetching.
> > ----------------------------------
> > FETCH 1 (working)
> > ----------------------------------
> > SelectQuery<DataRow> q = SelectQuery.dataRowQuery( SMReceipt.class );
> > q.addPrefetch( SMReceipt.SHOP.joint() );
> > List<DataRow> list = objectContext.select( q );
> > ----------------------------------
> > GENERATED SQL
> > ----------------------------------
> > SELECT t0.creation_date, t0.date, t0.modification_date, t0.shop_id,
> t0.storage_number, t0.text, t0.user_id, t0.id, t1.CITY_ID, t1.LOCATION,
> t1.NAME, t1.CHAIN_ID, t1.SHOP_ID FROM strimillinn.fd_receipt t0 LEFT JOIN
> strimillinn.fd_shop t1 ON (t0.shop_id = t1.SHOP_ID)
> > ----------------------------------
> > FETCH 2 (not working)
> > ----------------------------------
> > SelectQuery<DataRow> q = SelectQuery.dataRowQuery( SMReceipt.class );
> > q.addPrefetch( SMReceipt.SHOP.getName() );
> > List<DataRow> list = objectContext.select( q );
> > ----------------------------------
> > GENERATED SQL
> > ----------------------------------
> > SELECT t0.creation_date, t0.date, t0.modification_date, t0.shop_id,
> t0.storage_number, t0.text, t0.user_id, t0.id FROM strimillinn.fd_receipt
> t0
>
>
>
> --
> This message was sent by Atlassian JIRA
> (v6.3.4#6332)
>

Mime
  • Unnamed multipart/alternative (inline, None, 0 bytes)
View raw message