cayenne-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Nikita Timofeev <ntimof...@objectstyle.com>
Subject Re: Another regression in 4.2
Date Sat, 11 May 2019 12:04:00 GMT
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
View raw message