"order by + num " can use a column not in select fields

[time-and-fate]

Bug Report

Please answer these questions before submitting your issue. Thanks!

1. Minimal reproduce step (Required)

create table t(a int, b int, c int);
select a from t group by a having sum(b) > 0 order by 1;
select a from t group by a having sum(b) > 0 order by 2;
select a from t group by a having sum(b) > 0 order by 3;

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

> select a from t group by a having sum(b) > 0 order by 1;
Empty set (0.029 sec)

> select a from t group by a having sum(b) > 0 order by 2;
ERROR 1054 (42S22): Unknown column '2' in 'order clause'
> select a from t group by a having sum(b) > 0 order by 3;
ERROR 1054 (42S22): Unknown column '3' in 'order clause'

3. What did you see instead (Required)

> select a from t group by a having sum(b) > 0 order by 1;
Empty set (0.006 sec)

> select a from t group by a having sum(b) > 0 order by 2;
Empty set (0.006 sec)

> select a from t group by a having sum(b) > 0 order by 3;
Empty set (0.007 sec)

4. What is your TiDB version? (Required)

current master (ea7f0ca)

[time-and-fate]

/assign time-and-fate

[time-and-fate]

/sig planner

[time-and-fate]

/remove-sig infra

[ti-chi-bot]

@time-and-fate: These labels are not set on the issue: sig/infra.

In response to this:

/remove-sig infra

Instructions for interacting with me using PR comments are available here. If you have questions or suggestions related to my behavior, please file an issue against the ti-community-infra/tichi repository.

[time-and-fate]

remove-sig sql-infra

[time-and-fate]

/remove-sig sql-infra