Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Support ORDER BY within GROUP_CONCAT #806

Open
tbantle22 opened this issue Oct 3, 2024 · 1 comment
Open

Support ORDER BY within GROUP_CONCAT #806

tbantle22 opened this issue Oct 3, 2024 · 1 comment
Labels
enhancement New feature or request workbench Issue related to dolt-workbench

Comments

@tbantle22
Copy link
Contributor

This is used by the dolt workbench

Example query:

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

@tbantle22 tbantle22 added enhancement New feature or request workbench Issue related to dolt-workbench labels Oct 3, 2024
@tbantle22
Copy link
Contributor Author

Related: #793

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
enhancement New feature or request workbench Issue related to dolt-workbench
Projects
None yet
Development

No branches or pull requests

1 participant