Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Solve queries bloating #156

Open
oskin1 opened this issue Oct 23, 2021 · 0 comments
Open

Solve queries bloating #156

oskin1 opened this issue Oct 23, 2021 · 0 comments
Labels
A-backend Affects whole backend area (most broad) C-bug Bugfix P1-high High priority

Comments

@oskin1
Copy link
Member

oskin1 commented Oct 23, 2021

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 oskin1 added A-backend Affects whole backend area (most broad) C-bug Bugfix P1-high High priority labels Oct 23, 2021
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
A-backend Affects whole backend area (most broad) C-bug Bugfix P1-high High priority
Projects
None yet
Development

No branches or pull requests

1 participant