ErrBadField occurs when using Function DEFAULT with ORDER BY clause

[SunRunAway]

Bug Report

Please answer these questions before submitting your issue. Thanks!

1. What did you do?
   If possible, provide a recipe for reproducing the error.

CREATE TABLE `test1` (
  `a` decimal(10,4) unsigned DEFAULT NULL,
  `b` float DEFAULT NULL
);
INSERT INTO `test1` VALUES (1.0090,-1),(1.0090,-1);

2. What did you expect to see?

mysql> SELECT a FROM test1 ORDER BY DEFAULT(b);
+--------+
| a      |
+--------+
| 1.0090 |
| 1.0090 |
+--------+
2 rows in set (0.00 sec)

3. What did you see instead?

mysql> SELECT a FROM test1 ORDER BY DEFAULT(b);
ERROR 1054 (42S22): Unknown column 'b' in 'order clause'

4. What version of TiDB are you using (tidb-server -V or run select tidb_version(); on TiDB)?
   0ea1bf0

[gaoxingliang]

I will check this issue.

[gaoxingliang]

note if the cols exists in the select, it's okay (seems column pruned before checking sort by)

SELECT a, b FROM test1 ORDER BY DEFAULT(b);

[ti-challenge-bot]

It is not a pickable issue!

[time-and-fate]

This bug has been fixed by #19709 on master but not cherry-picked to release-4.0

[ichn-hu]

@rebelice PTAL

[rebelice]

I'll cherry-pick this pr later.

[wjhuang2016]

Close this issue because the bug had been fixed by #19709.

[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