dolthub / dolthub/dolthub-issues

Rows come back in sorted order from the SQL API

Open
#497 0 comments 0 reactions 1 assignee Claimed by @liuliu-dev View on GitHub
dolthub api enhancement
Dominant language
No language data
Stars
5
Forks
0
PR merge metrics
No merged PRs in 30d

Description

Rows are returned from the API in a random order, not the expected SQL order.

Here are few successive responses to a `select * from table` query:
```json
{"query_execution_status":"Success","query_execution_message":"","repository_owner":"timsehn","repository_name":"google_sheets","commit_ref":"main","sql_query":"select * from test","schema":[{"columnName":"id","columnType":"int"},{"columnName":"words","columnType":"varchar(255)"}],"rows":[{"id":"0","words":"Tim is not awesome"},{"id":"4","words":"He is a shitty coder"},{"id":"5","words":"I swear he cannot fo this"},{"id":"6","words":"He is a bum"},{"id":"7","words":"I think he can't"},{"id":"2","words":"Tim can't make this work"},{"id":"1","words":"Tim is the worst"},{"id":"3","words":"Be fair to him"}]}
```

```json
{"query_execution_status":"Success","query_execution_message":"","repository_owner":"timsehn","repository_name":"google_sheets","commit_ref":"main","sql_query":"select * from test","schema":[{"columnName":"id","columnType":"int"},{"columnName":"words","columnType":"varchar(255)"}],"rows":[{"id":"0","words":"Tim is not awesome"},{"id":"1","words":"Tim is the worst"},{"id":"5","words":"I swear he cannot fo this"},{"id":"6","words":"He is a bum"},{"id":"7","words":"I think he can't"},{"id":"2","words":"Tim can't make this work"},{"id":"4","words":"He is a shitty coder"},{"id":"3","words":"Be fair to him"}]}
```

```json
{"query_execution_status":"Success","query_execution_message":"","repository_owner":"timsehn","repository_name":"google_sheets","commit_ref":"main","sql_query":"select * from test","schema":[{"columnName":"id","columnType":"int"},{"columnName":"words","columnType":"varchar(255)"}],"rows":[{"id":"1","words":"Tim is the worst"},{"id":"0","words":"Tim is not awesome"},{"id":"4","words":"He is a shitty coder"},{"id":"6","words":"He is a bum"},{"id":"3","words":"Be fair to him"},{"id":"7","words":"I think he can't"},{"id":"2","words":"Tim can't make this work"},{"id":"5","words":"I swear he cannot fo this"}]}
```

I would expect the rows to be returned consistently in order of id like they would come out of a SQL client.

Contributor guide

No contributing guide indexed for this repository

Assessment

This issue has not been assessed yet.

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.