Skip to content

Fixes related to time in database_api and some more

Andrzej Lisak requested to merge database_api_by_time_order into develop

curator_payout_value/total_payout_value now have 0.000 HBD default to always have asset in value - ultimately they should be changed to numeric columns

removed columns that we don't intend to update as they would hold irrelevant data: children_abs_rshares, reward_weight; also removed from queries

hive_posts_view no longer has parent_permlink - replaced with parent_permlink_or_category as that's what was in original comment data and what is expected in queries and results

fixed order by time in list_comments_by_last_update, list_comments_by_author_last_update (newer first)

fixed payout update date - each operation that is part of payout has its own date as (at least some) can be from different blocks (fixes caases where last_payout was broken)

fixed author_rewards - it is a sum of partial rewards for the comment (unfortunately hived would need to be changed to make it proper final value instead of immediate one that is now placed in comment_reward_operation)

when payout operations are processed they no longer incorrectly overwrite each other's data

1969 year in date recognized as timestamp::max and replaced by infinity (and the other way when producing results) - fixes corner case of time ordering in by_cashout_time (posts after final payout are last as they should, now first)

commented out checks in run_tests.sh as they fail when address contains - like in hive-3.pl.syncad.com (@dkedzierski)

Merge request reports