Bug Report: Incorrect Swap Amount

FlipsideCrypto / terra-models

Data models for the Terra blockchain, originally built by the MetricsDAO community.

https://flipsidecrypto.github.io/terra-models/

MIT License

0 stars 5 forks source link

Bug Report: Incorrect Swap Amount #79

Closed forgxyz closed 1 year ago

forgxyz commented 1 year ago

Swap amount in Luna in terra.core.ez_swaps table is incorrect on '2023-01-15' you can compare values on https://finder.terra.money/ and in terra.core.ez_swaps table

SELECT TX_ID, (FROM_AMOUNT)/1E6 AS AMOUNT_IN_LUNA
  FROM terra.core.ez_swaps
  WHERE FROM_CURRENCY = 'uluna' AND TO_CURRENCY!= 'uluna' AND TX_SUCCEEDED = TRUE AND BLOCK_TIMESTAMP::DATE = '2023-01-15'
  ORDER BY FROM_AMOUNT DESC LIMIT 1000

amasucci13 commented 1 year ago

A Discord user (data-ticket-0733) reports that the to/from_amounts are incorrect for execute_swap_operations transactions, same tx type as above.

Example txs:

'F6BA9AD121E732F3A59A444837DB96F21916030C35C3720B2D9B5E75D9C7D6D0'
- Missing swap actions, to/from_amounts incorrect.

2. 'C6B055E23786F8AD468A5F9467BA1142987A1C56FD42E68A65132A6E740BD2D2'

to_currency is wrong

antonyip commented 1 year ago

ez_swaps's table need to be reworked due to astroport executing multistep transactions now

rainean commented 1 year ago

Taking a look at this issue