ERROR 1054 (42S22): Unknown column 't1.col1' in 'having clause'

[Alkaagr81]

Bug Report

Please answer these questions before submitting your issue. Thanks!

1. Minimal reproduce step (Required)

DROP TABLE t1,t2,t3;
create table t1 (col1 int, col2 varchar(5), col_t1 int);
create table t2 (col1 int, col2 varchar(5), col_t2 int);
create table t3 (col1 int, col2 varchar(5), col_t3 int);
insert into t1 values(10,'hello',10);
insert into t1 values(20,'hello',20);
insert into t1 values(30,'hello',30);
insert into t1 values(10,'bye',10);
insert into t1 values(10,'sam',10);
insert into t1 values(10,'bob',10);
insert into t2 select * from t1;
select sum(col1) from t1 group by col_t1,col1 having col_t1 in
 (select sum(t2.col1) from t2 group by t2.col2, t2.col1 having t2.col1 = t1.col1);

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

mysql> select sum(col1) from t1 group by col_t1,col1 having col_t1 in
 (select sum(t2.col1) from t2 group by t2.col2, t2.col1 having t2.col1 = t1.col1);
+-----------+
| sum(col1) |
+-----------+
|        40 |
|        20 |
|        30 |
+-----------+
3 rows in set (0.00 sec)

3. What did you see instead (Required)

mysql> select sum(col1) from t1 group by col_t1,col1 having col_t1 in 
(select sum(t2.col1) from t2 group by t2.col2, t2.col1 having t2.col1 = t1.col1);
ERROR 1054 (42S22): Unknown column 't1.col1' in 'having clause'

4. What is your TiDB version? (Required)

| Release Version: v5.2.1
Edition: Community
Git Commit Hash: cd8fb24c5f7ebd9d479ed228bb41848bd5e97445
Git Branch: heads/refs/tags/v5.2.1
UTC Build Time: 2021-09-08 02:29:53
GoVersion: go1.16.4
Race Enabled: false
TiKV Min Version: v3.0.0-60965b006877ca7234adaced7890d7b029ed1306
Check Table Before Drop: false |

[morgo]

Verified against master:

tidb> select sum(col1) from t1 group by col_t1,col1 having col_t1 in
    ->  (select sum(t2.col1) from t2 group by t2.col2, t2.col1 having t2.col1 = t1.col1);
ERROR 1054 (42S22): Unknown column 't1.col1' in 'having clause'
tidb> SELECT tidb_version()\G
*************************** 1. row ***************************
tidb_version(): Release Version: v5.2.1
Edition: Community
Git Commit Hash: cd8fb24c5f7ebd9d479ed228bb41848bd5e97445
Git Branch: heads/refs/tags/v5.2.1
UTC Build Time: 2021-09-08 02:32:56
GoVersion: go1.16.4
Race Enabled: false
TiKV Min Version: v3.0.0-60965b006877ca7234adaced7890d7b029ed1306
Check Table Before Drop: false
1 row in set (0.00 sec)

[Yisaer]

/assign

[winoros]

Seems that this one is something related with #26945. Let me have a deeper look.