overdue fixes and improvements

Mahdi Yarirequested to merge
overdue-fixes-and-improvements into main

HafSQL v2.7.0

Breaking / changed values

  • comments.net_rshares is now the signed sum (was absolute). New abs_rshares column. Changed votes are no longer double counted.
  • delegations.vests and accounts.incoming_vests/outgoing_vests are now in VESTS (were raw ×1,000,000).
  • accounts.to_withdraw is now the total power down amount (was remaining), matching hived.
  • rc_delegations.rc is now numeric (was text).
  • Empty json_metadata in operation_account_update*_table is now NULL (was {}).
  • HAFSQL_* module flags removed. All syncs always run.

Now sourced from other HAF apps

  • RC delegations, proposal approvals, account reward balances, power down and proxy now come from balance_tracker / hafbe.

Fixes

  • Reblog permlinks, re-posted comments stuck as deleted, wiped account metadata and comment titles, weekly market candles, timestamp helpers in non-UTC sessions, slow get_balance(x, block) / balances_history.
  • Existing data is repaired automatically on upgrade (comment titles and the re-post repair may take several minutes).
Edited by Mahdi Yari

Merge request reports