orderBy with SUM return a wrong order if the type is BigInt.
Author: HuberTRoyCreated Apr 14, 2025Updated Apr 14, 2025
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.
Source: subquery/subql