dolthub / dolthub/doltgresql

Support `ORDER BY` within `GROUP_CONCAT`

Open
#806 1 comment 0 reactions 0 assignees View on GitHub
enhancement workbench
Dominant language
Go
Stars
2.1k
Forks
73
Avg merge
1d 10h
Merged PRs (30d)
129

Description

This is used by the dolt workbench

Example query:
```sql
SELECT
table_name, index_name, comment, non_unique, GROUP_CONCAT(column_name ORDER BY seq_in_index) AS COLUMNS
FROM information_schema.statistics
WHERE table_catalog='doltgres/main' AND table_schema='public' AND table_name='test' AND index_name!='PRIMARY'
GROUP BY index_name;
```

Skipped test [here](https://github.com/dolthub/doltgresql/blob/main/testing/postgres-client-tests/node/workbenchTests/table.js#L147)

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.