diff options
author | Joseph <Joseph.xu@efrei.net> | 2023-01-04 07:31:08 -0500 |
---|---|---|
committer | Joseph <Joseph.xu@efrei.net> | 2023-01-04 07:31:08 -0500 |
commit | 6457ee56dfb148773167e45fb408176e7370f817 (patch) | |
tree | 56e61f6fe0cd3d743cb267365a0c737eacabcc07 /src/exchangedb/exchange_do_batch4_reserves_in_insert.sql | |
parent | 31fefec5ddc49ef9b2aab677084d1cf4ab76bba6 (diff) | |
download | exchange-6457ee56dfb148773167e45fb408176e7370f817.tar.xz |
corrections applied to batch_test
Diffstat (limited to 'src/exchangedb/exchange_do_batch4_reserves_in_insert.sql')
-rw-r--r-- | src/exchangedb/exchange_do_batch4_reserves_in_insert.sql | 27 |
1 files changed, 18 insertions, 9 deletions
diff --git a/src/exchangedb/exchange_do_batch4_reserves_in_insert.sql b/src/exchangedb/exchange_do_batch4_reserves_in_insert.sql index 5519da157..e2ab133bd 100644 --- a/src/exchangedb/exchange_do_batch4_reserves_in_insert.sql +++ b/src/exchangedb/exchange_do_batch4_reserves_in_insert.sql @@ -81,10 +81,10 @@ DECLARE BEGIN --INITIALIZATION - transaction_duplicate=FALSE; - transaction_duplicate2=FALSE; - transaction_duplicate3=FALSE; - transaction_duplicate4=FALSE; + transaction_duplicate=TRUE; + transaction_duplicate2=TRUE; + transaction_duplicate3=TRUE; + transaction_duplicate4=TRUE; out_reserve_found = TRUE; out_reserve_found2 = TRUE; out_reserve_found3 = TRUE; @@ -232,25 +232,34 @@ BEGIN THEN IF in_reserve_pub = i.reserve_pub THEN - transaction_duplicate = TRUE; + transaction_duplicate = FALSE; END IF; IF in2_reserve_pub = i.reserve_pub THEN - transaction_duplicate2 = TRUE; + transaction_duplicate2 = FALSE; END IF; IF in3_reserve_pub = i.reserve_pub THEN - transaction_duplicate3 = TRUE; + transaction_duplicate3 = FALSE; END IF; IF in4_reserve_pub = i.reserve_pub THEN - transaction_duplicate4 = TRUE; + transaction_duplicate4 = FALSE; END IF; END IF; k=k+1; END LOOP; - CLOSE curs_transaction_exist; +/* IF transaction_duplicate + OR transaction_duplicate2 + OR transaction_duplicate3 + OR transaction_duplicate4 + THEN + RAISE EXCEPTION 'Reserve did not exist, but INSERT into reserves_in gave conflict'; + CLOSE curs_transaction_exist; + RETURN; + END IF;*/ + CLOSE curs_transaction_exist; RETURN; END $$; |