hasura / hasura/graphql-engine

MSSQL Nested Object Sorting fails

Open
#9,841 7 comments 0 reactions 0 assignees View on GitHub
k/bug t/native-dbs
Dominant language
TypeScript
Stars
32.1k
Forks
3k
PR merge metrics
PR metrics pending

Description

### Version Information

Server Version: 2.32.0
CLI Version (for CLI related issue):

### Environment
Self Hosted (MSSQL)

### What is the current behaviour?
When using a order by clause with a nested object attribute, if we try to fetch the corresponding objects further nested element in response, it fails to build the right query

### What is the expected behaviour?

sorting and subsequent nested structures should work together
### How to reproduce the issue?

1.
create example object structure:
{
parent: {
id: parent_id,
child: {
id: child_id,
grand_child: {
id: grand_child_id
}
}
}
}

2.
try querying

parent(order_by: {child: {id: asc}}){
child {
grand_child {
id
}
}
}

it fails.

### Screenshots or Screencast

NA

### Please provide any traces or logs that could help here.

NA

### Any possible solutions/workarounds you're aware of?

None.

### Keywords

MSSQL
Nested Sorting

Contributor guide

Open the contributing guide

Assessment

This issue has not been assessed yet.

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.