DF webapp reports a 10x volume; is it legit or is there a df-py issue?

[trentmc]

Background

From this slack thread:

Norbert: Looks like the current round's DCV just did a 10x, probably an issue? 👀

(Norbert cont'd): the active rewards amount distributed is similar to the amounts distributed in the last weeks, also no change in APY so It's probably just a df-sql issue

Trent: Berkay discovered a bug in distributions of the last few rounds. He fixed it for today's distribution.

Norbert: that was related to querying the user allocations, shouldn't affect DCV. But could affect user rewards because now users that were not taken in consideration in the last rounds are now accounted and due to this other users got less rewards( one user on discords complains about this, his allocations didn't change but got half of the last weeks rewards )

Trent: Thanks for the clarification.

Norbert: This two things have lead to a strange combination as the user on Discord pointed out, 10x DCV increase but less rewards compared to previous week. Might be good to share these bugs/fixes with users in the future so they are aware why their rewards unexpectedly change.

Trent: Good point. I've added that as a TODO to the issue. Could you share the link to the discord discussion here please?

Norbert: https://discord.com/channels/612953348487905282/993954438790258879/1197327111090884740

Trent: Thanks, added link to the issue.

TODOs

• Write a unit test to try to capture the issue, or at least clarify where the Q's are
• If it is an issue, fix it. When done, unit test should pass
• Get back to the discord user on the result, ie "the problem & the fix" or "it's ok, here's why __". See context & link in "background" section

[trizin]

This was due to miscalculation of start and end blocks for Sapphire, #793 fixes it.