mirror of
https://github.com/luxfi/graph.git
synced 2026-09-24 00:26:07 +00:00
zeekayandHanzo Dev
d3e86b3eb8
v1.2.47 replaced one window sum with the day series added up. Those rows are folded from the same window, so their sum is that window again — a change that read correctly and moved nothing. Live proof: the day series summed to exactly the pass's own figure, and its trade counts to exactly the window size. The value of a trade has always lived inside the swap's JSON document, where SQL cannot reach it — this driver's amalgamation carries no JSON1, so json_extract is not an escape either. So amountUSD joins timestamp and pool as a column: the queryable projection of the document, written by both paths that touch a swap, summed by one reader. What the protocol has traded is now one scan of one column and covers every trade ever indexed. A database that predates the column gets it on the start that introduces it, filled from the rows themselves. Empty, it would have zeroed every trade older than the current window — the fix erasing the number it exists to correct — so that is the case the test pins, and the ALTER failing is how a later start knows the fill is done. txCount is left where it is. It counts every interaction, mints and burns among them, which is a different question from what has traded. Co-authored-by: Hanzo Dev <[email protected]>