Fixes Issue 30516:Potential full c_orderline scan in M_Reservation_trg
authorAtul Gaware <atul.gaware@openbravo.com>
Sun, 09 Aug 2015 09:01:40 +0530
changeset 27286 17b020a23cb9
parent 27285 02b35371304f
child 27287 c3118a9e5203
Fixes Issue 30516: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	Fri Aug 07 17:02:11 2015 +0530
+++ b/src-db/database/model/triggers/M_RESERVATION_TRG.xml	Sun Aug 09 09:01:40 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