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
