Stake address hashes not encoded for presentation

[oneEdoubleD]

{ os:
   { arch: 'x64',
     cpus: { count: 24, model: 'AMD Ryzen 9 3900X 12-Core Processor' },
     release: '5.4.0-42-generic',
     totalMem: 16778514432,
     type: 'Linux' },
  version: '3.1.0' }

stake_address.hash example \\xe0ad216e3dfe704c162d0dbc96243461624b4965dd1e0765ad47b0e4aa

[SebastienGllmt]

I assume this is a db-sync issue and not a cardano-graphql issue. Maybe this is a similar ticket? #213

[dcoutts]

This was changed in db-sync for payment addresses but probably not for stake addresses.

commit a6132abc5dee1dd77b541980014d4f490559c097
Author: Erik de Castro Lopo <erikd@mega-nerd.com>
Date:   Mon Jul 20 17:26:06 2020 +1000

    db-sync: Render addresses by era

    Byron addresses (even ones within Shelley transactions) are rendered using
    Base58 and Shelley addresses are rendered as Bech32. Use 'cardano-api' to
    do this.

File a ticket on db-sync for stake addresses specifically.

[erikd]

I think the solution here is to store both the raw serialized version and the Bech32 version (all stake addresses are Shelley era and hence should be Bech32 encoded).

[erikd]

@oneEdoubleD :

cexplorer=# select * from stake_address limit 3 ;
 id |                           hash_raw                           |                            view                             | registered_tx_id 
----+--------------------------------------------------------------+-------------------------------------------------------------+------------------
  1 | \xe10e5b086df87a2a0c5c398b41d413f84176c527da5e5cb641f4598844 | stake1uy89kzrdlpaz5rzu8x95r4qnlpqhd3f8mf09edjp73vcs3qhktrtm |          2415511
  2 | \xe18d0ea87fb33ca385998da1eb4fd8d3347ff3a86c90eebf796934c096 | stake1uxxsa2rlkv728pve3ks7kn7c6v68luagdjgwa0medy6vp9suv96q8 |          2415591
  3 | \xe14f39feccb595162d892abd1e03d80de8e76b8a2015139430e032b2be | stake1u98nnlkvkk23vtvf9273uq7cph5ww6u2yq2389psuqet90sv4xv9v |          2415594
(3 rows)