Fixes Issue 30528:Potential full c_orderline scan in M_Reservation_trg
authorAtul Gaware <atul.gaware@openbravo.com>
Mon, 10 Aug 2015 10:23:33 +0530
changeset 27092 1861f239c670
parent 27091 e9e4169a1f48
child 27093 b28798b52483
Fixes Issue 30528:Potential full c_orderline scan in M_Reservation_trg

Removed unwanted line in code which fully scans c_orderline.
src-db/database/model/triggers/M_RESERVATION_TRG.xml
--- a/src-db/database/model/triggers/M_RESERVATION_TRG.xml	Mon Aug 03 23:08:59 2015 +0530
+++ b/src-db/database/model/triggers/M_RESERVATION_TRG.xml	Mon Aug 10 10:23:33 2015 +0530
@@ -96,7 +96,6 @@
 				group by rs.m_locator_id, rs.m_attributesetinstance_id
       )
       LOOP
-      select count (*) into v_count from c_orderline;
 			  UPDATE m_storage_detail
 			  SET reservedqty = reservedqty + cur_reservationstock.reservedqty,
 			      allocatedqty = allocatedqty + cur_reservationstock.allocatedqty