hasura / ndc-jvm-mono

0 stars 2 forks source link

Issue while trying to query aggregate in MySQL connector #18

Open zameel7 opened 3 weeks ago

zameel7 commented 3 weeks ago

The graphql query that I had used:

query MyQuery {
  completionBlockcompletionAggregate(agg: {limit: 10}) {
    courseKey {
      agg_count
    }
  }
}

The sql that was generated:

select json_object('rows', (
  select json_arrayagg(json_object())
  from (
    select * from completion_blockcompletion
    limit 10
    as completion_blockcompletion
)

Seems like there is some issue in the json_object and json_arrayagg usage