aboutsummaryrefslogtreecommitdiff
path: root/src/exchangedb/exchange_do_batch4_reserves_in_insert.sql
diff options
context:
space:
mode:
Diffstat (limited to 'src/exchangedb/exchange_do_batch4_reserves_in_insert.sql')
-rw-r--r--src/exchangedb/exchange_do_batch4_reserves_in_insert.sql10
1 files changed, 2 insertions, 8 deletions
diff --git a/src/exchangedb/exchange_do_batch4_reserves_in_insert.sql b/src/exchangedb/exchange_do_batch4_reserves_in_insert.sql
index bf3b2eaa..edbbe100 100644
--- a/src/exchangedb/exchange_do_batch4_reserves_in_insert.sql
+++ b/src/exchangedb/exchange_do_batch4_reserves_in_insert.sql
@@ -150,27 +150,24 @@ 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;
END IF;
+ k=k+1;
END LOOP;
CLOSE curs_reserve_exist;
IF out_reserve_found
@@ -236,24 +233,21 @@ BEGIN
IF in_reserve_pub = i.reserve_pub
THEN
transaction_duplicate = TRUE;
- k=k+1;
END IF;
IF in2_reserve_pub = i.reserve_pub
THEN
transaction_duplicate2 = TRUE;
- k=k+1;
END IF;
IF in3_reserve_pub = i.reserve_pub
THEN
transaction_duplicate3 = TRUE;
- k=k+1;
END IF;
IF in4_reserve_pub = i.reserve_pub
THEN
transaction_duplicate4 = TRUE;
- k=k+1;
END IF;
END IF;
+ k=k+1;
END LOOP;
CLOSE curs_transaction_exist;