Thanks! On Sat, May 11, 2019 at 5:04 AM Nikita Timofeev <ntimof...@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.varsc...@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 >
