Add block number to contract log

[xin-hedera]

Problem

Due to citus limit on lateral subquery with limit clause support, all contract logs related REST API fail on the underlying SQL statement which joins on a lateral subquery with limit to find the corresponding block number and block hash.

We can instead add a block number column to contract log and then change the query to inner join record_file on block number.

Solution

• db: add column block_number bigint not null to table contract_log and backfill data
• parser
  • Add recordFileIndex to RecordItem and populate it in record file readers
  • Add blockNumber to ContractLog and set it with the value from the RecordItem
• rest: change to inner join record_file

Alternatives

No response

[xin-hedera]

was able to rewrite the contract logs SQL query to be citus compatible after some research in PR #4749. However, will leave this ticket open just in case it may still be needed for potential performance improvement. Will close once we verify performance with existing query looks good.