Trino dialect supports combine '*' in select list with GROUP BY

[LZGH]

Feature request

Is your feature request related to a problem? Please describe. Trino support combine '*' in select list with GROUP BY. StarRocks will report an error when execute 'select * from fe_locks group by lock_type,lock_object'

Describe the solution you'd like

Supports the same syntax as trino

Describe alternatives you've considered

Additional context

[jaogoy]

What's the behavior of other columns except the GROUP BY columns?

[LZGH]

What's the behavior of other columns except the GROUP BY columns?

The sql I gave is not very suitable.GROUP BY will contains all fields. If the table has three fields. 'select * from table group by 1,2,3' can be executed in trino

[LZGH]

@kateshaowanjou or @wangsimo0 Can you help add this feature to trino compatible task #40894 ?

[github-actions[bot]]

We have marked this issue as stale because it has been inactive for 6 months. If this issue is still relevant, removing the stale label or adding a comment will keep it active. Otherwise, we'll close it in 10 days to keep the issue queue tidy. Thank you for your contribution to StarRocks!