fixing some bugs

1 files changed, 2 insertions, 18 deletions

diff --git a/src/exchangedb/exchange_do_batch8_reserves_in_insert.sql b/src/exchangedb/exchange_do_batch8_reserves_in_insert.sql
index ab11e380..fc735add 100644
--- a/src/exchangedb/exchange_do_batch8_reserves_in_insert.sql
+++ b/src/exchangedb/exchange_do_batch8_reserves_in_insert.sql
@@ -248,52 +248,44 @@ BEGIN
       THEN
          out_reserve_found = FALSE;
          ruuid = i.reserve_uuid;
-         k = k+1;
       END IF;
       IF in2_reserve_pub = i.reserve_pub
       THEN
           out_reserve_found2 = FALSE;
           ruuid2 = i.reserve_uuid;
-          k=k+1;
       END IF;
       IF in3_reserve_pub = i.reserve_pub
       THEN
           out_reserve_found3 = FALSE;
           ruuid3 = i.reserve_uuid;
-          k=k+1;
       END IF;
       IF in4_reserve_pub = i.reserve_pub
       THEN
           out_reserve_found4 = FALSE;
           ruuid4 = i.reserve_uuid;
-          k=k+1;
       END IF;
       IF in5_reserve_pub = i.reserve_pub
       THEN
          out_reserve_found5 = FALSE;
          ruuid5 = i.reserve_uuid;
-         k=k+1;
       END IF;
       IF in6_reserve_pub = i.reserve_pub
       THEN
           out_reserve_found6 = FALSE;
           ruuid6 = i.reserve_uuid;
-          k=k+1;
       END IF;
       IF in7_reserve_pub = i.reserve_pub
       THEN
           out_reserve_found7 = FALSE;
           ruuid7 = i.reserve_uuid;
-          k=k+1;
       END IF;
       IF in8_reserve_pub = i.reserve_pub
       THEN
           out_reserve_found8 = FALSE;
           ruuid8 = i.reserve_uuid;
-          k=k+1;
       END IF;
     END IF;
-
+  k=k+1;
   END LOOP;
 
   CLOSE curs_reserve_existed;
@@ -397,46 +389,38 @@ BEGIN
       IF in_reserve_pub = r.reserve_pub
       THEN
          transaction_duplicate = TRUE;
-         k=k+1;
       END IF;
       IF in2_reserve_pub = r.reserve_pub
       THEN
          transaction_duplicate2 = TRUE;
-         k=k+1;
       END IF;
       IF in3_reserve_pub = r.reserve_pub
       THEN
          transaction_duplicate3 = TRUE;
-         k=k+1;
       END IF;
       IF in4_reserve_pub = r.reserve_pub
       THEN
          transaction_duplicate4 = TRUE;
-         k=k+1;
       END IF;
       IF in5_reserve_pub = r.reserve_pub
       THEN
          transaction_duplicate5 = TRUE;
-         k=k+1;
       END IF;
       IF in6_reserve_pub = r.reserve_pub
       THEN
          transaction_duplicate6 = TRUE;
-         k=k+1;
       END IF;
       IF in7_reserve_pub = r.reserve_pub
       THEN
          transaction_duplicate7 = TRUE;
-         k=k+1;
       END IF;
       IF in8_reserve_pub = r.reserve_pub
       THEN
          transaction_duplicate8 = TRUE;
-         k=k+1;
       END IF;
 
     END IF;
-
+  k=k+1;
   END LOOP;
 
   CLOSE curs_transaction_existed;