cardano-db-tool report rewards from git HEAD throws an exception #2036
Description
Comparing cardano-db-tool report rewards command on the latest release (13.6.0.5) vs git HEAD.
For 13.6.0.5:
$ PGPASSFILE=mainnet-db/pgpass bin/cardano-db-tool-13.6.0.5 report rewards epoch --epoch 590 \
--stake-address stake1u8wqew7mlwj6zf3r4ja730wt5ed8c0vetecp65dqcpfalys6agsd7
epoch | stake_address | delegated | pool_id | ticker | reward | RoS (%pa)
-------+-------------------------------------------------------------+----------------+-------- +--------+--------------+-----------
590 | stake1u8wqew7mlwj6zf3r4ja730wt5ed8c0vetecp65dqcpfalys6agsd7 | 1135.220961 | 1974 | RSTK | 0.392773 | 2.527
whereas for git HEAD:
$ PGPASSFILE=mainnet-db/pgpass bin/cardano-db-tool-HEAD report rewards epoch --epoch 590 \
--stake-address stake1u8wqew7mlwj6zf3r4ja730wt5ed8c0vetecp65dqcpfalys6agsd7
cardano-db-tool-HEAD: Uncaught exception cardano-db-13.6.0.5-inplace:Cardano.Db.Error.DbSessionError:
DbSessionError {dbSessionErrCallStack = DbCallStack {dbCsFncName = "unknown", dbCsModule = "", dbCsFile = "", dbCsLine = 0, dbCsCallChain = []}, dbSessionErrMsg = "ResultError (ServerError \"42703\" \"column es.addr_id does not exist\" Nothing Nothing (Just 163))\n QueryError \"SELECT es.addr_id, ep.end_time, es.amount, es.pool_id FROM epoch ep INNER JOIN epoch_state es ON ep.no = es.epoch_no INNER JOIN stake_address saddr ON saddr.id = es.addr_id WHERE saddr.view = $1 AND es.epoch_no <= $2 ORDER BY es.epoch_no DESC LIMIT 1\" [\"\\\"stake1u8wqew7mlwj6zf3r4ja730wt5ed8c0vetecp65dqcpfalys6agsd7\\\"\",\"590\"]"}
HasCallStack backtrace:
throwIO, called at src/Cardano/Prelude/Base.hs:245:22 in cardano-prelude-0.2.1.0-99923604ce11e0b023ca384ce41acac4d63130d7c98920d08a811ddcb328182a:Cardano.Prelude.Base