Skip to content

orderBy with SUM return a wrong order if the type is BigInt. #2740

@HuberTRoy

Description

@HuberTRoy

https://explorer.subquery.network/subquery/subquery/subquery-mainnet

{
  projects(orderBy: DEPLOYMENT_BOOSTER_SUMMARIES_SUM_TOTAL_AMOUNT_DESC) {
    nodes {
      id
      deploymentBoosterSummaries {
        aggregates {
          sum {
            totalAmount
          }
        }
      }
    }
  }
}

It compare with string rule:

'800' > '7000'

The type of totalAmount is BitInt in schema.

Metadata

Metadata

Assignees

No one assigned

    Labels

    No labels
    No labels

    Type

    No type
    No fields configured for issues without a type.

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions