collectionEntity orderby Id_desc

[roiLeo]

Describe the bug Order By id desc has a weird behavior on collectionEntity

To Reproduce

• https://squid.subsquid.io/stick/graphql

  query MyQuery {
  collectionEntities(limit: 50, where: {issuer_eq: "DT7kRjGFvRKxGSx5CPUCA1pazj6gzJ6Db11xmkX4yYSNK7m"}, orderBy: id_DESC) {
  id
  }
  }

• show 97 first while this account has created 101, 107 etc..

Expected behavior 107 > 101 > 97

Screenshots

Additional context I like sports

[vikiival]

I think it's the behaviour of psql we can do a resolver for that and map ids as numbers

[roiLeo]

I think it's the behaviour of psql we can do a resolver for that and map ids as numbers

Nah.. IMO it's because id are string instead of numbers, could be doable if we cast this column or change type to integer

[vikiival]

So it would mean that bsx and ah* will have numbers where rmrk and evm string?

[roiLeo]

So it would mean that bsx and ah* will have numbers where rmrk and evm string?

Oh... nvm, I've forgot we were talking about collectionId.

That doesn't mean we can't type id to integer only for bsx & ah*, best would be to have same type as the one declared in pallet.

[roiLeo]

I just thought we could solve this problem by sorting by block number, and we'll get the expected result.

[vikiival]

and guess since blockNumber is bigint it behaves like string in sortig?