Fixed
Details
Details
Assignee
Alex Zaytsev
Alex ZaytsevReporter
Stefan Landgraf
Stefan LandgrafLabels
Components
Fix versions
Affects versions
Priority
Who's Looking?
Open Who's Looking?
Created February 13, 2012 at 3:55 PM
Updated September 21, 2014 at 12:41 PM
Resolved June 4, 2012 at 8:00 PM
Fetch clause AFTER Select:
Linq<InvoiceItem>().Where(ii => ii.Invoice.ID == id).Select(ii => ii).Fetch(ii => ii.Product).ToList();
Leads to
select * from invoice_items invoiceite0_
inner join invoices invoice1_
on invoiceite0_.[invoice_id] = invoice1_.[invoice_id]
left outer join products product2_
on invoiceite0_.[product_id] = product2_.[product_id]
where invoice1_.[invoice_id] = 51361
-> Correct, although the join on invoices seems superfluous, as the filtering could happen on the foreign key of invoice_items.
Fetch clause BEFORE Select:
Linq<InvoiceItem>().Where(ii => ii.Invoice.ID == id).Fetch(ii => ii.Product).Select(ii => ii).ToList();
leads to
select * from invoice_items invoiceite0_ left outer join products product1_ on invoiceite0_.[product_id] = product1_.[product_id]
-> Where clause is missing!