output of group by

[fdncred]

Describe the bug
I expected this query to produce 1 row. The

❯ ^gitql -q 'select author_name, count(author_name) AS auth_count from commits group by author_name order by count(author_name)'
╭──────────────────┬────────────╮
│ author_name      ┆ auth_count │
╞══════════════════╪════════════╡
│ Darren Schroeder ┆ 6          │
├╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌┼╌╌╌╌╌╌╌╌╌╌╌╌┤
│ Darren Schroeder ┆ 6          │
├╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌┼╌╌╌╌╌╌╌╌╌╌╌╌┤
│ Darren Schroeder ┆ 6          │
├╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌┼╌╌╌╌╌╌╌╌╌╌╌╌┤
│ Darren Schroeder ┆ 6          │
├╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌┼╌╌╌╌╌╌╌╌╌╌╌╌┤
│ Darren Schroeder ┆ 6          │
├╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌┼╌╌╌╌╌╌╌╌╌╌╌╌┤
│ Darren Schroeder ┆ 6          │
╰──────────────────┴────────────╯

There are indeed 6 commits, but shouldn't group by only show the aggregate of 1?

❯ ^gitql -q 'select author_name from commits'
╭──────────────────╮
│ author_name      │
╞══════════════════╡
│ Darren Schroeder │
├╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌┤
│ Darren Schroeder │
├╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌┤
│ Darren Schroeder │
├╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌┤
│ Darren Schroeder │
├╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌┤
│ Darren Schroeder │
├╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌┤
│ Darren Schroeder │
╰──────────────────╯

GQL (please complete the following information):
❯ ^gitql --version
GitQL version 0.27.0

[AmrDeveloper]

Thank you for reporting @fdncred,

This is important to handled

[AmrDeveloper]

It fixed now, you can run the query from issue description and get good result,

Thanks for reporting, i will release it next version

[fdncred]

Thanks. I'm trying to integrate into a nushell plugin and was wondering why my code didn't work. Then I tried your cli and found out the results were the same. 🤣 Thanks for working on this. I'll try and test it in the next day or so.

[AmrDeveloper]

Thats cool idea to integrate it with nushell plugin,

[fdncred]

prototype

[AmrDeveloper]

prototype

Cool 😅

[AmrDeveloper]

I think we can close this

[fdncred]

Thanks for your help! I'm really enjoying GQL!

[AmrDeveloper]

Thanks for your help! I'm really enjoying GQL!

Thank you, i think it can be even better when implementing line editor, sub query, user defined functions, some optimisations and tree rewriting, but step by step :D