github.com/matrixorigin/matrixone@v1.2.0/test/distributed/cases/dml/select/select_issue7858.sql (about)

     1  -- fix issue 7858
     2  drop database if exists db7858;
     3  create database db7858;
     4  use db7858;
     5  CREATE TABLE t3 (S1 INT);
     6  insert into t3 values (1),(2);
     7  select * from t3;
     8  SELECT * FROM t3  JOIN t3 on t3.S1=t3.S1;
     9  SELECT * FROM t3  JOIN t3 a_t3 on t3.S1=a_t3.S1;
    10  create table t1(a int);
    11  insert into t1 values (1),(2);
    12  SELECT * FROM t3  join t1 on t3.S1 = t1.a JOIN t3 on t3.S1=t3.S1;
    13  SELECT * FROM t3  join t1 on t3.S1 = t1.a JOIN t3 a_t3 on t3.S1=a_t3.S1;
    14  drop database if exists db7858;