cayenne-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Lon Varscsak <lon.varsc...@gmail.com>
Subject Re: Another regression in 4.2
Date Tue, 14 May 2019 17:47:13 GMT
Thanks!

On Sat, May 11, 2019 at 5:04 AM Nikita Timofeev <ntimofeev@objectstyle.com>
wrote:

> Hi,
>
> Fixed this, see [1]. Thank you for another catch!
>
> [1] https://issues.apache.org/jira/browse/CAY-2578
>
> On Mon, May 6, 2019 at 11:28 PM Lon Varscsak <lon.varscsak@gmail.com>
> wrote:
> >
> > Hey all,
> >
> > I have a join from order_detail_sales to continuity_detail based on
> > order_number and order_line_number.  When fetching the to-one
> > getContinuityDetail I'm getting an error because the query generated is
> > swapping the keys:
> >
> > SELECT [t0].[intent_date], [t0].[line_end_date], [t0].[line_setup_date],
> > [t0].[next_ship_date], RTRIM([t0].[process_flag]), [t0].[reminder_date],
> > [t0].[reminder_days], [t0].[scheduled_shipments], [t0].[ship_frequency],
> > [t0].[order_number], [t0].[order_line_number] FROM
> > [production.dbo.continuity_detail] [t0] WHERE *( ( [t0].[order_number] =
> ?
> > ) AND ( [t0].[order_line_number] = ? ) ) [bind: 1:1, 2:57874832]*
> >
> > In reality "57874832" is the order_number and "1" is the
> order_line_number,
> > but the query generator has swapped them.  I've verified the joins in the
> > modeler (and 4.1 works).
> >
> > Thanks,
> >
> > Lon
>
>
>
> --
> Best regards,
> Nikita Timofeev
>

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