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

     1  drop database if exists db7858;
     2  create database db7858;
     3  use db7858;
     4  CREATE TABLE t3 (S1 INT);
     5  insert into t3 values (1),(2);
     6  select * from t3;
     7  s1
     8  1
     9  2
    10  SELECT * FROM t3  JOIN t3 on t3.S1=t3.S1;
    11  invalid input: table 't3' specified more than once
    12  SELECT * FROM t3  JOIN t3 a_t3 on t3.S1=a_t3.S1;
    13  s1    s1
    14  1    1
    15  2    2
    16  create table t1(a int);
    17  insert into t1 values (1),(2);
    18  SELECT * FROM t3  join t1 on t3.S1 = t1.a JOIN t3 on t3.S1=t3.S1;
    19  invalid input: table 't3' specified more than once
    20  SELECT * FROM t3  join t1 on t3.S1 = t1.a JOIN t3 a_t3 on t3.S1=a_t3.S1;
    21  s1    a    s1
    22  1    1    1
    23  2    2    2
    24  drop database if exists db7858;