bug: group by cube with join cause panic

[b41sh]

Search before asking

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

Version

v1.2.314-nightly

What's Wrong?

group by cube with join cause panic

panicked at src/query/sql/src/executor/physical_plans/physical_aggregate_expand.rs:55:13:
assertion `left == right` failed
  left: Number(Int32)
 right: Nullable(Number(Int32))

How to Reproduce?

mysql> drop table tt1;
Query OK, 0 rows affected (0.14 sec)

mysql> drop table tt2;
Query OK, 0 rows affected (0.13 sec)

mysql> create table tt1(a bool not null, b bitmap not null, c int not null);
Query OK, 0 rows affected (0.12 sec)

mysql> create table tt2(a bool not null, b bitmap not null, c int not null);
Query OK, 0 rows affected (0.30 sec)

mysql> insert into tt1 values (true, '1,2', 1),(true, '1,2,3', 2);
Query OK, 2 rows affected (0.21 sec)

mysql> insert into tt2 values (true, '1,2', 1),(true, '1,2,3', 2);
Query OK, 2 rows affected (0.18 sec)

mysql> select tt1.c from tt1 right outer join tt2 using(b) where tt1.a group by cube(tt1.c);
ERROR 1105 (HY000): TokioError. Code: 1068, Text = Cannot join handle from context's runtime, cause: task 36594 panicked.

Are you willing to submit PR?

• [ ] Yes I am willing to submit a PR!