commit 2858649b80ef74dfd1687d59a7ba6d4feeeeb57f
parent b5b799c2dcac424fbc6a9ac80268978bb826ff66
Author: Christian Grothoff <christian@grothoff.org>
Date: Fri, 26 Dec 2025 14:31:42 +0100
-fix typos
Diffstat:
1 file changed, 4 insertions(+), 4 deletions(-)
diff --git a/src/backenddb/pg_statistics_helpers.sql b/src/backenddb/pg_statistics_helpers.sql
@@ -738,7 +738,7 @@ BEGIN
THEN 1
ELSE 0
END,
- cumulative_frac = cumulative_frac + my_delta_value
+ cumulative_frac = cumulative_frac + my_delta_frac
- CASE
WHEN cumulative_frac + my_delta_frac > 100000000
THEN 100000000
@@ -988,7 +988,7 @@ BEGIN
AND merchant_serial=my_instance
AND delta_curr = my_currency
AND slot >= my_time - max_slot
- AND slot < my_time - max_slot;
+ AND slot < my_time - min_slot;
-- we only proceed if we had more then one match (optimization)
IF FOUND AND my_sum.matches > 1
THEN
@@ -1002,11 +1002,11 @@ BEGIN
AND merchant_serial=my_instance
AND delta_curr = my_currency
AND slot >= my_time - max_slot
- AND slot < my_time - max_slot
+ AND slot < my_time - min_slot
AND aevent_serial_id > my_sum.rep_serial_id;
-- Now update the representative to the sum
UPDATE merchant_statistic_amount_event SET
- delta_value = my_total_value
+ delta_value = my_total_val
,delta_frac = my_total_frac
WHERE imeta_serial_id = my_meta
AND merchant_serial = my_instance