hydra icon indicating copy to clipboard operation
hydra copied to clipboard

Can't sort the query result set by a valid worker_DESC property defined in the schema

Open singulart opened this issue 3 years ago • 0 comments

Steps to reproduce

Console: https://graphql-console.subsquid.io/?graphql_api=https://query.joystream.org/graphql

Execute query

query Payouts {
  rewardPaidEvents(orderBy: worker_DESC) {
    id
  }
}

Actual Result:

{
  "errors": [
    {
      "message": "column rewardpaidevent.undefined does not exist",
      "locations": [
        {
          "line": 2,
          "column": 3
        }
      ],
      "path": [
        "rewardPaidEvents"
      ],
      "extensions": {
        "code": "INTERNAL_SERVER_ERROR",
        "exception": {
          "message": "column rewardpaidevent.undefined does not exist",
          "length": 124,
          "name": "QueryFailedError",
          "severity": "ERROR",
          "code": "42703",
          "position": "152",
          "file": "parse_relation.c",
          "line": "3349",
          "routine": "errorMissingColumn",
          "query": "SELECT \"rewardpaidevent\".\"id\" AS \"rewardpaidevent_id\" FROM \"reward_paid_event\" \"rewardpaidevent\" WHERE \"rewardpaidevent\".\"deleted_at\" IS NULL ORDER BY \"rewardpaidevent\".\"undefined\" DESC LIMIT 50",
          "parameters": []
        }
      }
    }
  ],
  "data": null
}

Expected result

The query is valid, so I expect some data in response.

singulart avatar Apr 13 '22 18:04 singulart