tidb runtime error with max funtion

[dbsid]

Bug Report

Please answer these questions before submitting your issue. Thanks!

runs fine

SELECT repo, commit
FROM (
  SELECT repo, commit, COUNT(1) AS c
  FROM ci_data
  WHERE status="FAILURE"
  GROUP BY repo, commit, job, date(time)
) s

with max function time error:

SELECT repo, commit, MAX(c) max_cnt
FROM (
  SELECT repo, commit, COUNT(1) AS c
  FROM ci_data
  WHERE status="FAILURE"
  GROUP BY repo, commit, job, date(time)
) s

1. Minimal reproduce step (Required)

reproduced internal database

2. What did you expect to see? (Required)

no runtime error

3. What did you see instead (Required)

runtime error

4. What is your TiDB version? (Required)

master

<!-- Paste the output of SELECT tidb_version() -->

| Release Version: v4.0.0-beta.2-2487-g70f7884
Edition: Community
Git Commit Hash: 70f78847f463d9f1f4f6a8f329749762a71033ed
Git Branch: release-5.0-734084fa2bf2
UTC Build Time: 2021-05-10 14:50:14
GoVersion: go1.16
Race Enabled: false
TiKV Min Version: v3.0.0-60965b006877ca7234adaced7890d7b029ed1306
Check Table Before Drop: false |
+-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
1 row in set (0.03 sec)

[dbsid]

duplicate as #23844, closing

[ti-srebot]

Please edit this comment or add a new comment to complete the following information

Not a bug

1. Remove the 'type/bug' label
2. Add notes to indicate why it is not a bug

Duplicate bug

1. Add the 'type/duplicate' label
2. Add the link to the original bug

Bug

Note: Make Sure that 'component', and 'severity' labels are added
Example for how to fill out the template: #20100

1. Root Cause Analysis (RCA) (optional)

2. Symptom (optional)

3. All Trigger Conditions (optional)

4. Workaround (optional)

5. Affected versions

6. Fixed versions