stoneatom / stonedb

StoneDB is an Open-Source MySQL HTAP and MySQL-Native DataBase for OLTP, Real-Time Analytics, a counterpart of MySQLHeatWave. (https://stonedb.io)
https://stonedb.io/
GNU General Public License v2.0
865 stars 141 forks source link

bug(Tianmu): Cross-engine join will crash when two big tables do join #895

Open RingsC opened 1 year ago

RingsC commented 1 year ago

Have you read the Contributing Guidelines on issues?

Please confirm if bug report does NOT exists already ?

Describe the problem

When two big tables do cross-engine join will lead stonedb crash.

Do join with an innodb table and tianmu table. such as,

create tabe tb1 (
  col_a int
) engine = innodb;

create table tb2 (
  col_a int,
  col_b int
) engine =tianmu;

select tb1.col_a from tb1 left join tb2 on tb1.col_a = tb2.col_a; 

Make sure we can do cross-engine join.

Expected behavior

No response

How To Reproduce

No response

Environment

No response

Are you interested in submitting a PR to solve the problem?

RingsC commented 1 year ago

ref: https://mariadb.com/kb/en/column-store-cross-engine-join/