bug: HAVING with subquery can't find the column

[b41sh]

Search before asking

• I had searched in the issues and found no similar issues.

Version

v1.2.682

What's Wrong?

HAVING with subquery can't find the column

How to Reproduce?

root@0.0.0.0:48000/default> create table tt2 (c0 bool, c1 int);
processed in (0.297 sec)

root@0.0.0.0:48000/default> insert into tt2 values(true, 1),(false, 2),(true, 3);
3 rows affected in (0.223 sec)

root@0.0.0.0:48000/default> SELECT string_agg('a') FROM tt2 GROUP BY GROUPING SETS ((c1)) HAVING c0 NOT IN(SELECT true AS czTQb00);
error: APIError: QueryFailed: [1006]Unable to get field named "0". Valid fields: ["5", "1", "3"].

Are you willing to submit PR?

• Yes I am willing to submit a PR!