pingcap / pingcap/tidb

GROUP BY expr ASC|DESC has only noop implementation in tidb now

Open
#40,859 0 comments 0 reactions 0 assignees View on GitHub
type/enhancement
Dominant language
Go
Stars
40.5k
Forks
6.2k
PR merge metrics
PR metrics pending

Description

## Enhancement

```
SELECT *, MAX(id) mid FROM `users` GROUP BY user_id DESC
```

will show
```
[42000][1235] function GROUP BY expr ASC|DESC has only noop implementation in tidb now, use tidb_enable_noop_functions to enable these functions
```

But
```
SELECT *, MAX(id) mid FROM `users` GROUP BY user_id order by user_id DESC
```
is OK

so tidb could implement the short syntax

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.