explorer-backend icon indicating copy to clipboard operation
explorer-backend copied to clipboard

Solve queries bloating

Open oskin1 opened this issue 3 years ago • 0 comments

Currently affected query sets:

  • Assets

Error message: Tried to send an out-of-range integer as a 2-byte value: 63702

Example query: select distinct on (a.index, a.token_id, a.box_id) api_1 | a.token_id, api_1 | a.box_id, api_1 | a.header_id, api_1 | a.index, api_1 | a.value, api_1 | t.name, api_1 | t.decimals, api_1 | t.type api_1 | from node_assets a api_1 | left join tokens t on a.token_id = t.token_id api_1 | where a.box_id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ...

oskin1 avatar Oct 23 '21 10:10 oskin1