diff options
| author | Joseph <Joseph.xu@efrei.net> | 2023-01-05 09:22:16 -0500 |
|---|---|---|
| committer | Joseph <Joseph.xu@efrei.net> | 2023-01-05 09:22:16 -0500 |
| commit | 043c46c59d62abcafef5c37fb97c66995e6b3859 (patch) | |
| tree | f121671c6db0f942c7dbf6e5da273e04282bf1b4 /src/exchangedb/exchange_do_batch8_reserves_in_insert.sql | |
| parent | d805c54052a4684a7312e05186169fb66c35668b (diff) | |
| download | exchange-043c46c59d62abcafef5c37fb97c66995e6b3859.tar.xz | |
modifications applied to batch test...
Diffstat (limited to 'src/exchangedb/exchange_do_batch8_reserves_in_insert.sql')
| -rw-r--r-- | src/exchangedb/exchange_do_batch8_reserves_in_insert.sql | 109 |
1 files changed, 94 insertions, 15 deletions
diff --git a/src/exchangedb/exchange_do_batch8_reserves_in_insert.sql b/src/exchangedb/exchange_do_batch8_reserves_in_insert.sql index 997a7b3e2..68b9c8fa5 100644 --- a/src/exchangedb/exchange_do_batch8_reserves_in_insert.sql +++ b/src/exchangedb/exchange_do_batch8_reserves_in_insert.sql @@ -245,43 +245,123 @@ BEGIN THEN IF in_reserve_pub = i.reserve_pub THEN - out_reserve_found = FALSE; ruuid = i.reserve_uuid; + IF in_reserve_pub + NOT IN (in2_reserve_pub + ,in3_reserve_pub + ,in4_reserve_pub + ,in5_reserve_pub + ,in6_reserve_pub + ,in7_reserve_pub + ,in8_reserve_pub) + THEN + out_reserve_found = FALSE; + END IF; END IF; IF in2_reserve_pub = i.reserve_pub THEN - out_reserve_found2 = FALSE; - ruuid2 = i.reserve_uuid; + ruuid2 = i.reserve_uuid; + IF in2_reserve_pub + NOT IN (in_reserve_pub + ,in3_reserve_pub + ,in4_reserve_pub + ,in5_reserve_pub + ,in6_reserve_pub + ,in7_reserve_pub + ,in8_reserve_pub) + THEN + out_reserve_found2 = FALSE; + END IF; END IF; IF in3_reserve_pub = i.reserve_pub THEN - out_reserve_found3 = FALSE; - ruuid3 = i.reserve_uuid; + ruuid3 = i.reserve_uuid; + IF in3_reserve_pub + NOT IN (in_reserve_pub + ,in2_reserve_pub + ,in4_reserve_pub + ,in5_reserve_pub + ,in6_reserve_pub + ,in7_reserve_pub + ,in8_reserve_pub) + THEN + out_reserve_found3 = FALSE; + END IF; END IF; IF in4_reserve_pub = i.reserve_pub THEN - out_reserve_found4 = FALSE; - ruuid4 = i.reserve_uuid; + ruuid4 = i.reserve_uuid; + IF in4_reserve_pub + NOT IN (in_reserve_pub + ,in2_reserve_pub + ,in3_reserve_pub + ,in5_reserve_pub + ,in6_reserve_pub + ,in7_reserve_pub + ,in8_reserve_pub) + THEN + out_reserve_found4 = FALSE; + END IF; END IF; IF in5_reserve_pub = i.reserve_pub THEN - out_reserve_found5 = FALSE; ruuid5 = i.reserve_uuid; + IF in5_reserve_pub + NOT IN (in_reserve_pub + ,in2_reserve_pub + ,in3_reserve_pub + ,in4_reserve_pub + ,in6_reserve_pub + ,in7_reserve_pub + ,in8_reserve_pub) + THEN + out_reserve_found5 = FALSE; + END IF; END IF; IF in6_reserve_pub = i.reserve_pub THEN - out_reserve_found6 = FALSE; - ruuid6 = i.reserve_uuid; + ruuid6 = i.reserve_uuid; + IF in6_reserve_pub + NOT IN (in_reserve_pub + ,in2_reserve_pub + ,in3_reserve_pub + ,in4_reserve_pub + ,in5_reserve_pub + ,in7_reserve_pub + ,in8_reserve_pub) + THEN + out_reserve_found6 = FALSE; + END IF; END IF; IF in7_reserve_pub = i.reserve_pub THEN - out_reserve_found7 = FALSE; - ruuid7 = i.reserve_uuid; + ruuid7 = i.reserve_uuid; + IF in7_reserve_pub + NOT IN (in_reserve_pub + ,in2_reserve_pub + ,in3_reserve_pub + ,in4_reserve_pub + ,in5_reserve_pub + ,in6_reserve_pub + ,in8_reserve_pub) + THEN + out_reserve_found7 = FALSE; + END IF; END IF; IF in8_reserve_pub = i.reserve_pub THEN - out_reserve_found8 = FALSE; - ruuid8 = i.reserve_uuid; + ruuid8 = i.reserve_uuid; + IF in8_reserve_pub + NOT IN (in_reserve_pub + ,in2_reserve_pub + ,in3_reserve_pub + ,in4_reserve_pub + ,in5_reserve_pub + ,in6_reserve_pub + ,in7_reserve_pub) + THEN + out_reserve_found8 = FALSE; + END IF; END IF; END IF; k=k+1; @@ -369,7 +449,6 @@ BEGIN RETURNING reserve_pub) SELECT * FROM reserve_in_changes; - WHILE k < 8 LOOP FETCH FROM curs_transaction_existed INTO r; IF FOUND |