How select achieves the same effect as join

[hanyisong]

mysql> select * from t0, t1;
ERROR 1105 (HY000): Code: 1002, displayText = Unimplemented SELECT JOIN yet..

[Xuanwo]

No idea so far. I am inviting @leiysky & @andylokandy to take a look.

[BohuTANG]

It needs enable the new planner for your session:
set enable_planner_v2 = 1;

https://github.com/datafuselabs/databend/blob/main/tests/suites/0_stateless/20%2B_others/20_0001_planner_v2.sql

[leiysky]

mysql> select * from t0, t1;
ERROR 1105 (HY000): Code: 1002, displayText = Unimplemented SELECT JOIN yet..

As @BohuTANG said, you need to enable the new planner. And we only support inner join with explicit join condition for now, it allows you to write a join query as:

select * from t inner join t1 on t.a = t1.a;
select * from t natural join t1;
select * from t inner join t1 using(a);

We are implementing the rest join types, you can track it in #5498.

[xudong963]

I'll support the select * from t0, t1; syntax next week in the new planner, after ready, I'll ping you @hanyisong

[Xuanwo]

Let's create an issue (or comment on the existing one) with the following information:

• Link to this discussion.
• Ping @hanyisong to notify.

[leiysky]

Here's the related issue, we don't need to create another one. #5499